Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: caryforward the broken group total to next page Post Reply Post New Topic
Author Message
melbenmartin
Newbie
Newbie
Avatar

Joined: 16 Dec 2009
Location: India
Online Status: Offline
Posts: 8
Quote melbenmartin Replybullet Topic: caryforward the broken group total to next page
    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
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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
IP IP Logged
melbenmartin
Newbie
Newbie
Avatar

Joined: 16 Dec 2009
Location: India
Online Status: Offline
Posts: 8
Quote melbenmartin Replybullet 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
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.000 seconds.