I am trying to build a report where the sheets are being generated based on a list on a previous tab. The list ("rows" statement) identifies a series of values that are related and are correctly sequenced. The sequencing is the key. Then the report tab is replicating based on the sequenced values that it finds in the list. And the "sheets" command is using an indirect function in order to pull the actual range from the list. At least that's the idea.
The problem I am encountering is that the range never updates properly. For example, if the original range for the "sheets" command is "F$8..F10", but the range ultimately expands to "F$8..F30" only the values in the first range are used.
So I guess what I am trying to do is to have each sheet execute independently and then update each sheet to the right of it. Not sure if this is even plausible. Any thoughts/guidance/suggestions would be welcome.
Thanks
David Opdahl
Date
Votes
1 comment
-
Jet Reports Historic Posts The problem you are running into is the order of operations - Jet first replicates all of the Sheets, then replicates all of the Columns and finally it replicates all of the Rows arguments.
In a nutshell, Jet has not evaluated your ROWS command to update it before it runs into the SHEETS command.
So, you either need to generate the ROWS command first, and then copy-paste that into a list to generate your SHEETS from, or you need to modify the SHEETS command to incorporate the output of the ROWS command.
Please sign in to leave a comment.