Wednesday, December 5, 2001 11:48 PM
I am providing an option for the user to generate the report(s) either in HTML or in EXCEL. For individual reports, it is working fine as it requires only one worksheet.
But my requirement is that when the user selects the Consolidated reports i.e it is a mix of 5 to 6 reports as a single excel doc. I am getting all the 6 reports in a single excel worksheet. I do not want it like that. I want each report in a separate sheet.
Can anyone help me?????