I need some suggestions of a need to build a custom report. I have a SQL Database 2008 R2 that has several tables within the DB. My users enter data in tables such as "Personal Info", "Vehicle Info", "Memo" and "Expierence".
I need a way, to build a query for say the person's name in the person table and the resulting custom report will place the data from that person and related linked table data on a viewable or printed page. I would need to initially create the look of the report and the results of the query will fill the fields of the report.
This is much like MS Access will allow you to design a report to print. I am not looking for a tubular or row of data reporting, I can do that without an issue. It is the type of report that I need to place the data in sections of the custom report with the data fields in each section.
If there is a free or low cost version of custom reporting tool (other than Reporting Services from MS)?
Does anyone have any suggestions that will assist me?