4 labels of 1 type then 4 labels of another on same report

[OutInLeftField]

My question is how do I do the following as an example:

Smith, James Smith, James Jim Smith
address1 address1 Profession
address2 address2 ApplicationDate
City, State City, State SSN

The address1,city,profession, etc. names are actual values from a sql command.

What I need to do is print x (user enters as a parameter) labels of the name address label and x labels of the profession number, application date. After that, the next record is printed with X labels of address, etc then X labels of profession information...

X is what the user enters on a parameter. If he/she enters 4, then 4 labels of the addressing information is printed. Then the next 4 labels are printed with the profession, application date, ssn are printed. The next record will have a different person. Then the 4 labels of the new record address info is printed, and so on...

I am totally stumped on how to do this.

Thank you in advanced...

 

[synapsevampire]

Crystal doesn't replicate data in a report, so this isn't so straightforward.

One method is to use an external table with something like:

ID
1
2
2
3
3
3
4
4
4
4

Then in your table have a columns which states the qty required, and then do a Left Outer from the above table to yours.

Other options would be to use a Stored Procedure to return the data, or you might be able to manually emulate a Label by placing the fields across and then below in inserted details sections and use formula logic to control what is printed where, it'll get a little hairy though if they choose 1 as the 3rd labels data won't be available yet and it's on the same line.

Wish I had a better solution to offer.

-k

If {?Parm} =

 

[OutInLeftField]

Can crystal support sql cursors?