Storing Values in Variable Fields in a Subreport

[ldalessio]

Good Morning All.
I have a file by room and course - some rooms have one record and others two. I want to read the file and move the first course to variable field 1 and if there is a second course, move that field to the variable field 2. The subreport is grouped by room and I am outputting the results on the group footer. Here are the calcs I am using and I put the formula in the supressed detail section....
whileprintingrecords;
global stringvar period1;
if {SCLRP.CLREXFPRD}='01' then period1:= {SCRRP.CRRSHORT};
period1

The result is that the last record by room is being outted to both variable fields.

Any thoughts??
Thanks.

 

[lbass]

Well, where is the second variable declared? Why are you using variables? What are you trying to do with these values once they are established? Why is the subreport a factor here?

-LB