multiple textbox problem and lots of totals to report

[mmasuda]

I am trying to create a report and based it on a table "caller," which contains a field "quarter." Throughout the report this field will be refered several times.
First, I used an unbound textbox and entered a nested if-else statement, so it would detect the correct quarter. That worked fine. However, when I looked at the report, it was 12 pages long with nothing but this textbox over and over again.
Then I did some searching and found that might be able to put it into the reports header. That worked great... until I ran out of room. The header would not stretch anymore to enter more info.
This report is quiet long and I will have to use several sub-reports (I guess), as it will have to report lots of statistical information.
Are there anymore possibilities?

 

[ptpaton]

I'm not too sure what your data output is, but can you create a group header based on [quarter] and place the text box in the header? The group header will grow to whatever length it needs to.

-Patrick

Nine times out of ten, the simplest solution is the best one.

 

[mmasuda]

I used a couple of group headers and that seems to be working well.
Thank you very much