abhi81
Programmer
- Jan 13, 2007
- 18
Hello All,
I want to fire reports based on the series of order numbers. I know i can use reportselectionformula to fire report on a single order number but how do i handle this if there is a requirement to print 50 order numbers at one time, i.e., 50 order numbers are passed as arguments and all the order numbers should be ready to print.
Each report is a separate invoice based on the order number supplied to the report.
I tried using comma separated order numbers but what happens now is that it only prints the last order number. My code is in vbscript as follows:
ordno="10000,10001,10002"
Session("oRpt").RecordSelectionFormula = "{ReportView1.order_num} in ["
&ordno & "]"
Basically now what i want is this. When the user hit the print button the report viewer should have like 3 pages of report 1 for each order number so that all these invoices can be sent to the printer for printing.
To find out the problem i opened the report in the designer and previewed it. No code. Then modified the record selection formula to get the desired result but no success.
Any help will be appreciated.
Thanks in advance.
I want to fire reports based on the series of order numbers. I know i can use reportselectionformula to fire report on a single order number but how do i handle this if there is a requirement to print 50 order numbers at one time, i.e., 50 order numbers are passed as arguments and all the order numbers should be ready to print.
Each report is a separate invoice based on the order number supplied to the report.
I tried using comma separated order numbers but what happens now is that it only prints the last order number. My code is in vbscript as follows:
ordno="10000,10001,10002"
Session("oRpt").RecordSelectionFormula = "{ReportView1.order_num} in ["
&ordno & "]"
Basically now what i want is this. When the user hit the print button the report viewer should have like 3 pages of report 1 for each order number so that all these invoices can be sent to the printer for printing.
To find out the problem i opened the report in the designer and previewed it. No code. Then modified the record selection formula to get the desired result but no success.
Any help will be appreciated.
Thanks in advance.