Show geological layer name for test results on graph report

Hi,

 

Im trying to add a repeating text field to a graph report to say what geological layer a lab result is from. The layer name text is in the GEOL.GEOL_GEOL field. I have taken the code below from the SqlRange help however no text is generated on the report.

<<SqlRange(<<Lookup(<<Depth>>,<<DataSetKey(<<#>>)>>)>>,[GEOL].[GEOL_GEOL])>>

I tried adding the depth and base fields for top and bottom of the geological strata to the end of the expression and that didnt help. Am i missing something?

Thanks

 

Rob

Parents
  • Rob, it sounds like you want to know what layer stored in GEOL matches the depth of the lab sample from LAB SPECIMEN. This is very similar to Help Example 2 in the SqlRange function topic, where we look for the USCS code that matches a field sample depth in SAMPLE. In other words, we are matching the depth of the SAMPLE record to a range of top-to-bottom-depth values in LITHOLOGY.

    I believe in this case you need to specify the GEOL table Bottom field name in the function. The use of the Lookup function for each dataset key is also detailed in this Help topic - so you are essentially combining the Lookup for each repeating element with the range test where the top depth is the defauolt "Depth", but the bottom depth in the range needs to be specifed.



Reply
  • Rob, it sounds like you want to know what layer stored in GEOL matches the depth of the lab sample from LAB SPECIMEN. This is very similar to Help Example 2 in the SqlRange function topic, where we look for the USCS code that matches a field sample depth in SAMPLE. In other words, we are matching the depth of the SAMPLE record to a range of top-to-bottom-depth values in LITHOLOGY.

    I believe in this case you need to specify the GEOL table Bottom field name in the function. The use of the Lookup function for each dataset key is also detailed in this Help topic - so you are essentially combining the Lookup for each repeating element with the range test where the top depth is the defauolt "Depth", but the bottom depth in the range needs to be specifed.



Children