By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,680 Members | 2,139 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,680 IT Pros & Developers. It's quick & easy.

Report Design with built in Report Writer

P: 4
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.
Dec 6 '07 #1
Share this Question
Share on Google+
2 Replies


P: 4
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.
Dec 6 '07 #2

Jim Doherty
Expert 100+
P: 897
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 :)
Dec 7 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.