Conditional Hide has mind of its own

Questions and Answers asked by users to users, about how others use Jet Reports.

For additional "how to" information, please visit our online Knowledge Base ... ofessional
Forum rules
The Jet Reports Community forums are not a guaranteed support medium. Official support for Jet Reports is available only through the support desk at Staff responses to posts on the forum are not guaranteed.
Posts: 8
Joined: Sun May 05, 2013 4:42 pm

Conditional Hide has mind of its own

Postby Smythe78 » Mon May 22, 2017 5:23 pm


I have a NL Rows query to give me a list of products and then I have further queries to report on sales of these products.
Some of these products have no sales and therefore I want to hide the rows. To do this I have used the 'Hide+?' in column B along with a simple excel formula to generate the word 'Hide' should sales be zero.

My issue is that the report will ignore the Hide+? command and sporadically hide ALL rows in the report.

Has anybody encountered this issue before?


User avatar
Jet Reports Certified Professional
Posts: 442
Joined: Wed May 26, 2010 3:40 pm

Re: Conditional Hide has mind of its own

Postby HPDeskJet » Tue May 23, 2017 7:45 am

As a simple test, remove the "Hide+?" from cell B1 and take a look at the results of your simple excel formula in column B.

Is that formula returning what you think it's returning?
Jet 2015 Certified Trainer

Return to “How do I?”

Who is online

Users browsing this forum: No registered users and 8 guests