Solved

The last visible group

Posted on 2011-09-12
6
300 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 100

Accepted Solution

by:
mlmcc earned 500 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 100

Expert Comment

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

mlmcc
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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 100

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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

831 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