• Output Condition

    Pedro
    Pedro
    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")…
    • 6 months ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Re: Mysterious empty lines in Lists/Component Descriptions

    Pat Cummings
    Pat Cummings
    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…
    • over 10 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Re: Mysterious empty lines in Lists/Component Descriptions

    Pat Cummings
    Pat Cummings
    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…
    • over 10 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Re: SQL function in report.

    Pat Cummings
    Pat Cummings
    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>>-…
    • over 11 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Re: If Statement

    Pat Cummings
    Pat Cummings
    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…
    • over 11 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Re: More than one Foreign PointID Expression

    Pat Cummings
    Pat Cummings
    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…
    • over 10 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Re: More than one Foreign PointID Expression

    Pat Cummings
    Pat Cummings
    "...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…
    • over 10 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • Calc Function Fails if One of the Calculated Fields is Empty

    Pat Cummings
    Pat Cummings
    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…
    • over 11 years ago
    • OpenGround | gINT | Keynetix
    • gINT Forum
  • View related content throughout OpenGround | gINT | Keynetix
  • More
  • Cancel