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.
Hi Jeff,
There are lots of possibilities based on your customized files, but I'll make a couple of assumptions and give a general answer. This may not work based on how your files are set up.
I am assuming you are using boundary lines in your column entities for the top and bottom of the range and that is what you want to turn off in each column if there is no text for that sample.
If that is correct then you can set the property on the boundary line tab for each column to suppress if not text data.
I would make a copy of your report to test .
Example 1
Then in report design open the column .. goto boundary line tab. ..check suppress if no text data
The pocket pen column shows this in this example
There are many ways you could have setup those lines where this may not work. If so click on my name and send me your info and I will setup a secure location to have you upload your gINT file set to look at your particular situation
Example 2
And yes if you want this all to be manual with a boolean field you would have to include that in your boundary line depth expression (s)
something like
<<IIf(<<SAMPLE.Print Lines>> = "-1",<<User System Data.Sample Bottom Depth>>,"")>>
Just an example you would need to modify based on your database etc.
Example 3
Another possibility is to use the body data output condition in the column entity under the configuration tab you could set something on the data output that would also affect the boundary lines
In other words something like
<<SAMPLE.Print Lines>> = "-1" in the body data output condition would suppress the text and also hide the line , but that would require a manual process for each sample.
both example 2 and 3 add a manual process to showing and hiding so keep that in mind
My recommendation is example 1 using the built in feature.
Answer Verified By: Jeff Geist