Wednesday, March 28, 2012

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,...

No comments:

Post a Comment