I need to be able to create a report that I can once a month email directly to vendors with their different KPIs. I already have these report built, but I dont know how to consolidate them into one report.
Thank you for taking the time to help me out.
Make a new table called Monthly Report KPI.
Add 1 record to it even though you have no fields yet.
It will be Record ID# 1.
In a details table with one of your reports make a formula numeric field and make the formula be 1.
Now go back to your Monthly Report KPI record and add a Report link field to connect the 1 in the Record ID# with the 1 in your Details table. Set the records to appear directly on the form and set the form properties to use the report that you built.
You may have some challenges with the Report Breaks as they will cross pages. You can probably get around this by putting say 5 report link fields on the form but use form rules to only show report lnk 1 on record ID 1, and report link 2 on record ID 2, using form rules. Then you could print the records all at once by printing the report by saying to print 1 record per page. Then print that to a PDF "Printer" and you are all set.