c++builder-6quickreports

Unable to create a QuickReport portraying a one-to-many relationship in C++ Builder 6


I am attempting to create a report using QuickReport in C++ Builder 6 and cannot produce the results I require.

I have attempted to create this report in two ways with marginal success. I've detailed one attempt below as it appears to be the most promising. I am new to QuickReport and have no idea where else to look for help. The documentation I've found online at http://www.quickreport.co.uk/ is minimal and does not adequately explain how to use the product beyond extremely simple reports.

The report should be formatted as such:

Attempt 1: Two queries separating Manufacturer and Product data

Result: This almost gets me what I require. It displays every Manufacturer properly, however it only displays the first Product for each Manufacturer. I'm not sure if I'm incorrectly expecting the Sub Detail band to iterate through the results as the Detail band does, or if I'm missing some other necessary step to make it work. I've also considered using Loop or Child bands, but neither appear to offer the functionality I expect. Again, I can't seem to find decent documentation explaining QuickReport at all.

In the end, I can't determine if I'm expecting functionality QuickReport doesn't offer or if I'm thinking about this all wrong.


Solution

  • The solution:

    The part that really threw me off was the "magic" that occurs wherein you needn't specify the parameters between the data source and the query for Products. It appears that if you specify a parameter required for a query pointing at a dataset then the query will look for a field sharing that name and match them.

    I hope this helps someone down the road.