catchingup
Technical User
i'm working on a report in CR11 that is grouped by 2 fields. Of the detailed info, I want to show 1 of the rows in Group Header 1 - I created formulas to look for the detailed info from the specific item i want to show in Group Header 1. It works, however it will only display on the first pagre of the report. I do have the "Repeat Group Header on Top of Each Page" option turned on in the grouping.
any ideas how i can get this to display on all pages?
the format of the report is as follows:
GH1: NAME (sorted in a specific order - ANY value)
GH2: TITLE (sorted in ascending order)
Detail: {Name} {car1} {car2} {car3} (etc...)
-- I want it to display Week1, Week2, Week3 in GH1
-- I created a dummy Name with the appropriate information in the fields {car1}, {car2},etc. that correspond to the time periods i need.
-- In GH1 I have formulas that indicate:
if {Name} = "dummyName" then {car1}
*the {wk1} is the same field that contains actual info for the other names, in this case it just contains date info.
-- The correct info displays in GH1 as "Week 1" on page 1 but on the other pages it is blank.
any ideas how i can get this to display on all pages?
the format of the report is as follows:
GH1: NAME (sorted in a specific order - ANY value)
GH2: TITLE (sorted in ascending order)
Detail: {Name} {car1} {car2} {car3} (etc...)
-- I want it to display Week1, Week2, Week3 in GH1
-- I created a dummy Name with the appropriate information in the fields {car1}, {car2},etc. that correspond to the time periods i need.
-- In GH1 I have formulas that indicate:
if {Name} = "dummyName" then {car1}
*the {wk1} is the same field that contains actual info for the other names, in this case it just contains date info.
-- The correct info displays in GH1 as "Week 1" on page 1 but on the other pages it is blank.