[Webinar] Streamline your web hosting managementRegister Today

x
  • 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?
0
Ben Santiardo
Asked:
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.
0

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