[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
Solved

# The last visible group

Posted on 2011-09-12
Medium Priority
308 Views
Hi,
I have a reports, in this report i have many groups, if the group is null or empty then supress, but i need put a field in the last visible group...i hope make me understand

like this

Group 1
Group2
Group 3 FIELD

Group 1
Group2 FIELD

Group 1 FIELD

Group 1
Group2
Group 3
Group 4 FIELD

Thanks

0
Question by:Crashman
• 3
• 3

LVL 101

Accepted Solution

mlmcc earned 2000 total points
ID: 36526241
With Crystal a group won't show if there are no records for it.

You could put the field in each group header and condtionally suppress with

Not IsNull(NextGroupField})

So the field in group1 would be
Not  IsNull({Group2Field})

The field in group2 would be
Not  IsNull({Group3Field})

etc

mlmcc
0

LVL 8

Author Comment

ID: 36526656
Thanks but, this only work to supress the group, i can supress the groups,
what i want is know the last visible group, but well i think is done

I use this

in the Group assistant \ group opcions \ select the group and Opcion \ i put a name for the group
and will use a parameter with the last group

if groupname({RPTD_C;1.field1}) = {?LastGroup} then
{RPTD_C;1.total1}
0

LVL 101

Expert Comment

ID: 36526687
I said nothing about suppressing the group.  Use the formula to suppress the fields themselves.

mlmcc
0

LVL 8

Author Comment

ID: 36526713
OK, that's correct but i only need to see ONLY IN THE LAST GROUP not in all visible groups
0

LVL 101

Expert Comment

ID: 36526809
I guess I don't understand what you want.

What do you mean by last group?

The formulas I provided will do what your examples showed.

mlmcc
0

LVL 8

Author Closing Comment

ID: 36529909
You had completely Right, sorry my mystake, work great!!!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Loops Section Overview
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
###### Suggested Courses
Course of the Month20 days, 11 hours left to enroll