Need help with output one field horizontally please

[Former Member]

I know I have seen some ideas and threads about this, but it is not really what I need. I have a report in CR XI that seems to be on the right path. The problem I am having is one field that needs to be in details could provide multiple results (products and services) which duplicates all the records. Some customers I'll have 3 lines, the next 9 ... depending on how many P&S they have.

What I have done is moved all fields from the details section to group1 which so far seems fine and left my P&S field in details.

The output is normal:

prod1

prod2

prod3

prod4

etc.....

What I need is this: prod1, prod2, prod3, prod4, etc.

Any ideas greatly appreciated.

In the group header add a formula

WhilePrintingRecords;

Global StringVar ProductList;

ProductList := '';

in the details

WhilePrintingRecords;

Global StringVar ProductList;

If ProductList = '' then

ProductList := else ProductList := ProductList & ', ' & ; ''

In the group footer

WhilePrintingRecords;

Global StringVar ProductList;

ProductList

Edited by: Terry Mergl on Apr 20, 2010 9:15 PM

[Former Member]

HI

If you are using a SQL command query. You can modify your query to display prod1, prod2, prod3 as columns not as rows.

[Former Member]

What you have should do it. Is there an issue? Please explain in detail, giving sample data, current results, and expected results.

Carl