Folks,
I have created a cross tab for Applications and the counts corresponding to the year.lIEK
Like Below Structure
2009 2010 2011
Applications Name1
Applications Name2
..
..
..
Application Name10
My problem is I have around 10 application totally.
If there is no record for any of the years that any of the applications its not showing up in the cross tab.
for example if no records for the Application2 for the years 2009,2010,2011 its not showing up in the cross tab.
I want to display all the 10 application names in the cross tab and if there is no count for the particular
application need to show that application as well with zero's.
Please let me know if any way to fix this in report studio.
Thanks in Advance guys.
Raj
Hi,
Try to make the missing measure a zero value. (if [Measure] IS NULL then 0 else [Measure])
HTH
Sathish,
Thanks for your reply.
I tried but still its not showing up and also not giving the right values.
Raj
Hi,
try this one .
Select each Crosstab node Member and change source type member caption into data item value.( make it for all node members)
then select Crosstab intersection , selct data format number/currency /% then make missing value '0' (for all)
:)
If it still doesn't work, in FM change the table's relationship, where the application1, 2 etc. is coming from, to be a 0.n against the fact
Can also do this via joins in the report locally. Check this link:
https://www-304.ibm.com/support/docview.wss?uid=swg21341708
Hi,
Also remember to check that suppression is not turned on.
Rgds
Rob