Question on displaying a given type of result set in crystal

[kinosaidp]

Hi,

I have a result set of records which needs to be displayed in crystal as shown below. I'm using Crystal 11 and sql2k as backend.

Record set
COL_A COL_B COL_C COL_D COL_E
1805 150XXXX 8/4/2007 0 100
1805 150XXXX 9/4/2007 1 200
1805 150XXXX 10/4/2007 2 300
1805 150XXXX 11/4/2007 3 400
4021 150ZZZZ 8/12/2007 0 100
4021 150ZZZZ 9/12/2007 1 200
4021 150ZZZZ 10/12/2007 2 250
4021 150ZZZZ 11/12/2007 3 400
4021 150ZZZZ 12/12/2007 4 600

*************************************************
Proposed Crystal report layout
COL_A COL_B Aug Sept Oct Nov Dec
1805 150XXXX 100 200 300 400
4021 150ZZZZ 100 200 250 400 600


thanks.

 

[lbass]

Insert a crosstab in the report header or report footer that uses ColA and ColB as rows, ColC as the column (also click on group options->print on change of month), and ColE as the summary field. If sum doesn't work right, use a maximum.

-LB