Group Level Number 1

[djmyers]

Anyone know of a way to determine the group level number of a report? Say I'm in GF3, I'd like a function to return a value of '3'. Fancier yet, Let's say GF3 was the footer of @ProductLine, is ther a built-in or custom function that would return '@ProductLine'?

 

[lbass]

In CR XI, there is a function called GroupingLevel(). Add in the field you are grouping on, as in:

GroupingLevel({table.group3field})

This will return a 3.

Not sure why you need the last function you mention. I guess you want the field name and not the field results themselves?

-LB

 

[djmyers]

GroupingLevel is new as of XI, however I'm still v.10.

Reason I need this is because I have a report that breaks, splits and summarizes at different levels, so I have some coded accumulators that reset and display at different levels. The summary functions built-in won't cut the logic... Having a function that tells me what level I'm at would make it a lot cleaner. I'd be able to get my column summaries in one formula.

Thanks anyway!

 

[synapsevampire]

You might use a formula to keep track of it.

Rather than one or two line posts, try posting example data and the expected output.

You state that you want @ProductLine', but not for what purpose, so if I did work this out for you, it still might not satisfy your requirements because you haven't posted them.

What do you need to do, and where?

Do you want the value of @ProductLine', or to display @ProductLine', or use it to determine something else?

-k