How to create horizontal grouped crystal report?

[sherrydeng]

The normay table we can easily creat is like below. All the groups are vertically created.

Group1
Group10 Data100 D101 D102
Group11 D110 D111 D112
Group12 D120 D121 D122
Group2
Group10 D200 D201 D202
...

We want to create a report, one of the groups is created horizontal. like

Group10 Group11 Group12
Group1
D100 D110 D120
D101 D111 D121
D102 D112 D122
Group2 ,,,,

Is there anyone familiar with this format?

Thanks a lot!

 

[synapsevampire]

you might insert a usual group, then insert a crosstab.

Hard to tell from this example of the data as it appears that you're using the same sort of entity for the row and columnar data (using the word group on both axis implies that it's the same column to me, which doesn't make sense).

-k

 

[sherrydeng]

Tried the cross-tab, it seems like it didn't work.

The actual data format we want to creat is like the followings.

Jan Feb March April,,,
Comany1 Projection 000 000 000 000
Sales 000 000 000 000
Ordered 000 000 000 000

Company2 Projection 111 111 111 111
Sales
Ordered

Company 3,,,

,,,

 

[lbass]

Why didn't the crosstab work? It looks to me like you can use {table.date} as your column field (set to print on change of month), and then use company as your row field, and then add the three summary fields.

Place the crosstab in the report header or report footer.

You should always identify your CR version by the way.

-LB