Is there a way to retrieve a limited number of records but not singularly? A listing of sales to customers for max of 5 item numbers but a complete listing of all of those items. So the report would show max of 5 items but all that were purchased in a given period. For example, 5 items but 100 lines for item one, 200 for item 2, etc., stopping after item 5.
Date
Votes
2 comments
-
Jet Reports Historic Posts Best way to do this would be a grouped report - first create your query for the top 5 items, and use LIMIT=5 in the formula.
Instead of ROWS, use ROWS=2 - this will allow your rows command to capture both the first line and the second line as it replicates (if you stopped here, you would get 10 lines of output - a line for each of your five items, with a blank line between each line of data).
But we're not stopping here :)
Assuming your first command (the ROWS=2) is in Cell D5, in D6 enter =D5 (so it will always reference the cell directly above)
Now in Cell E5, build a ROWS command that uses the value in D5 as a filter, so it only reports on those items to give you your lines of purchases.
See the Grouping and Subtotaling tutorial for a more clear example: http://kb.jetreports.com/article/AA-00519/0/ -
Jet Reports Historic Posts Thanks. solved it. =nl("filter","item","no.","no.",$C$2,"limit=",5,"link=","item budget entry","item no.","=no.","item no.",$C$2), where C2 are items.
Please sign in to leave a comment.