"Simple Text"

I am in Graphic Tables, trying to reference a borehole location. I have used <<POINTID>> and the only borehole I get is B-1, I have tried using <<Atterberg.PointID>> which gives me B-2, and I have tried <<Sieve.PointID>> which gives me B-6. I have also copied and pasted the text to a buffer and also made a new text and copied and pasted the Text Expression and still does not work. I am curious why is it doing this and how can I fix it. I also wanted to show the depth range instead of just the starting depth, I have set up an equation to do this that works in all of the other outputs but one. I have copied and paste it in a text and also copy to buffer and pasted it. Either way the only depth that I had show up is 1-2.5'. I want to know why it is not working on ths one page.

  • You may need an SQL query to collect information from multiple tables, since you are already using the <<PointID>> keyfield in your expression without success.

    gINT Help has a lot of examples and description of SQL usage under several topic headings. Check the Help Contents Functions chapter for functions beginning with SQL, also the Input chapter under Queries. There is an example Graphic Table report that can be freely downloaded from this site (under WIKI / Downloads... / General Purpose... / Graph Report Examples).