Display Default Data

drewsheez

Hello!

I have a report (please see attached image - censored for privacy purposes)setup that uses multiple queries. One for Patient Demographic/Visit information, and another for documented data on the Patient. I have patient demographics at the top of the report, and documented data in the middle. I have used tables with filters to associate with the correct patient. In the table, there are multiple data values where data may or may not be present for the specific patient in question. I am able to map data to specific values when it exists for the patient, but cannot seem to figure out how to display a value if no data is found for that specific value. I have mapped the value where it is equal to "" and to where the value is NULL and the report still displays a blank field.

Are there any ways to dislpay a default value if no data exists for a field, or would I be able to perform something like an if/else statement on the field where if data exists, display that value, else display a default value?

Thanks in advance for any information!
Drew

KavithaD

Hi drewsheez,


for the dataset column you can do some thing like this showed below,double click on the data set column
in expression click on fx icon,
there you can write if else condition

if(dataSetRow["STATUS"] == null){
dataSetRow["STATUS"] = "default value";
}else{
dataSetRow["STATUS"] = dataSetRow["STATUS"];
}

Hope this may help you.

Thank you,
Kavitha