Skip to main content
Question

Report Designer - Avoid printing blank page

  • January 24, 2025
  • 5 replies
  • 59 views

Forum|alt.badge.img+1

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? 

 

 

5 replies

Forum|alt.badge.img+10
  • Hero (Customer)
  • 82 replies
  • January 28, 2025

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

 


Forum|alt.badge.img+1
  • Author
  • 2 replies
  • January 29, 2025

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

 


Forum|alt.badge.img+10
  • Hero (Customer)
  • 82 replies
  • January 29, 2025
jyoti.sah wrote:

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?


Forum|alt.badge.img+1
  • Author
  • 2 replies
  • January 29, 2025

Yes, I did try that but I don’t think that’s doing anything. 

 

 


Forum|alt.badge.img+10
  • Hero (Customer)
  • 82 replies
  • January 30, 2025

What does the value look like in the _REP view? Is it null or spaces? maybe use != ‘’?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings