Skip to Content
avatar image
Former Member

Display Message When Report is BLank

HI All,

Could someone tell how to display a message (No Records to Display in the Report) in BOXI report when report output is empty or blank.

Regards,

Ram

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 07, 2016 at 10:55 AM

    Create this variable and try:

    [Custom Message]=If(NumberOfRows([Query 1])=0) Then "No Records to Display in the report"

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 08, 2016 at 12:51 PM

    Hi Ram ,

    In addition to Kuldeep input , you can place this variable in a cell and show /hide the cell depends on number of rows query pulled .

    you can even use application.alert() html to get the pop up screen.

    Thanks

    Sateesh

    Add comment
    10|10000 characters needed characters exceeded