Percent Fine/Sand/Gravel

Megan, are you talking about 1) the list of different-sized particles in the description of material on the report, 2) different percentages of those components listed in separate columns on the report, or 3) different percentages of those components listed in a single column of the report? When it is possible, there is no simple way to do it.

If it is 1), and you are reporting values from a soil component table, I believe there is a way to adjust the order for each sample, using an expression in the Component Formatting Library Table . I'll leave that issue open, in case another gINT user has already done this and wants to share.

If it is 2), you have the problem of how to handle switching the columns when the order of sizes differs from one sample to the next, and I don't believe it would be possible.

For 3), I can see using an expression that includes a SQL statement with an ORDER BY clause, and again, I'll leave that issue open, in case another gINT user has done it and is willing to post it in this Forum.

Megan, are you talking about 1) the list of different-sized particles in the description of material on the report, 2) different percentages of those components listed in separate columns on the report, or 3) different percentages of those components listed in a single column of the report? When it is possible, there is no simple way to do it.

If it is 1), and you are reporting values from a soil component table, I believe there is a way to adjust the order for each sample, using an expression in the Component Formatting Library Table . I'll leave that issue open, in case another gINT user has already done this and wants to share.

If it is 2), you have the problem of how to handle switching the columns when the order of sizes differs from one sample to the next, and I don't believe it would be possible.

For 3), I can see using an expression that includes a SQL statement with an ORDER BY clause, and again, I'll leave that issue open, in case another gINT user has done it and is willing to post it in this Forum.

It is part of a component description. The fields I need to adjust are just the percent columns which are integers. The gravel and sand number are in separate columns and the silt and clay value is calculated based on the gravel and sand.

So the gravel and sand numbers are entered in fields in the component table, then the report calculates the silt/clay percentage from the values entered into the gravel and sand fields in INPUT, correct?

This is correct.

One other question ot answer (similar to Phil Wade's question)... Is the "gravel" "sand" "silt and clay" fixed text or is it entered in your data table? Same thing for the angularity and the "coarse to fine" size associated with the sand component.  Are there other associated modifiers such as gravel size, hardness, and shape that need to be included in the description (and associated with a particular component in the proper order) but are not shown in your example?

I can envision several ways to do this but I would not say any are "simple".  I have delt with this issue (Placing primary component first in a description) but in a very different way.  I deal with it on the field input end and deliver the sorted component description directly to gINT but dealing with it post input might be just as easy or better.

Edit 6-15-2012

To be clearer, I need to know what fields you have in your data table that are included in your component description.  The reason being that in your example you have not only switched the order of the percentages but also switched the order of text associated with those percentages (the "sand", "gravel", "silt and clay" in front of the percentage).  Though you have not done this in your example,  I would assume that you also would want to switch the order of specific descriptors associated with each fraction.  For example, the angularity is associated with the gravel fraction and should move with it.  As shown in your example the angularity in the reordered description appears to be associated with the silt and clay fraction.  Same thing for the sand size (the "fine to coarse" in your example) and any other descriptive fields that need to be associated with a particular fraction.

The approach would be to define blocks of assembled text for each fraction (gravel, sand , and silt-clay) and then move the entire block based on the percentage of each fraction.  Without knowing more about your data it is hard for me to get more specific.  It would not be simple but I do not see any insurmountable obstacles at this time.

I'm on a similar page as Scott.  I think you need to generate a list, like this:

Let(_

 UnsortedList = _

 "70|silt and clay 70%//25|subangular to subrounded, fine to coarse sand 25%//05|gravel 5%"_

)>>

where // separates the constituents, and | separates the sorting number from the formatted constituent description

Then sort the list using the function <<SortList()>>

Then iterate through the list, and generate the comma separated formated paragraph.  Use the functions <<Iterate()>> and <<GetListItem()>>