How do I create this report?

[Former Member]

I have only created a couple of simple reports, and am now stumped trying to create the following. The report consists of three columns of names with each name being stored in a separate record. Each column represents the location of the individual. Any suggestions?

[former_member260594]

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

[Former Member]

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!