Outputting query results visually (eg as site plans)

Not knowing your data structure it is difficult to give you a specific solution.  However the general procedure would be as follows:

Create a graph report with <<Point.East>> set as the Independent data (X axis) and <<Point.North>> set as the dependent data (Y-axis).  This will plot your borings in a simple x-y plot.  You can control the data markers as much as you want.

Then in the data postings tab of the graph entity add a line for the boring number <<Point.PointID>> at 12:00 and a line for:

<<Min(<<SAMPLE.Depth>>,<<SAMPLE.SPTN>> >= 50)>> at 6:00

This will plot the boring number above the point and the depth to the first SPTN value that is greater than or equal to 50 below the sample. You can get fancier if you want.  See example below.

Note that the expressions used are based on my data structure, table names, and field names.  Yours are likely different and you will have to modify the expressions accordingly.  Further, if you need to calculate the SPTN from other fields (rather than reading it directly from a single field) the above simple aggregate function will have to be replaced with a Sql function. If this is not what you are looking for please clarify your question.

Not knowing your data structure it is difficult to give you a specific solution.  However the general procedure would be as follows:

Create a graph report with <<Point.East>> set as the Independent data (X axis) and <<Point.North>> set as the dependent data (Y-axis).  This will plot your borings in a simple x-y plot.  You can control the data markers as much as you want.

Then in the data postings tab of the graph entity add a line for the boring number <<Point.PointID>> at 12:00 and a line for:

<<Min(<<SAMPLE.Depth>>,<<SAMPLE.SPTN>> >= 50)>> at 6:00

This will plot the boring number above the point and the depth to the first SPTN value that is greater than or equal to 50 below the sample. You can get fancier if you want.  See example below.

Note that the expressions used are based on my data structure, table names, and field names.  Yours are likely different and you will have to modify the expressions accordingly.  Further, if you need to calculate the SPTN from other fields (rather than reading it directly from a single field) the above simple aggregate function will have to be replaced with a Sql function. If this is not what you are looking for please clarify your question.

Thanks. That's perfect. Took me a bit of playing around with the parameters in the properties and working out the expressions required but got there in the end. I KNEW there must be a way!