Report Design: caryforward the broken group total to next page

caryforward the broken group total to next page

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12861
Printed Date: 19 May 2024 at 4:31am

Topic: caryforward the broken group total to next page

Posted By: melbenmartin
Subject: caryforward the broken group total to next page
Date Posted: 09 Apr 2011 at 3:05am

Hi Experts,

I have one issue with my crystal report application where in i have to sum the total of a group and carry forward the total to next page ..

------------------- Page one------------------
----------
12.12.2010 (GroupName)
----------
Description    Debit    Credit
----------------------------------------------
billing         200.00    0.00
travel        450.00      0.00
food           500.00     0.00
----------------------------------------------
----------
13.12.2010(GroupName)
----------
books      500.00      0.00
other       300.00      0.00
----------------------------------------------

15.12.2010 (groupName)
----------

ABC      600.00      0.00
XYZ      2300.00     0.00

(Here I want to display the total for this group only )
---------Page break-----------
then carry forward the total to the next page if the group countinues..

------------ Page TWO ----------------------------------
15.12.2010 (groupName)
-----------

previous page total ... 2900.00      0.00

abx                           500.00    200.00

Please help me how to perform this functionality in crystal report 2008.

Thanks in advance .
Regards,
Martin.

-------------
TechRoberts

Replies:

Posted By: lockwelle
Date Posted: 18 Apr 2011 at 3:29am

shared variable (or running total) and conditional suppression should do the trick.

Described in general terms, create a shared variable is being incremented every detail line, reset every group change. In the page header set a variable that is cleared in the detail section (so the report can know if the page has changed). If the page has changed, check the shared variable/running total, if the value <> 0, display the line, otherwise suppress it(this would probably be an added section to either the group header or the detal band...group header would be tested fewer times, so sounds like a slightly better candidate)

HTH

Posted By: melbenmartin
Date Posted: 22 Apr 2011 at 8:15pm

Hi Thanks for your reply ,

How can i find a groups details section is being moved to next page.so that i can put one details section to display page total of the group and carry forward the same to next page .

Please help me on this too.. you greately appreciated thanks a lot ..

Regards,

Martin.

-------------
TechRoberts

Posted By: lockwelle
Date Posted: 25 Apr 2011 at 8:33am

if the shared variable is not zero....if the group ends on the prior page, the total will be reset to 0. If it is a new page, a flag will be set, so the report knows that a page change has occurred. once it hits the detail section, the flag is cleared, so you need to display the value before the 'main' detail section.

HTH