Summary of a summary field - kind of.

building reports crystal reports
1

I have a report that is grouped on a field and the details have more than one record returning for the fields inside the details. I just need to check if a field has a certain value and report 1 for that group - this I can do with a Maximum summary. Problem is I cannot use this in a Running Total or summarize this function.

Example:

20 groups, 120 Returns of field being true(instead of say 19 - one missing) since its done on grouping. This feels hard to explain. Please ask for clarification if needed.

Edit - much needed visual of report. [Pseudo Report]

[Group] Id
   [Record]  0
   [Record]  1
   [Record]  1
[/Group]     {@max}= 1
[Group]  Id
   [Record]  0
[/Group]     {@max}= 0

[Report Footer]  Total of {@max}

So the total is like a summary of a summary - which CR cannot do.

DonAl (BOB member since 2015-04-29)

2

One way that might work, but not clear how you would be using this.

shared numbervar somevalue;
if {somefield} = aValue then somevalue :=1

This would work for one group, but are you wanting to do a count? Have you tried a running total with a condition?

kevlray :us: (BOB member since 2010-06-23)

3

I have tried Running Totals, but not sure about the condition or which section it goes in. Thanks

DonAl (BOB member since 2015-04-29)

4

I have edited the question. Maybe that makes more sense?

DonAl (BOB member since 2015-04-29)

5

If you want a count (not sure if that is really what you want). Here are a couple of thoughts. Create a running total and choose the field you want to check on, on the type of summary, select count. In the evaluate section, click on Use a formula and enter whatever criteria you need (Boolean value). See if that helps.

The other way is to do a manual count using a formula and a shared variable.

Shared numbervar i;

if some condition then i:=i+1

kevlray :us: (BOB member since 2010-06-23)

6

Thanks again. I will try some more stuff like that.

DonAl (BOB member since 2015-04-29)