Getting Records to Print Across

[ulicki]

Hi,

Using Crystal 7. Is there a way to get multiple records returned from the database to print across? Here are the specifics.

The report will have 2 tables, EMPLOYEE and GRANTS. Each employee can have zero to many grants (of stock options). For this problem, if it helps, we can limit the number of grants to seven, and also make the minimum one.

Now when records are returned from the database I want each employee to have his/her name along with each of the grants to be on one line. For each grant there are 5 items of information (2 of which will be calculated using UFLs).

Example below (Note each employee's grant info will be different).


Emp1 G11 G12 G13 G14 G15 G21 G22 G23 G24 G25 G31 G32 etc.

How can this be done?

Thanks,

 

[Ngolem]

yes but you will have to have on a separate line

Emp1
G11 G12 G13 G14 G15 G21 G22 G23 G24 G25 G31 G32 etc.

in the Section Expert for the detail line there is a check box to print the field horizontally

Jim

 

[Ngolem]

oops...don't think this option exists in CR 7

the only other way I know is to store the results in an array and then create display formulas to display each array element