Crystal XI

[Serated]

Hi,

I would like to know in crystal if it is possible to have a field running horizontal. Sample

now

1
2
3

need to be

1 2 3

 

[MWToine]

You can do this by:
1. creating a grouping (not for the field you wish to display horizontally).
2. Create a formula something like this:

WhileReadingRecords;
StringVar sID;

If Len(sID)+Len(ToText({Your#},0,'')) < 250 Then -- Note: your string can NOT exceed 254 characters. If it does, you can create additional overflow variables (sID2, sID3, etc))

sID := sID+' '+ToText({Your#},0,"")

3. place your formula in the footer section and format the field to 'Can Grow'

4. run the report. If you wish, you can hide the group header as well.

I hope this helps. Good luck!

 

[Madawc]

A crosstab would do it.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[chelseatech]

You could also set your details section to "Multiple Columns". Do this in the section expert and then specify a column width.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm