Hello Sir, I want to get the data for example if data is present in the description then data should come else NA should appear.
<?if:Description2=' '?> NA <?end if?><?if:Description2='Description2'?> Description2 <?end if?>
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
For this, I think there is no need to apply if-condition in the RTF report. You can modify your query using the NVL() function for the description field. Below is an example:
Now, if the description is null, NA will be printed.
Swarup
I am using this statement in RTF template in BIP publisher word docs.
Vinish Kapoor
You are using Shared Components > Report Queries; if yes, then the above solution will work. If not, then I don't know that approach you are using.