on 01-17-2013 10:57 AM
Hello Alvin,
It might be easier to group on column field and then format the details section to be multi column > down then across (in the section expert). Set the width of the columns so that 3 columns will fit on the page.
Set the group footer to print at bottom of page (again section expert) to force the next group header to start on the next column.
Regards,
Graham
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Alvin
Here’s one way of solving your puzzle.
Create a formula that collects the names into a set of variables. Something like this . . .
Formula name: _Detail_Variables
Whileprintingrecords;
Shared stringvar 6N_names;
Shared stringvar 6B1_names;
Shared stringvar 6B2_names;
If [LOCATION]=”6N” then 6N_names:= 6N_names & [NAME] & “<BR>” else
If [LOCATION]=”6B1” then 6B1_names:= 6B1_names & [NAME] & “<BR>” else
If [LOCATION]=”6B2” then 6B2_names:= 6B2_names & [NAME] & “<BR>”
The <BR> is a HTML tag that will cause a line break after each name.
Place the above formula in the details section . . . . then suppress the details section.
Next, create three formulas that will display the value for each variable. Something like this . . .
Formula name: display_6N_names
Whileprintingrecords;
Shared stringvar 6N_names
Formula name: display_6B1_names
Whileprintingrecords;
Shared stringvar 6B1_names
Formula name: display_6B2_names
Whileprintingrecords;
Shared stringvar 6B2_names
Place these formulas in the report footer. Right-Click the formulas in the report footer and set the text interpretation to HTML.
You also may want to create a Group and place the formulas in the group footer.
Hope this helps!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.