Hi All, i would like to get the data from my database as attached image, but somehow the jet report not get data as my expected
I cant figure out which part is wrong….
From the example.. it only get TestPlan number 30, but… no result show for testplan31…32….
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi -
From looking at the screen shots, the issue may be that your inner-most nested NL function is having to filter on the results of *BOTH* of your two outer NL functions.
This can get problematic as Excel attempts to keep the cell references correct during replication.
Whenever using multiple, nested replicating functions, a best practice is to ensure that any cell references in your nested functions refer to a cell on the same line. This is accomplished by what has commonly been referred to as a "cell workaround". This is done by adding a column to your report that copies a value from another column in that same line. Then, subsequent cells in that added column refer to the value in the cell above.
That sounds complicated (although it's really not), so let's look at an example:
In this example, I am copying the value in H14 to cell C14. Then, C15 gets a copy of that value, C16 gets a copy of C15, etc.
Then, my (inner most) function in G17 can reference the value in C17 (same row!) instead of M14.
This technique might resolve the issue you are having.
More information about building Grouping reports can be found in the Grouping and Subtotaling article in the Jet online knowledgebase and also the Multi-level Grouping and Subtotaling Tutorial -
Jet Reports Historic Posts Just an idea: Maybe a simple "show" at the beginning of the anker line, right under the 3 shows you already got (Cell C17), might do the trick as well, maybe :)
Please sign in to leave a comment.