Getting pagewise totals in reports

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Getting pagewise totals in reports

Author

Topic

jim_cool
Starting Member

43 Posts

Posted - 2005-12-14 : 04:36:34

hi all
i have a report in Matrix(Cross-tab) format
i will like to have pagewise total for all columns
how can i do this.
if i am giving total then the total is displayed only on last report page , bur i want pagewise total for alll columns.

plz help me.

jhermiz

3564 Posts

Posted - 2005-12-14 : 16:31:07

quote:
Originally posted by jim_cool

hi all
i have a report in Matrix(Cross-tab) format
i will like to have pagewise total for all columns
how can i do this.
if i am giving total then the total is displayed only on last report page , bur i want pagewise total for alll columns.

plz help me.

Your matrix report should have a group by, you can then sum for each group (or page depending on your needs) we will need more info btw as to how this report is built, the sql behind it...whether or not you have more than one group. Why you are saying it totals on the last page? Have you set page breaks after a certain group, etc etc etc.

Just the basics ... so we can understand the issue more.

Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]

jim_cool
Starting Member

43 Posts

Posted - 2005-12-15 : 00:00:08

I have a matrix report in which Product Name is on left & mmonth names apper on top.

i have given total for Months(column) & products(row).

for row total there is no problem .

but for column total the report displays total only on last page of report.

when the report is run it spans 2 pages. The total for all month columns is displayed only on second page but I want it to be displayed on first page as well for the data that appear on first page.

Also there is no page break.

Plz help me.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-12-15 : 03:58:12

Does SQL Server Report support Formulae?
If so, consider this
In Crystal Reports, three formulae can be used to display page wise total

Formula1 @Reset having the code
numbervar pagetotal;
WhilePrintingRecords;
pagetotal:=0;

Formula2 @Sum having the code
numbervar pagetotal;
WhilePrintingRecords;
pagetotal:=pagetotal+{table_Column};

Formula3 @Display having the code
numbervar pagetotal;
WhilePrintingRecords;
pagetotal;

Now,
place Formula1 at Page Header and suppress it
place Formula2 at Details Section and suppress it
place Formula3 at Page Footer and dont suppress it

If possible try to simulate the same in SQL Server Report

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources