columns in report (2000)

Topic

New Reply

I have a report that I made columns in using bound controls (no labels) and the page setup columns option. But I need a column of “lables” to print only once on the left side of the report.

Ex.
Facility (label) Fac. 1 Fac.2 Fac.3
question 1(label) 5% 10% 20%

I only have a report header & footer, and detail section.

Any ideas?

Reply | Quote

Replies

I would not add any labels in this case, but add three unbound text boxes in the detail section. The first will count the detail records (Control Source =1
Running Sum Over Group
Visible = No).
Name this first box “CounterBox”. The next two textboxes use an if statement as the control source. Second textbox: Control Source =IIF([CounterBox] = 1, “Facility”, “”). Third textbox: Control Source =IIF([CounterBox] = 1, “question 1”, “”). The second and third textboxes will now be your labels, and will only show up for the first detail on each page. Note: in the if statements above, the second argument is quotequote(no spaces). Set the font on textbox two and three, anyway you like, to get the desired visual results.

Reply | Quote

Thanks so…this worked beautifully!

Reply | Quote