format horizontal 1

[codrutza]

Hi
I am working with CR XI on Sql Server db.
My data looks like this:

bamboo-21/09/2005 - mov1
- mov2
- mov3
-23/08/2005 - mov4
- mov5
cape - ......

I want to format them like

bamboo-21/09/2005 - mov1,mov2,mov3
-23/08/2005 - mov4,mov5

I have a group on name (bamboo), a group on date; mov...are in detail; all data are in one table.

I don't want to use format with multiple columns, because I want to print the mov at the right of the page.
Is it another way I could do this?
Or could I write an SQL, procedure which I could use for bring me the data like this?
Thanks

 

[lbass]

First drag the Group Header #1 groupname and the Group #2 groupname into the Group Footer #2. Then create three formulas:

//{@reset} to be placed in the Group #2 header:
whileprintingrecords;
stringvar mov := "";

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

//{@displ} to be placed in the Group #2 footer:
whileprintingrecords;
stringvar mov;
left(mov,len(mov)-2);

Then suppress the group headers and the detail section.

Next, insert a running total {#cntwingrp} that chooses count of {table.name}, evaluate on change of group (date), reset on change of group (name). Then right click on the Group #1 groupname (which is in GF#2)->format field->common->suppress->x+2 and enter:

{#cntwingrp} <> 1

-LB

 

[codrutza]

This is great
Thank you