August 5, 2009 at 11:31 pm
[font="Verdana"]
Hi,
I have a report which would display 30 records per page using grouping.
When downloading the report into excel, it is acutally creating as many number of worksheets in accordance with the number of pages in the report, 30 records per page.
But, I want 15000 records per sheet but for the HTML report 30 records.
Can you help me out on this...
Thanks,
Daniel
[/font]
August 6, 2009 at 8:47 am
To the best of my knowledge there is no way natively to do this in RS. You could hack around it by creating a parameter for the report where the user "tells" you that they are going to Export to Excel. Then you can use this parameter to set the page break in the grouping appropriately, 30 for normal viewing, 15000 for Excel. Of course this also means the user has to choose Excel twice in order to get the data the way they want. The other option is a second report for download to excel.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply