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

x
?
Solved

The last visible group

Posted on 2011-09-12
6
Medium Priority
?
308 Views
Last Modified: 2012-05-12
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
Comment
Question by:Crashman
  • 3
  • 3
6 Comments
 
LVL 101

Accepted Solution

by:
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

by:Crashman
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

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

mlmcc
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
LVL 8

Author Comment

by:Crashman
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

by:mlmcc
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

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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question