Report Design: about seagate crystal report 7

about seagate crystal report 7

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=10241
Printed Date: 05 May 2024 at 8:39am

Topic: about seagate crystal report 7

Posted By: n__n
Subject: about seagate crystal report 7
Date Posted: 14 Jun 2010 at 1:26am

how can i get the detail field from group footer.

i want to sum all this detail amt to footer.

can i refer to detail field like this report.detail.field{report_name} in formula field in footer????

i have main table m which contain one ID one amount

another table detail d which contain item for this ID.

after joining table m and d there is many amount field duplicate.

in detail

-------------------------

ID item amount

001 A 300

001 B 300

001 C 300

now i have adjust the amount in detail because there is many duplicate amount within ID.(i have adjusted in formula for the amount in detail section)

after adjust detail

--------------------------

ID item amount

001 A 300

001 B 0

001 C 0

but footer i sum the amount field as belows:

footer:

-----------

totol: 900 (<-- should be 300)

now i would like to get the detail amount so that the total should be 300+0+0= 300

how can i do this????

Replies:

Posted By: kevlray
Date Posted: 14 Jun 2010 at 5:09am

Are you doing a group (by item?)? Are you doing a running total? If so, are you only evaluating when the group changes? If so, then the total should be correct?

Posted By: n__n
Date Posted: 14 Jun 2010 at 3:48pm

after i did a running total , it becomes 900

i would like to sum all display value that is 300+0+0 in the goup footer(group by ID)

as one ID have many item so group by ID ensure one total amount

actually, i already created a formula field in detail

how can i sum that field in group footer

Posted By: lockwelle
Date Posted: 15 Jun 2010 at 4:11am

if you already have a formula field, create a shared or global variable and increment that when it should be. Then in the footer, reference the variable in new formula, like:

shared numbevar aVariable

This will display the variable's value that has been incremented in the formula in the detail section. If there are more sections to be processed, remember to reset the variable to zero where needed:

shared numbervar aVariable := 0

HTH