How to display conditional comment

[wossenhh]

Hi, I am running a report daily and QV provides me data’s with straight tables. I want to display a comment like ‘No data’s for today’ when there is no data from the database instead of displaying blank tables. Any help with that? Thanks, Wossen

[its_anandrjs]

Hi,

Go for Custom Error Message from chart properties >> Click on the error messages button and you get many messages.

Regards

Anand

[#3]

Hi Wossen,

when there is no data from Source, the table in the script will not be loaded.

So check for table and set a flag.

In QVW use a text box to show, if (Flag='Y','No data from Data source').

If you want to show in every table then show using Custom Error message Property

[#4]

Hi,

In general tab condition you have error messages there you can write some condition

[its_anandrjs]

Another approach is use a variable

LET vRow = NoOfRows('TableName');

And take a text object in layout option write If( $(vRow) <= 0 ,1,0 ) and put this text box in the top to the chart so when there is 0 row loaded in the model this text object display 'No data from Data source'.

I assume a example here

When there is no data then it display

With Data

For text object write like

Regards

Anand

[jpenuliar]

Agree on this one

[wossenhh]

Hi Anand,

Can you please post the QVW file?