Scripting - what is the equivalent to the ActiveReports NoData() event?

Chris Dunlop

March 25, 2020 23:18

Hello, We occasionally run reports that have no records returned. If that happens, I want to display a custom message in the report header, and suppress the detail section.

 

With the old technology, I had a textbox control in the report header that was hidden. Then, in the NoData event, I made it visible. This displayed the message in the report. Also, the detail section was automatically suppressed, which it looks like it's not in Reporting 5.

 

Any ideas how I'd go about doing this in Reporting 5? I'm having trouble getting traction with the scripting.

 

Thanks!

 

Chris

0

• 

  Ryan Cooney

  March 26, 2020 00:41

  Hi Chris,

  You should be able to do this without scripting. Every element of a report (including the bands) has a Visible property that can be set using an expression. If you select the element you want to show/hide and then click the Expressions tab (the curly f on the right) you can set the Visible property to an expression like:

  [DataSource.RowCount] > 0

  or

  [DataSource.RowCount] = 0

   

  --Ryan

  0
• 

  Chris Dunlop

  March 26, 2020 15:19

  Perfect, thanks Ryan!

  0

Please sign in to leave a comment.