StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Building on Mikhail's and Chuck's suggestions, I think the best method for this particular project is going to be to build the contents of a .csv in a global field and then Export Field Contents. The basic outline of what I'm doing:</p> <pre><code>Go to the first record Loop WriteTheRows (see below), comma delimited, to a global field Set $thisGroup to the count of records summarized by this summary field Exit Loop If Get (CurrentRecord) + $thisGroup >= Get (FoundCount) Go to record [Get (CurrentRecord) + $thisGroup] End Loop Export Field Contents [global field] </code></pre> <p><strong>WriteTheRows</strong> is a custom function that does the following: The output I'm trying to write can be sorted by up to 7 different criteria at the same time (for example: I could summarize supplier sales by quarter or I could summarize quarter sales by supplier)</p> <pre><code>Compare the highest level sort field's value to the last value we found for the highest level sort field. If they're different WriteALine to the global field for this sort field, the next sort field, all sort fields down to the lowest level. If they're the same, compare the (highest level sort field - 1) to the stored value for the (highest level sort field - 1) If they're the same, WriteALine to the global field for the (highest level sort field - 1) on down to the lowest level sort field ... repeat until we're down to the lowest sort field </code></pre> <p><strong>WriteALine</strong> is another custom function which adds the appropriate labels, commas and values using the GetSummary ( revenueSummary ; Evaluate ( "summaryField" & summaryFieldNumber ) as Chuck suggests in his answer.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload