Hi,
We are using crytsal report version 8.0. In Report designer I am using Cross Tab and have the
"Dealnames" in the row.
"Products", "months" in the columns.
"Amount" in the summary.
The data is as follows
Dealname Product Date amount
D1 P1 01/01/01 10$
D2 P2 02/01/01 20$
D3 P1 02/01/01 30$
I want to show all the months in the quarter i.e if there is no record for that month I want to atleast populate it with a zero.
In the example of the data given above, I get records for Jan and Feb in the crosstab. The problem is as there is no record for March it does not appear in the cross tab. I want to populate March with a zero.
Is there a way I can do this in a cross tab ?
OR can it be done via sql query or stored procedure ?
Appreciate any help.
Thanks
Satyajit
We are using crytsal report version 8.0. In Report designer I am using Cross Tab and have the
"Dealnames" in the row.
"Products", "months" in the columns.
"Amount" in the summary.
The data is as follows
Dealname Product Date amount
D1 P1 01/01/01 10$
D2 P2 02/01/01 20$
D3 P1 02/01/01 30$
I want to show all the months in the quarter i.e if there is no record for that month I want to atleast populate it with a zero.
In the example of the data given above, I get records for Jan and Feb in the crosstab. The problem is as there is no record for March it does not appear in the cross tab. I want to populate March with a zero.
Is there a way I can do this in a cross tab ?
OR can it be done via sql query or stored procedure ?
Appreciate any help.
Thanks
Satyajit