It sounds easy, but it has proven not to be.
In my report, I'd like to have a text string and value appear when we drive SPTs in a boring. Here's what the report looks like with an SPT drive at the bottom.
When an SPT is driven, I'd like the area in the header to say Hammer Correction Factor = <value> where the "yyy" is located.
Here's how some of my tables appear:
<<PROJECT>>
<<BOREHOLE>>
<<BOREHOLE.Sample>>
In this example, CH1 has some SPTs. The HCF is 83.5. CH2 (not shown) does not have any SPTs. On the project sheet, there's a box utilized for calculating N60. I cannot key to that, because its part of the Coordinate Fields in the Tables menu. If there's a way to link to it, this would seem to be the most straight forward, but the option doesn't even seem to exist when I try.
On the Borehole Tab, there is nothing which denotes the types of samples taken in the hole. I'd like to avoid adding anything in there, but it is a possibility.
I don't know if I could do a search in a range on the Samples tab. Check the HCF column and if any data appears, place the text. I'd just have no idea how to code that.
Anyone got any ideas?