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.
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.