I have a report in IFS Report Designer, and I want it to only display a table if there is data in it. Currently, if the table doesn't contain any data, the report still prints a blank space or page. How can I modify the report so that the table only appears when there is data to display? I tried playing around with page break functionality but that doesn’t seem to fix the issue.
I assume I have to set up condition but I do not exactly know how to figure out the correct expression to add there...any idea?
Page 1 / 1
It’s not clear where in the form you are working, but in general, you need to look at the data in the REP view and check for ‘non null’ value. I usually check the string length > 0. E.g. This will skip the output for the line if I put it in the table row condition
Thank you for the response.
The condition you provided is causing the output to be completely skipped, and nothing is printed at all. However, I still want the table to be printed if there is data available. The table should only be skipped if there is no data for it.
For example, if I apply the condition for the 'NOT_RESERVED_PART_ITEM' table and there’s data available, I still want the table to be printed. But if there’s no data for that table, I want it to be skipped and nothing to be printed for it. Currently, it’s printing a blank space or page instead
Thank you for the response.
The condition you provided is causing the output to be completely skipped, and nothing is printed at all. However, I still want the table to be printed if there is data available. The table should only be skipped if there is no data for it.
For example, if I apply the condition for the 'NOT_RESERVED_PART_ITEM' table and there’s data available, I still want the table to be printed. But if there’s no data for that table, I want it to be skipped and nothing to be printed for it. Currently, it’s printing a blank space or page instead
Have you tried applying the condition to the Table Cell just above the table you have highlighted in the left hand layout tree?
Yes, I did try that but I don’t think that’s doing anything.
What does the value look like in the _REP view? Is it null or spaces? maybe use != ‘’?
