Report on 1 Page
Is there a way to get the report on 1 page, regardless the size of the page.
Ok, more details, i'm having a crosstab that replaces an excel sheet.
This report is almost never printed, it's used for screen consulting.
So the users prefer to have it on 1 page, but setting the page dimensions on
custom and (ex) size 20000 by 20000 gives a nasty preview, because the
reports sometimes is 500 on 2000 or 3000 on 2000 (depending selections).
Any suggestions ??
Ok, more details, i'm having a crosstab that replaces an excel sheet.
This report is almost never printed, it's used for screen consulting.
So the users prefer to have it on 1 page, but setting the page dimensions on
custom and (ex) size 20000 by 20000 gives a nasty preview, because the
reports sometimes is 500 on 2000 or 3000 on 2000 (depending selections).
Any suggestions ??
This discussion has been closed.
Comments
Unfortunately ReportBuilder was originally designed to generally be a
printer-based product. It may be possible to dynamically change the custom
page size if you are able to do so before the report prints.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
I guess you could run it and output it to excel or something.
Then open the file and determine the number of rows and
columns. Based on this you can estimate the width and
height of the page and run it a second time to the screen.
Thanks,
Brett