Guys,
I am facing one issue. I have this query which i am running. The problem is i want to show atleast 1 row with “0” in it if the query returns no data. When the query returns no data the report is empty… i mean it shows only headers and then no rows in the report. So in this case, if report is empty i want to show at least one row with something in it like 0.
You have to create another table… with a single row hard coded…
Display this table when the query returns 0 records… and hide the original table. You have to add a boolean expression on both the tables to automatically HIDE and SHOW.
This won’t even work. I tried it before i asked this question. But i found the solution guys…i created another query with just count of rows and used case statement to say that if “count>1 then count else 0 end”.
I used this count in the bottom of the report to show atleast one field which will be count and will show 0 if there is no data.