• Nested IFF statement not outputting correctly.

    I have the below IFF statement meant to control the width of the Soil Description column in my boring log. <<IIf(<<HasData(<<UVOST_SCREENING2.SIGNATURE TYPE>>)>> AND <<HasData(<<PID_SCREENING.Concentration>>)>> AND <<HasData(<<WELL_DETAILS.Well_ID>…
  • How to get elevation values to decrease with depth, not increase.

    Hi, in the output the elevation depths increase with depth, not decrease. Can someone please advise how to address this / instruct the report design ?
  • How to make water level icon and data appear in output?

  • Can't reference fields from Alignments table in fence reports

    Hi, I'm changing layout of my fence report and I want to reference a text field from GINT_ALIGNMENTS table but fence report doesn't show any text after placing it in the report. I also tried to show the AlignID field with same result. Are these fields…
  • Ground Water Elevation Arrow not Appearing on Report

    I am having trouble getting the ground water arrow to appear on my report. I have currently entered a ground surface elevation at 1295 ft in the Input tab. When I enter a number such as 2 into the "Ground Water Elevation" in the Input tab, it should…
  • Paths to bitmaps...

    Hi all We have a number of reports that output photos on them (TP Logs, Core Photo logs etc) Related to my previous post, gINT seems to store the paths to the bitmaps in the format "F:\Geotechnical\g254\photos\tpphotos\tp1spoil.jpg" with F:\ being…
  • Prompt in SQL list

    Hi all, I don't know if I'm being terminally stupid (very probably) but... I have a Graphic Table Report to output Concrete Cube Test Results, tested on a date specified at output via a Report Var. CUBEDATA being the parent table with data about the…
  • Date SQL Query Not Working

    Hi all, Phil Wade helped me with the SQL for this query the other week and it worked fin, until now! It goes like this:- A non-SI based gINT setup for concrete cube testing. Data about each cube is stored in the CUBEDATA table, including Date created…