Need to use a concatenated footer field in a heading title

[siboyd07]

I have a concatenated footer that takes each group heading and combines them all to one field. I found the formula on this site. I need to use this field in a heading but
I can't seem to get it working. The field is reset once I try to reference the field in the heading formula. I'm trying to get a heading that will reference each group in the heading. The groups will change based on a parameter. The 3 formulas to get the concatenated works great. For example

Group 1 A
Group 2 B
Group 3 C

Concatenated field formula becomes A / B / C (which now should become part of my heading field). Does anyone have any suggestions?

Thanks
Sandy

 

[lbass]

Please show the content of your formulas and explain in what sections they are placed. Then explain in which group header you want to show the results.

-LB

 

[siboyd07]

I moved these around everywhere and I can't get the @displayed value to end up in the header. It works like it should in the footer. I even tried to remove the @reset from the report and it still didn't work.

Group 1 is WHcode (suppressed)
Group 2 is whcode

//{@reset} for the group header: in Report Header
whileprintingrecords;
stringvar x;
if not inrepeatedgroupheader then
x := "";




//{@accum} to be placed in the detail section: In Group Header 2
whileprintingrecords;
stringvar x := x + GroupName ({AIRCRAFT_HDR.WHCODE})+" / ";





//{@display} to be placed in the group footer: In Group Footer 1
whileprintingrecords;
stringvar x;
trim(x);

 

[lbass]

I am not following this. Which set of group instances are you trying to show in a header? Group #1 or Group #2? Also your groupnames look the same to me except for case.

You cannot use a variable to collect the results for a header section--plus you have the reset formula in the wrong section.

You could add a crosstab in the report header that uses the group as a row. You can add some summary and then suppress it and remove the grid.

-LB

 

[siboyd07]

The two groups are the same. I just added one because the instructions said to suppress one of them. I hadn't thought about a crosstab as a heading so I'll try that. That might be the simplest method to accomplish my goal.