I have several forms that I need summarized in a printable document.
For instance
Parent Doc Form = Name
Child Doc = Vehicle
Child Doc = House
Child Doc = Child
Child Doc = Spouse
Child Doc = School
So what I need is to print a report on each person regardless of how many vehicles, houses, children they may have or not have. This will be a paper report that can be on multiple pages. I need to make it as easy for the end user as possible (ie print report button). I would bring over different fields depending on what child docs exist.
A user could say I want a full report on Charlie Brown and then they would highlight the parent doc and click Full Report and then have a summarized document of all the information that may have been provided in the database on Charlie Brown.
We are using R7 and windows XP. Any ideas? I would buy a 3rd party tool if necessary.
Thanks,