[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 379
  • Last Modified:

ReportNet: Conditional Style...Hide Text When No Records Found...

I am trying to hide a Text item when a certain query has 0 records. I tried using a variable, which always complained that the "fieldname" could not be found. Then I tried a Conditional Style, but I can't seem to get that working either. I tried "RowNumber() <= 0" and I tried "count([QueryName].[FieldName]) = 0" and neither have worked.

Can anyone help me out here?
Ben Santiardo
Ben Santiardo
1 Solution
Ben SantiardoAuthor Commented:
I've figured out my answer.  By adding the text into a "Conditional Block" object, I was then able to create a Boolean Variable that looked for a single field value inside the table in question.  If the value was NULL (which can never happen), then I know I have no records returned by the query, so the Boolean Value is set to True (AKA No-Records), if the value is not NULL, then the Boolean Variable returns no.  I then use that Boolean Value as the Block Variable within the Conditional Block to determine when it displays.

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now