Columns with multiple valuse per line 1

[DonErnesto]

I'm trying to create a report with 4 colums Per your help, I've right clicked on the details section and selected multiple columns and modified the width to produce 3 columns.
So far so good. Unfortunately, the values in the last row need to appear multiple times within the same column.

I've set up header groups for State, Account_Exec and City.
But need multiple cities to appear in the print line for each Account_Exec's territory. The results need to appear like the format below, only in each column.

State
Account_Exec
city1, city 2, city3

Would appreciate help

Thank you.

 

[synapsevampire]

It seeme like you want multiple columns within a column.

Not much to this report, no values or sums, I'd just create a cross-tab, unless there's something you've not shared here...

It's generally best to post example data, environment info., and expected output (showing the sample data, not column names).

-k

 

[DonErnesto]

Thanks synapsevampire. I'm working on Crystal Reports version 8.5. You're absolutely right, all I need is multiple columns within a column. As you pointed out there's really not all that much to the report itself, which added to my frustration.

The records have a layout like

State AE City/Territory
IL A J Dold Chicago
IL A J Dold Rockford
IL A J Dold Springfield

The report should look like

Illinois
A.J. Dold
Chicago, Rockford, Springfield

Naturally, each city is from a seperate record.

I'll look into the cross tab. As you can tell I'm a CR novice.

 

[synapsevampire]

An alternative would be to set up a variable to concatenate the cities, and just group by State and then AE

In the AE Header use a formula:
whileprintingrecords;
stringvar Cities;


In the details use:
whileprintingrecords;
stringvar Cities := Cities+{atble.cities}+","

In the AE footer use:
whileprintingrecords;
stringvar cities;
left(Cities,len(cities)-1)

Suppress the AE Header and the Details

This has a 254 length limit in CR 8.5

-k

 

[DonErnesto]

Dear synapsevampire,

I've tried the above approach and it actually looks like it will work better than a cross tab. Is there any way around the 254 character limit? Some of the Account Execs have a large territory with thirty cities or towns.