Subreports
I hope that I am providing enough information.
I am trying to design a report to generate a packing slip for shipments from my company. Each packing slip will describe one product, but could have multiples of that product, each with its own serial number. I need to list each serial number shipped as a list, but have the description printed only once. I am trying to use a subreport to show the list of serial numbers. However, when I preview the report, the subreport is moved from where it is designed.
As a further note, I need to copies of the packing slip to be printed side by side on one sheet of paper. I designed the report to show both copies, and for the most part, this works. The only problem is with the location of the subreports.
I have attached screen captures of the report in design, and the report in preview. As you can see, the subreports have moved from where I thought they would print based on the design to completely new positions.
Any assistance on what I am missing will be greatly appreciated.
Jeffrey Eib
I am trying to design a report to generate a packing slip for shipments from my company. Each packing slip will describe one product, but could have multiples of that product, each with its own serial number. I need to list each serial number shipped as a list, but have the description printed only once. I am trying to use a subreport to show the list of serial numbers. However, when I preview the report, the subreport is moved from where it is designed.
As a further note, I need to copies of the packing slip to be printed side by side on one sheet of paper. I designed the report to show both copies, and for the most part, this works. The only problem is with the location of the subreports.
I have attached screen captures of the report in design, and the report in preview. As you can see, the subreports have moved from where I thought they would print based on the design to completely new positions.
Any assistance on what I am missing will be greatly appreciated.
Jeffrey Eib
Comments
Anyway, for an update to what I have tried while trying to solve my problem.
1. I played with the settings of the sub_report, trying different combinations, to no avail.
2. Doing some research, I found a possible solution on one of the Google forums. Instead of putting the individual fields on the main form, I replaced the description sections of the packing slip with sub-reports containing the same fields. My first attempt offered no change.
2. I then tried inserting a child band to hold the sub-reports instead of putting them in the master data band. Again, this resulted in no change.
4. When I originally designed the report, the sub-reports on the right half of the page were copies of the sub-reports on the left half, pasted into the right half. On the chance that this might be causing the problems, I deleted the sub-reports on the right half and replaced them with new sub-reports created from scratch. Lo and behold, the column of serial numbers on the right half of the page now print in the correct location. However, the column of serial numbers from the left half of the page continue to be moved to the center of the page. Except for the values for the Left property of the two sub-reports, they are identical.
I have attached images of the latest design and preview for the form. The images show that I have partially solved the problem, but I have no idea why the left sub-report keeps migrating to the center of the page instead of staying to the left where it is designed.
Any help, even if it is just a possible explanation of why this is happening, or a comment saying that there is no way to do what I intend, would be greatly appreciated.
Jeff Eib
Thanks for listening to my process.
Jeff