Suppress line in N-value vs. depth graph

Hello - we plot N-values vs depth on our logs.  I would like to give the user the option to suppress a line between two points.  I was hoping I could do this with a linetype field in the SAMPLE table, but when I added that, and then used the <<SAMPLE.LineType>> as the line type override in the plot, it changed all the connecting lines instead of just the one where I populated that field.  Any ideas how to make this work by each sample?

Parents Reply
  • Make a test Plot Vs Depth and try it with the following settings to see if it achieves what you need 

    Assuming you are plotting a single fileld in the sample table called "N value"

    In the lines tab of the plot vs depth use the suppress line segment expression (something like this as I don't have your full database)

    <<Sql(Select [SAMPLE].[N Value] _
    From [SAMPLE] _
    Where[SAMPLE].[Type] <> "SPT" _
    And [SAMPLE].[PointID] = '<<SAMPLE.PointID>>' _
    And [SAMPLE].[Depth] = <<PrevDepth(_
    <<SAMPLE.Depth>>,_
    <<SAMPLE.Type>>_
    )>>_
    )>>

    Then in the Plot Groups tab of the Plot vs depth entitiy also set the Group by field to 

    <<SAMPLE.Type>>

    No Guarantees test lots of data scenarios on a test report before putting into production

Children
No Data