cancel
Showing results for 
Search instead for 
Did you mean: 

How to refer to a certain Group Field

former_member424792
Participant
0 Kudos
69

Hello and thank you in advance. I have a report that I am grouping a particular field in, in the report footer I have a text box that I need to suppress if a certain word shows in any of the group headers. To explain a little more, I am grouping by tracking information. In the group expert I select the grouped field and select options. I am sorting by specific order, each group has multiple tracking for each group header. So the groups displayed has 2 or more tracking fields. I have a total of 5 headings I need to see but not every stage has information so that group name is not showing up. SO I created a text box with the name of the groups and I need the text box, that is in the report footer, to show if a certain tracking name is missing from my groups.

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Matt,

You'd need five variables - one for each Group Name.

Place this formula on the Details section:

If OnFirstRecord then

(

     shared booleanvar grp1 := false;

     shared booleanvar grp2 := false;

     shared booleanvar grp3 := false;

     shared booleanvar grp4 := false;

     shared booleanvar grp5 := false;

);

     If GroupName({Group_Field}) = 'First Value in the specified order' AND {Tracking_info} = 'Track Value to be searched' then

     shared booleanvar grp1 := TRUE

     else If GroupName({Group_Field}) = 'Second Value in the specified order' AND {Tracking_info} = 'Track Value to be searched' then

     shared booleanvar grp2 := TRUE

     else If GroupName({Group_Field}) = 'Third Value in the specified order' AND {Tracking_info} = 'Track Value to be searched' then

     shared booleanvar grp3 := TRUE

     else If GroupName({Group_Field}) = 'Fourth Value in the specified order' AND {Tracking_info} = 'Track Value to be searched' then

     shared booleanvar grp4 := TRUE

     else If GroupName({Group_Field}) = 'Fifth Value in the specified order' AND {Tracking_info} = 'Track Value to be searched' then

     shared booleanvar grp5 := TRUE;

Assuming you have five text boxes (each with names of the five groups), you need to add a conditional suppression formula that refers to the shared variables.

For e.g. Text box 1 that has the name of the first group, would use this formula:

shared booleanvar grp1;

Text box 2 would use:

shared booleanvar grp2;

and so on..

-Abhilash

former_member424792
Participant
0 Kudos

Thank you, the only thing different I did was remove the AND {Tracking_info} = 'Track Value to be searched' . I am not sure why this was included, can you please help me understand?

However it is working and I am very thankful.

abhilash_kumar
Active Contributor
0 Kudos

I thought you wanted to search for certain 'Tacking Info' in each of those Five Groups.

Anyway, glad it works!

-Abhilash

Answers (0)