I am currious if there is a way to hide a row if a specific cell in a report is null through either excel or Jet Reports. I have tried an if statement but that will only work once and wont loop. I know I could use VB but I think that is a little more involved than what I want to go into. I am thinking the only way this is possible is to create a sql view with all the conditions their and just pull the information that way. If anyone does know a way that I can do this just by using excel or jet reports I would appreciate it very much.
Date
Votes
2 comments
-
Jet Reports Historic Posts I understand what you're trying to do. I'm not specifically aware of any way to directly achieve what you are after.
However, I cater to this by ensuring the data that would return null is well, not returned. It adds some complexity to the queries, however it appears to work. Another option is using IF statements to substitute null for 0 if the cells are numerical and you want to avoid errors in calculated cells.
Do you have an example you can post?
cheers -
Jet Reports Historic Posts I am currious if there is a way to hide a row if a specific cell in a report is null through either excel or Jet Reports…
Is it the "Hide+?" you are looking for? Or you tried that and it doesn't work?
Hide+? should be in cell B1, so you can put your if clauses in the B column, and you have to return "Hide" to make the row hidden…
I think this is what you're looking for.
Keep us posted,
Jan
Please sign in to leave a comment.