Hi All,
I have a crosstab in my report where i have SOURCE coming from the DB.I have to implement a value '-' in place of the Volume displayed against it. The volume is 0 in the DB. The condition goes like this--If Source = 'XYZ' then Volume to be displayed = '-' .
i have tried it by making a data item called "---" which says '-' but to no use.
How can i use it as a data item or filter so that i can fulfill the condition?
The query in which this condition is expected is being unioned with another query and then displayed in to the crosstab.
I am using no filters right now although i tried to use them..but all in vain.
Please help.
Thanks,
Aditi
Go to properties : format data. You can assign - for the zero character value
Thanks for the Reply but i tried the same..i want '-' to display only for one SOURCE value.
If i replace zero characters by - then all the zeroes in d crosstab show '-' .
I will have to give a condition or something to achieve this.
Please help.
Aditi
How are the different source values being displayed? Is it something like the following?
Corner | Source 1 | Source 2
-------+----------+----------
Row 1 | 1234 | 1234
Row 2 | 1234 | 1234
If it is, create a Boolean variable:
[Source] = 'Source 2'
Set it on the measure and use that to set the data format as Ties suggested.