April 26, 2005 at 2:02 pm
I have just downloaded Service Pack 2 for SQL Server 2000 Reporting Services
I am glad I finally have a print button.
However I was wondering if there was a way to control the number of records that appear on each page in the viewer so the printed output can look like the viewer output.
=Ceiling(Rownumber(Nothing)/20) will only work with the List Object and I need the Table object because my reports have Several Groups and Group Totals. Embedding the Table Object inside the List Object doesn't work because then I get correct detail page breaks but I end up with all the group totals on every page (totaled for only that particular page).
Also Although it displays correctly in the viewer, for my reports that have many groups and group totals, it will put each group total on a separate page when printing and Exporting to .pdf. So I have a 30 page report on the viewer and when printed or exported that becomes a 117 page report. I don't want my customer to waste all that paper.
Any suggestions?
April 27, 2005 at 6:52 pm
(work around)
So instead of using group footer lines I used group HEADER lines and Now it prints and exports normally.
I think there is a group footer bug issue that causes unwanted page breaks when printing or exporting.
I'd much rather have Group footer lines so my totals print out beneath the details but in any event it's a work around
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply