PlaceHolder in a Cross Tab

[mcrisf]

I have a Cross tab with Product (1 level) and Models (2level) in Columns and Sales Reps in Rows.Amount Sales as Measures
For all the SalesReps i dont have Amounts for some Models (ex.MOD3)...I would like to have anyway a place holder for these Models, eventually to show 0 as Amount.
Any idea??

ex.
PRODUCT1
MODEL1 MOD2 MOD3
SALREP1 10 11 0
SALEREP2 100 120 0

 

[synapsevampire]

If one exists for any of them it should show up with zero listed, if you don't have any for them, it will not.

Crystal displays the data you retrieve, it doesn't make up data.

If you post your software version and database used, you might find some options available, such as using a LEFT outer join from the models table to the current recordset to get all models, but you need to post basic technical information.

If you have a dba, ask them about this being performed on the database in an SP or View.

-k

 

[mcrisf]

thx for the answer ..i have crystal rep X and SQL server 2000. I made my view and i linked it in crystal.
I will try with Left outer join...