This content has been marked as final. Show 2 replies
Instead of Null you can show strike through. By Doing this procedure.
Go to Column Properties of all the columns which have nulls. But, still wanted to represent them on report.
Column Properties -> conditional Format -> 'Select the same is equal to null ' -> it opens edit format window change effects from default to strike through.
This should resolve your issue.
Do it for any kind of view.
Try to create a new logical column in rpd and write a case statement which turns the null values to '0' else same value.
Firstly tnks for this answer....
In fact my problem is not with the null value in column...
I explain :
The columns of crosstab is a column based on a calcul wich can result in 1 to 7 values(wich represent intervalles of delay : <1days,<2days,...<7days), this values depends on the data found in the database.... My wish is to fix the columns of my crosstab(always show the 7intervalles even if there is no measure result wich corresponds to the intervalle )
For more detaills:
In my report i count per month the transaction which doesn't exceed 1days, 2days, 3days.....7days....
In database i have some month with just requests which doesn't exceed 1days...the crosstab in this case shows just one interval instead of 7