Creating my own Summary (Stats) Table
Help needed: I need to create custom summary reports. I need to have the same information that a summary report is producing, but I need it in a table report format so I can use it with Juiced Doc...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendDo you also have an items table which holds the unique values for the items such as
Frosted Flakes
Lucky Charms
Cheerios
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Frosted Flakes
Lucky Charms
Cheerios
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Yes we have an Inventory Table
------------------------------
Michael Knecht
------------------------------
------------------------------
Michael Knecht
------------------------------
- MarkShnier__YouI think it can be done if you are printing a single location at a time. Are you printing just one location at a time via Juiced or are you making say a batch print.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- Single Location
We tried inserting the Summary Report into the subtable and it actually provided a helpful error (most errors are not friendly) with the fact that it needed to be a table report.
------------------------------
Michael Knecht
------------------------------- MarkShnier__YouDepending on your familiarity with URL formula fields, I can try to help you here or else we can get on a consulting call for an hour and get this working more quickly.
I started to type out the steps here but there are quite a few of them.
The concept would be to make a focus record to hold the focus location. Then via that single record table coax the focus location and date range down to the sales detail table.
Then make summary fields up to the items where the location and date match the focus.
Then have an embedded report of items on the location record where they have sales > 0. Use that on the Juiced EF+ setup.
Probably alter the Juiced button to set the focus and then create the PDF
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------