469,622 Members | 1,922 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,622 developers. It's quick & easy.

Report Design with built in Report Writer

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
2 1454
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
897 Expert 512MB
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.

Similar topics

8 posts views Thread by Abhi | last post: by
1 post views Thread by C. Dexter Southerland | last post: by
2 posts views Thread by Mitchell Vincent | last post: by
6 posts views Thread by Bob Alston | last post: by
4 posts views Thread by alacrite | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.