Sometimes our rock/soil samples come back from the lab without compression, etc. results. The lab still runs a moisture on it. All of this data goes in the db, but the moisture isn't reported on our log. Currently, alll the associated lines print on the log even when there's no reportable data (moisture only). Here's what it looks like in the db.
This is what the reporting area looks like.
What I want is for those empty sample lines not to show up on the report.
I know I could create a HasData function based on whether I've entered information, but i feel like my best option, as shown in the graphic at the top, is to use a Do Not Print true/false check box in case I want to use either for SPT or when we have data and I don't want it to print.
1. I'm not sure which particular area in the report design I need to place this (some of that terminology still confuses me). It almost seems like I will have to place my check in multiple places in the report design (both for text, like elevation, and for the line)
2. What specific format do I need to use for the IIf function? How do I reference the true/false in the checkbox. Is it =True? (i.e <<SAMPLE.Do Not Print>>=True).
I don't know why this is confusing me so much.... Seems like it should be easy to do, and my brain has quit.