• 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")…
  • 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…