Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying Records Horizontally in Crystal Reports .NET 1

Status
Not open for further replies.

sfujii

Programmer
Nov 28, 2005
4
US
Hi,

I'm trying to get records to display horizontally all on one line separated by a comma, instead of the vertical default. Could someone help me out?

NY
NJ -> NY, NJ, CT
CT

TIA!
 
You need to accumulate the records using a formula like the following:

//{@accum} to be placed in the detail section:
whileprintingrecords;
stringvar states := states + {table.state} + ", ";

//{@display} to be placed in the footer:
whileprintingrecords;
stringvar states;
left(states, len(states)-2)

If you are accumulating for display in a group footer, then use a reset formula in the group header:

whileprintingrecords;
stringvar states := "";

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top