• Output Condition

    I need to give an exit condition for an object in a report in which the field is text, I apply the following but it doesn't work: <<Calc(<<TABLE.Field>> = "4-MP.-blablablabla")>> It doesn't work for me either: (<<TABLE.Field>> = "4-MP.-blablablabla")…
  • Importing and excel file with multiple sheets

    I am currently trying to optimize my time using gINT, by importing borehole data from excel into gINT. I've already done the practice exercise, and understand how to use the expressions to pull data from excel. The issue is, the current excel workbook…
  • Trouble with an IFF Statement.

    I have the statement <<IIf(<<ANALYTICAL_RESULTS.Analyte>> = "VC",<<ANALYTICAL_RESULTS.RESULT>>,"False")>> I am using this as a conditional statement to show groundwater results for a certain analyze. This statement keeps resulting as False when I…
  • Is there an Expression that will test for specific text ?

    Hello, I am trying to add a condition in our log report, in the USCS Symbol column, not to print out the data there if the Sediment Type field at the same depth contains the text "Similar to above". I tried the following: <<IIf(<<STRATIGRAPHY.Sediment…
  • Load multiple rules Modules

    I have a general piece of code used in many of my rules modules. To clean it up I have tried to move the code to a Public Sub. My problem is how to activate the second rule module. -- I have found the error, never mind..
  • Re: Mysterious empty lines in Lists/Component Descriptions

    Mike, I just had the same experience with a ListBuildSepTrim function that included a CompDesc expression. The solution in that case turned out to be: Use a Component Description Format table to build the complete list of elements (instead of ListBuildSepTrim…
  • Re: Mysterious empty lines in Lists/Component Descriptions

    Diezdaux, how are you entering the bottom of borehole line? Is this entered as a "bogus" lithology entry at a depth below the bottom of the hole, or is it handled by the report as a boundary text element? The former can be caused by the same issue as…
  • Re: SQL function in report.

    You are so close! The IIf clause has an optional "if not true" argument that follows the argument when the conditional is true. So your expression: <<IIf(<<METHOD.Description>><>"SPT/C",_ <<Format(<<CALC((<<METHOD.Recovery>>/(<<METHOD.Bottom>>-…
  • Re: If Statement

    Megan, is the field name in BASIN FILL really "Gravel Size (largest)"? Or is that a caption for that field? Also, the condition you are testing against is a text value, so it needs to be delimited with quotes: = "boulders", for example. Finally, the expression…
  • Re: More than one Foreign PointID Expression

    PeeKee, please let us know how you plan to use the associated points - will they simply be listed in the report, or will you use the foreign point(s) as a source of other report information? For example, you can use different foreign PointIDs as the…
  • Re: More than one Foreign PointID Expression

    "...I’d like to show CPT and lab test results [for] up to seven associated points for one borehole..." So in that case, you will probably need a loop from 1 to the count of the associated points to establish a single value for the list item position…
  • Calc Function Fails if One of the Calculated Fields is Empty

    An experienced user asked why the expression <<Calc(<<DRILLDATA.Depth>> + <<DRILLDATA.Length>>)>> only appears to work when there is a Length value in the DRILLDATA table. (The Depth field is required, so it would not be empty.) ANSWER : The “Calc…