Sort Horizontally

[jvolden]

I am using Crysal reports 11 and would like to know if there is a way to sort data horizontally. The normal sort will sort dates in the list vertically, but I would like them to all show up in a row and be sorted.

Examples:
Normal Sort: PH
D 7/1
D 7/2
D 7/3
PF
What I want:
PH
D 7/1 , 7/2, 7/3
PF

Thank you for your help.

 

[lbass]

This isn't really a sort issue. You first need to sort by the date field and then create these formulas:

//{@accum} to be placed in the detail section:
whileprintingrecords;
stringvar dates := dates + totext({table.date},"M/d")+", ";

Then in the report footer add this formula:

//{@display}:
whileprintingrecords;
stringvar dates;
left(dates,len(dates)-2);

Then suppress the detail section.

If you want to do this at the group level, then put {@display} in the group footer, and add a reset formula into the group header:

//{@reset}:
whileprintingrecords;
stringvar dates := "";

-LB

 

[jvolden]

Thank you very much

 

[jollyreaper]

Wow, I post my question and then see this! Seems like it might be close to answering my question. Would there be anything I should do different here?

http://www.tek-tips.com/viewthread.cfm?qid=1105897&page=1

 

[lbass]

I would try the crosstab first.

-LB