Hi,
I'm not new to Jet Reports but I'm still an entry level user.
1. I am trying to build a report (using NL sheets) that pulls info from 2 tables (customer & GL Entry)then perform other calc on the data - this works okay
2. I then would like to create a second report (sheet) for each of the customers created in report#1 to pick up specific calculated fields from the first report - not working
I've tried everything and still only get results on the second report for the very first customer. The customer name and number is exactly the same eventhough it created a separate sheet for each person.
Really, I'm trying to use Jet to do a mail merge instead of creating the 2nd report manually.
Any help would be greatly appreciated.
Regards,
Michelle
Date
Votes
5 comments
-
Jet Reports Historic Posts Hi Michelle,
You can't put more than 1 sheets replicator on the same worksheet, which I assume is what you're currently trying to do. Only the first sheets replicator Jet finds on that sheet will be expanded. I'm not sure exactly how to help with the info you provided. Maybe you could be a bit more specific about exactly what you're trying to do in terms of what you're using off each sheet that you want to create more sheets from.
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
Thanks for your reply.
I am trying to put together the new attendant care report for retirement home residents. The first is a report that pulls total wages for all departments (nursing, food, housekeeping etc) and there are several Excel formulas to calculate the total that each person is able to claim based on a calculated daily rate. The claim is based on the number of days that they paid for multiplied by this calculated daily rate. Also on the report is the total that each resident has paid and how much they were each charged for rent, services, care, salon etc. (I only have 1 sheet replicator to get the customers and it works well)
I then need to prepare a stadard letter for each of those residents on a second spreadsheet - I need to pull the customer name, total payments received and the expense claims calculated on the first spreadsheet. Is there a way to create a second spreadsheet for each of the same residents in order to pull the information I need?
The alternative (and not a good one) is to create each letter manually and link it to each sheet in report mode - I don't know how this will work if I have to change the report. Short of that I guess I can create an identical report as the first one and hide all the columns and set up new columns for the fields I need? Not sure how the formatting would work on this though - maybe if I put it on the bottom of the first report?
I hope this is a little clearer. I have 7 homes and approx. 800 receipts with corresponding letter due in a week.
Thanks for any help.
Michelle -
Jet Reports Historic Posts Hi Michelle,
So it sounds like you want the letter on a different sheet so that you can easily print them all, is that right? Do you also print the sheets with the wages for all departments?
It seems like you could put a page break at the end of the wages reports and just put the standard letter for each resident on the same worksheet on a different page. Would that work? I guess maybe if you didn't need to print the first page or each sheet it might print more than you'd like.
As you said, you could also just replicate the customers again in a different workbook, do whatever calculations needed to get the total payments and expenses, then hide those calculations and just reference the result in your letter. Does one of those approaches work for you?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
I don't need to print the report only the letter so you're right it will give me lots of extra pages if I have then on the same sheet. Seeing I have to put the letters in PDF and send to others I will have to hide the calculations so I can only show the letter.
Thanks for you help.
Michelle -
Jet Reports Historic Posts Yeah in that case I would just make a new workbook and copy whatever calculations you need into it and then hide those rows/columns. You can reference the hidden cells in your letter but they won't show up when you save the workbook as PDF. That seems like the best solution for your problem that I can think of.
Regards,
Hughes
Please sign in to leave a comment.