Reportnet Question: Download Questions PDF
Suppose we want to display zero when null values coming to report how can we do that?
Answer:
You can follow this procedure :::
Lets assume revenue is the field in which we have to display null values as 0.
First create a calculated item and
Then write the expression of the cal item using If Then Else construct as
If (Revenue is null) Then ('0') Else(Revenue)
I think u can easily understand this.
Now u can see that the null values r displayed as '0' in the calculated item.
Select the data item in which you want to replace null with 0 .Go to Properties pane, Click Data Format, in this put 0 in Missing value Characters.
Lets assume revenue is the field in which we have to display null values as 0.
First create a calculated item and
Then write the expression of the cal item using If Then Else construct as
If (Revenue is null) Then ('0') Else(Revenue)
I think u can easily understand this.
Now u can see that the null values r displayed as '0' in the calculated item.
Select the data item in which you want to replace null with 0 .Go to Properties pane, Click Data Format, in this put 0 in Missing value Characters.
Download Reportnet Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How to drill through from a powerplay cube to reportnet? | What is the use of tabular model, tabular SQL, tabular reference in real time application? |