To only report data from the related table, base your layout on the related table. To limit the records in the report to a specific ID and date, there are two options:
1) Perform a find on the report layout for all records of a specified ID and Date. This could be done manually or in a script.
2) A script from the parent table's layout can use GoTo Related records to pull up all records linked to the current record. If this produces a found set of inspection data for more than one date, constrain found set may be used to limit the found set to records of a specified date.
Note: If you are repeatedly inspecting the same Shopping Center, it may be helpful to set up a table where each record represents a single inspection of a specific shopping center.
Thats Great, It seems to work exactly as I want it to, as far as the information that I want on the report. Thanks for that!! The only problem now is that all of the details are going into the report layout, and I cannot figure out how to get the report to save seperate files for each individual shop.
For example, Now the report sorts data form each individual shop that I inspect and when I hit preview, It shows a page per shop, and on each page it has a break down of inspections done in that particular shop. When I save as PDF it saves ALL of the pages into one file. What I would like to happen is have some sort of script (i guess) that saves each store page as a seperate PDF, and have it named using the Shop name information.
Is this possible?
You should limit your found set to just the records for that one store. Then your PDF will only include records from that one store when you save it as a PDF.
If you read my last post again, I describe two methods for limiting the records in the report for a specific store and/or a range of dates.
Lloyd, When I go to print preview and select "Save as PDF" I am able to select whether I want it to save all of the records in the found set, just the current record, or even a blank record showing no data. If I understand your question that might help you out I'm not sure. If you didn't know about it though, that is a nifty little feature!