PDF
Hello, I am running into a weird problem in my soil boring logs. Each interval has 4 blow counts that is entered into the project database and then pulled into the soil boring template using the following code:
<<ListBuildSepTrim(_ <<cr>>,_ <<FirstData(_ <<ListBuildSepTrim(_ -,_ <<SAMPLE.Blows 1st>>,_ <<SAMPLE.Blows 2nd>>,_ <<SAMPLE.Blows 3rd>>,_ <<SAMPLE.Blows 4th>>_ )>>,_ <<IIf(<<SAMPLE.Pushed>>,push)>>_ )>>,_<<IIf(<<HasData(<<SAMPLE.Blows 3rd>>)>>,_ <<DelimitData(_ "(",_ <<User System Data.N Value Text>>,_ ")"_ )>>,_ <<DelimitData("(",<<FirstData(<<SAMPLE.N-Value Override>>,<<SAMPLE.Blows 2nd>>,<<SAMPLE.Blows 1st>>)>>,"<<User System Data.In Mm Label>>)")>>_)>>_)>>
However, if there are two or more intervals in a row with the entry 0 for each blow count (ie., Blows 1st = 0, Blows 2nd = 0, etc), only the first interval will print 0-0-0-0 on the log. The subsequent intervals will be blank. I need each interval to display the 0-0-0-0. Can you help me figure out how to fix this? Thanks!
Hi Stephen,
This looks like a custom expression. Not everything in the expression is visible, but nothing jumps out as an issue. There are many other parts of the entity on the report that may come into play. Things like the Depth expression, output condition, other properties. One item you might look at is in report design .. Double click on the text vs depth entity and open its properties.. goto the configuration tab and see if remove repeated text is checked ..if it is that is probably the issue.
If that isn't it then please privately send me the library and project files so I can look at all of the coding involved and how the data is entered. kirk.johnson@bentley.com
Answer Verified By: Stephen Dronfield
That was the problem! Thanks so much!