I'm a new Jet Reports user with minimal training. I have several simple reports that use different tables that I want to combine into one summary report. I tried pasting a second report onto the same worksheet as an existing report, but this didn't work. Is the best practice to put each report on a different worksheet in the same workbook, then pull the required data onto another spreadsheet which then be the actual report?
Date
Votes
3 comments
-
Jet Reports Historic Posts Do you have an example you can share with us? It'll help us to better understand the reports you're looking at combining!
cheers -
Jet Reports Historic Posts What I want to create is a report that I can run at the end of a month that would show bookings, backlog, sales and recievables broken down by Branch (my Global Dimension 1). I have booking and backlog reports that I have created. How would I combine these? The two reports are attached.
-
Jet Reports Historic Posts If each report can stand alone, you should have no trouble placing it in 1 file as long as you use separate worksheets.
I have a report that is sent out every day showing the previous day's activity. It has about 8 tabs in it. The first worksheet is the summary that just pulls cell references from each of the other worksheets.
Tab 2 - what shipped yesterday
Tab 3 - Order Backlog
Tab 4 - New orders from yesterday
Tab 5 - Payments received
Tab 6 - Income Statement summary (MTD, QTD, YTD)
Tab 7 - Rolling average of # of daily orders
Tab 8 - POs Received
Tab 9 - POs Sent out
The report takes a while to run - 15 minutes or so for our relatively small business. It provides good visibility to multiple aspects of the business.
Please sign in to leave a comment.