Report Design with built in Report Writer

[owyn999]

Right so, I've got a report that I wrote a few months ago and just now we started using it. This report is a dynamic report coded mostly in Visual basic with all of the fields being can shrink and can grow true.

The issue that I am having is that I have a section of the report which had to be a subreport, and while this shouldn't be an issue I think I have done something wrong in the creation of the subreport.

This it the report with one record open, as you can see the section that is un-redacted is working fine here. The problem that I have is that once I select to open more than one record that particular section pulls all the selected records and prints them one after another. I do want the field to expand but I run into the problem of having the repeating subreport.

So in short, I would like to know how to fix this issue. I'm hoping it is something as simple as setting up my association on the subreport between master and childfields. But then I don't really know how those work.

Edit 1: Any other information you need please feel free to request it.

[owyn999]

Edit 2: Sorry for the double post

If I am correct I may have figured out the problem, As of now I am populating the sub-report using it's own query. When what I am going to assume I should be doing is populating it using the MasterFields and ChildFields.

If I am way off here please let me know but what I do now it I run a query for the Master Report and then Run a query for the SubReport. In this case I think I may have misinterpreted how the subreport works.

[Jim Doherty]

Edit 2: Sorry for the double post

If I am correct I may have figured out the problem, As of now I am populating the sub-report using it's own query. When what I am going to assume I should be doing is populating it using the MasterFields and ChildFields.

If I am way off here please let me know but what I do now it I run a query for the Master Report and then Run a query for the SubReport. In this case I think I may have misinterpreted how the subreport works.

Your MasterFields and ChildFields direction is your answer as you have identified yourself.....subreport records will be linked to one record in the main report via the common key field that you specify

Jim :)