Cyrstal 10 - ODBC
I have a crosstab report that is run daily with each row representing a store location and each column the sum of all sales for each department. The report look similar to this:
Dept1 Dept2 Dept3 Dept4 Dept5
Store1 500 490 970 210 0
Store2 390 900 870 150 50
Store3 600 650 700 200 75
and so on. On some days one of more of these stores will have no sales (or no sales entered) at all and it skips that stores row, which I have grouped in a certain order in the Cross Tab expert options. Even if no sales are present for a store, I would like it included in the report with all zeros present instead of just skipping that store completely.
Is there anything I can do to make that happen?
I have a crosstab report that is run daily with each row representing a store location and each column the sum of all sales for each department. The report look similar to this:
Dept1 Dept2 Dept3 Dept4 Dept5
Store1 500 490 970 210 0
Store2 390 900 870 150 50
Store3 600 650 700 200 75
and so on. On some days one of more of these stores will have no sales (or no sales entered) at all and it skips that stores row, which I have grouped in a certain order in the Cross Tab expert options. Even if no sales are present for a store, I would like it included in the report with all zeros present instead of just skipping that store completely.
Is there anything I can do to make that happen?