Fadi Qatanani
Top achievements
Rank 1
Rank 1
Fadi Qatanani
asked on 02 Mar 2010, 06:41 PM
Hi;
I have a report using crosstab and it works perfectly.
However, I want now to have it display a list of records where total is zero (just like what a left join in SQL do when it displays zero sales for one sales person for a specific product! like in http://www.w3schools.com/sql/sql_join_left.asp)
Is they anyway to do so.
Thanks
I have a report using crosstab and it works perfectly.
However, I want now to have it display a list of records where total is zero (just like what a left join in SQL do when it displays zero sales for one sales person for a specific product! like in http://www.w3schools.com/sql/sql_join_left.asp)
Is they anyway to do so.
Thanks
1 Answer, 1 is accepted
0
Hi Fadi Qatanani,
It is working the way you need even now - we've tested with our CrossTab demo report by hiding the Bikes category and adding a single record which would have no sales for those bikes and it is displayed in the crosstab nevertheless (see attached screenshot).
Best wishes,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
It is working the way you need even now - we've tested with our CrossTab demo report by hiding the Bikes category and adding a single record which would have no sales for those bikes and it is displayed in the crosstab nevertheless (see attached screenshot).
Best wishes,
Steve
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.