[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 309
  • Last Modified:

The last visible group

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
Crashman
Asked:
Crashman
  • 3
  • 3
1 Solution
 
mlmccCommented:
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
 
CrashmanAuthor Commented:
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
 
mlmccCommented:
I said nothing about suppressing the group.  Use the formula to suppress the fields themselves.

mlmcc
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
CrashmanAuthor Commented:
OK, that's correct but i only need to see ONLY IN THE LAST GROUP not in all visible groups
0
 
mlmccCommented:
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
 
CrashmanAuthor Commented:
You had completely Right, sorry my mystake, work great!!!
0

Featured Post

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.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now