How to make Sub total will be first the first record in next page

I have a report with 1 group per page.

I need Sub Total from Group footer in page 1 will be Subtotal in Group Header in Page 2 (or viewing in Group Header in Page 2), Sub Total from Group footer in page 2 will be Subtotal in Group Header in Page 3, and so on...

How to implement it...Plase help me, urgent.

Thanks Before,

AgusHave you tried to use shared variables?One way to solve the problem is to calculate running total in group footer and assign the value to shared variable.Then you could split group header where top section would display shared variable and bottom section would be used to reset it.|||Dear Denan,...

Thanks for your suggestion.
Actually i never used shared variabel. Would you like to help make an example formula code where is it using shared variabel.

Thanks before,

Agus|||Hi Agus
Well,as I said one formula should be placed in group header.Here you display your total and reset it.Formula would be something like this.
shared numbervar Total;//This is your shared variable
numbervar out;//temporary variable

out:=Total;//Assign total to temporary variable
Total:=0.0;//Reset Total
out//Display result

In group footer you calculate running total and assign that value to shared variable which will hold it until CR passes through group header next time

shared numbervar Total;//Shaerd variable must have same name as in header formula
Total:=#YourRunningTotalName

I hope this helps|||Thanks Denan,...

How to make footers page number appear when i print the report

I have the footer with the following in it,

**********************************

= " Page " & Globals!PageNumber & " of " & Globals!TotalPages & " " & String.Format(Globals!ExecutionTime, "dd-MM-yyy uu:mm")

********************************

When i view the report it shows the page number and time, but when i print it does'nt appear at all on the print paper( page number and time)

is there a trick to make it appear on the print.

Thank you very much.

Reddy,

I'm going to assume you have the above code inside a textbox expression with in your footer. There is no smoke and mirror involved in displaying page number in the footer. I would suggest checking the textbox to make sure visible is true, check footer for printonfirstpage is true (in case there's one page), also go to the print view of the report to see if it shows up there.

I hope this helps.

Ham

|||You might have it too far down. Sometimes it cuts it off if you place the textbox too far down.

How to make Column headers footer and the image repeat in all pages of report

Can you please help, i want to make the column headers, footer and the image repeat in all the pages of the report.

if my report has 5 pages then in all pages i want the image appear plus all the column names and footer to appear in every page.

Thanky ou very much for the information.

Hi,

If you are using Table in your report,For the table there are two properties

RepeatFooterOnNewPage->True

RepeatHeaderOnNewPage->True

Hope this helps.

|||Perfect Thank you Mahima.|||How is this done for when you export to excel? When I export with page breaks between my top level group, it renders fine on the report server and every page has the table header. But when I export to Excel the table header doesn't show up on the seperate pages/worksheets.
Any ideas?