I have set up a variable, to what I believe, is capturing the first value in the sorted group. The value is the title of the course.
I have set up another variable to capture the change. The group GF2 can have a changed value. Sometimes, there are 7 or more different names.
Since Group Footer 1 (GF1) is already set up the way I want, calculations are correct and sorted correctly; all except for having the name for course, ending in 001 or the lowest of the names grouped to be displayed. This was the request.
The formula: @TitleFor001 is holding the name for the course ending in 001. If a course ending with 001 does not show, I'm in trouble.
The formula @LastTitle shows all other values
The formulas work in GF2. I have tried to modify the formula @NewTest so that the value of @TitleFor001 would display. No luck.
The goal to to place the title associated with the lowest level course next to it's shortened value in GF1.
Page 3 of the attached shows an example where no value is next to record 35 and page 6 has an example where there are several versions represented and the first value is not written next to record 79. There are several misses throughout the example.
I will need to replicate the same in several sub reports. This is a subreport and all the values which needs to be passed are passed.
I have tried following a previous example using variables, but could not follow it. course-report-10-7-11-.pdf Formulas.doc Course-Report-10-7-11-CH.rpt