on ‎2011 Aug 04 2:30 PM
I've reached an impass in creating a packing slip. I need to list my items in two areas on each page. I created two subreports in a group header section and my information populates the subreports correctly, but the subreports are disregarding the whitespace and underlays that are used to put them in the right spot. Each page can only show up to 7 records, so I have a new page after formula to reflect that in the details section of each subreport. Unfortunately, if the subreports are in different sections (GHa and GHb) the first half of the pages in the report will contain only the first subreport, vice versa for the second. When in the same section, the second page of the report will display the subreports at the top of the section, ignoring whitespace and displaying them one over the other.
My requirements are multiple pages showing up to 7 records per page. These records must be contained a specific area of the report (first set stays in the middle of the page, second set is only on the bottom). Any ideas?
Request clarification before answering.
I figured it out!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Unfortunately, any image hosting I know of is blocked at my office. I'll try to paint a better picture for you...
Two subreports display over a page header (which is checked to underlay following sections). Both subreports need to be constrained to display 7 records per page and both must display on each page (one on the top, one on the bottom).
I have not been using Suppress if Blank because I was trying to use whitespace in order to keep my subreports spaced correctly. The only paging controls I've used have been <if Remainder (RecordNumber, 7) = 0 then true else false> in the details section of my subreports. I'm able to constrain a single subreport over multiple pages, but not two.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I've figured it out! The two subreports must be aligned at the top of the main report's group header A. The second report must have it's group header extended in order to space correctly. This is because subreports in group headers do not regard whitespace, but always print at the top of the section.
Tyler,
That's hard to visualize for me... can you post a link to a pdf of your report and/or screen captures of your report?
Have you made use of the paging controls for the sections as well as the suppress if blank report options?
Thanks,
J
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 8 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.