Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

repeating formulas in group header

Status
Not open for further replies.

catchingup

Technical User
May 11, 2006
37
US
I'm using CRXI and have multiple groups in the report. I want to display the outcome of several formulas on all pages of my report. Currently these formulas are in Group Header 1. I get the outcome on the first page but the items will not repeat on the subsequent pages. I have the "Repeat on every Page" option turned on for the grouping - but it appears that it is only repeating the group name and not the other items.

any suggestions on how I can get these to appear on all pages?
 
You need to share the contents of the formulas in the group header.

-LB
 
The group header 1 that I have formulas in which i want repeated is sorted in specified order by Name. the specified order is to look for the specific name "Labels"

The formula for each label is as follows:
Label 1 --- if {Name} = "LABELS" then {Label1}

So the row in GH1 looks like this:

GroupName#1 {@Label1} {@Label2} {@Label3} (etc)

These labels define time periods which exist in a stored procedure.

Let me know if more info would be helpful.
Thank you.
 
The formulas are evaluated for each page.

I suggest that you use a formula in the report header of:

whileprintingrecords;
stringvar Out:="";
if {Name} = "LABELS" then
Out:={Label1}

Then repeat that formula in the group footer.

Now in the group header use:

whileprintingrecords;
stringvar Out

-k
 
I think you should put the conditional formulas in the detail section so you can see what displays. I'm guessing that the values are not found in each row, and therefore will not show up in the group header unless the next record contains that value.

So instead of using your current conditional formulas in the group header, you could place them in the detail section and insert maximums on them at the group level. This should ensure that they appeat in the repeated group header.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top