Orientation of results

[Former Member]

Is there a way to list records within Crystal horizontally as opposed to vertically? For example, I am running a report which shows new purchases for the last month. The report is grouped by customer name. I would like Crystal to list the results side-by-side instead of one on top of the other. Any suggestions?

[Former Member · Accepted solution]

Will select expert if I only want a horizontal listing for multiple records under the same customer?

Here is my current report format:

CUSTOMER MODEL

Jane Doe xp550

John Doe xp500

John Doe xs490

Here is what I would like my report format to look like:

CUSTOMER MODEL

Jane Doe xp550

John Doe xp500 xs490

[Former Member · Accepted solution]

I meant to say "section" expert. Basically, I want Crystal to recognize when the customer name is a duplicate and throw the result beside the existing record, as opposed to created a whole new line for each record.

[Former Member · Accepted solution]

With some clever formating you might be able to do it.

Start with grouping on the customer, and having the group header containing the customer name underlay the detail line, and then format the detail line to be multiple columns. Then play with it and see what you come up with.

Debi

[Former Member · Accepted solution]

Sounds like you're looking for concatenated string of all models for a given customer. Something like this should work...

WhileReadingRecords;
Global StringVar g;
Global StringVar m := IF g <> {TableName.Customer} THEN {TableName.Model} ELSE m & ", " & {TableName.Model};
g := {TableName.Customer};
m

It should give you results similar to this...

Jane Doe xp550
John Doe xp500, xs490

HTH,

Jason

[Former Member]

if you have your records in the details section you can go to the section expert and select format with multiple columns, then select the layout tab and format the width between