I have a report that gives me a list of serial #'s that someone has checked out based on a Doc #. I have the Doc # and pertinent info in the main report with one column. I have the serial #'s only in the subreport. The Serial #'s need to fall into a table listing on the main report. I can accomplish all of this, but if the subreport in longer than one page, I cannot get the table listing and Doc# info onto the second page. If I set the subreport to can grow it will display all serials, but they will overflow the table or lines that they need to be in. If I set the subreport to not grow, it displays wonderful, but ends on the first page. Any help would be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Subreports that sometimes wrap to a new page 1
- Thread starter vordog
- Start date
-
1
- #2
Try adding a header to the main report grouping on document number. Put anything that should be at the top of each page of the sub report in the header and set its repeat section property to yes.
Alternately you could add the grouping, and tell access to keep the whole group together. This would help a group start on a new page, but depending on circumstances my still wrap pages.
Alternately you could add the grouping, and tell access to keep the whole group together. This would help a group start on a new page, but depending on circumstances my still wrap pages.
- Thread starter
- #3
I have tried both the grouping and putting the main page info in the header. The problem is getting the serial #'s to fall in or be superimposed onto the table. If I put the table in the header then the serial #'s do not appear to be in the table. If the table is in the details, then it does not appear on the second page.
So you want it to look like all the serial numbers are continous with the related document in a table?
I would join the serial number table and document table together in a query and base a report (no sub reports) on that. Next I would group on document number and put column headers in the page header, document information in the document header and serial #'s in the detail section.
If you want you can align it so that all the information appears to be in a single table.
I would join the serial number table and document table together in a query and base a report (no sub reports) on that. Next I would group on document number and put column headers in the page header, document information in the document header and serial #'s in the detail section.
If you want you can align it so that all the information appears to be in a single table.
- Thread starter
- #5
- Thread starter
- #6
I appreciate your suggestions, but I am coming to the conclusion that this is just beyond the capability of Access. I would need the detail section to be 2 column but not the group header. I need the serials in a table that is going to be filled in later with pencils and the group header in a non-table format that gives information that is known prior to an inspection. Thanks again.
Columns chages things a bit.
I've never tried it but did the columns work in the subreport with the main report formatted standard / one column?
Also you write about serial #'s superimposed on a table... Do you mean you are not printing on plain paper but preprinted? Or are you just talking about the layout?
If columns work in a subreport, and you are talking about layout of the report being an issue, I am not conceptuallizing what the specific problem is... Maybe you could show a rough example?
I've never tried it but did the columns work in the subreport with the main report formatted standard / one column?
Also you write about serial #'s superimposed on a table... Do you mean you are not printing on plain paper but preprinted? Or are you just talking about the layout?
If columns work in a subreport, and you are talking about layout of the report being an issue, I am not conceptuallizing what the specific problem is... Maybe you could show a rough example?
- Thread starter
- #8
Yes I have a two column subreport with a one column main report. The subreport is showing two columns. I even have it reading down-then-across correctly. I have made the table or maybe chart would be a better word into a second subreport just to see if it helps. For the doc header I have 9 fields displayed in a non-table format. For each Doc# I might have between 10 and 150 serial #'s displayed. All of this is printed and used as a checklist. I have a seperate report that is used to issue the gear, but since its format is different, I can get all serial #'s on one page. It looks something like this:
LTI / ACCEPTANCE SHEET
Item Nomen Unit UIC Date
Some Gear Unit 11111 07-Dec-05
NSN TAMCN ID No 1348 Doc # Qty
1240-01-533-1111 80072C M98583-5342-0001 10
# SERIAL# 12345 Cond Code # SERIAL# 12345Cond Code
1 302317 26
2 304046 27 3 302316 28
4 302320 29
5 302313 30
6 302309 31
7 302321 32 8 302312 33 9 304045 34 10 302308 35 11 36
12 37
13 38
14 39
15 40
16 41
17 42
18 43
19 44
20 45
21 46
22 47
23 48
24 49
25 50
LTI / ACCEPTANCE SHEET
Item Nomen Unit UIC Date
Some Gear Unit 11111 07-Dec-05
NSN TAMCN ID No 1348 Doc # Qty
1240-01-533-1111 80072C M98583-5342-0001 10
# SERIAL# 12345 Cond Code # SERIAL# 12345Cond Code
1 302317 26
2 304046 27 3 302316 28
4 302320 29
5 302313 30
6 302309 31
7 302321 32 8 302312 33 9 304045 34 10 302308 35 11 36
12 37
13 38
14 39
15 40
16 41
17 42
18 43
19 44
20 45
21 46
22 47
23 48
24 49
25 50
Let me ask this a different way...
When all the serial numbers do not fit on the same page, what do you want to happen?
Do you want the document information to repeat on each page? Do you just want it to span multiple pages? Do you want some information to repeat like column headings? Do you want to try to keep the document information together with the serial number if it could fit on one page?
Something to note about columns: Page and Report headers and footers do not get pushed into columns while all others do. If you are willing to put one document per page, you could put your document information in the page header and on a document footer set the force new page property to after section.
One other thought if you are commited to the subreport... If the document header won't repeat on each page with the repeat section property set because the subreport doesn't cede control back to the main report (I would consider this to be a bug), you could try duplicating your document controlls in the subreport in the page header. I would just point the control source to the main report's controls.
When all the serial numbers do not fit on the same page, what do you want to happen?
Do you want the document information to repeat on each page? Do you just want it to span multiple pages? Do you want some information to repeat like column headings? Do you want to try to keep the document information together with the serial number if it could fit on one page?
Something to note about columns: Page and Report headers and footers do not get pushed into columns while all others do. If you are willing to put one document per page, you could put your document information in the page header and on a document footer set the force new page property to after section.
One other thought if you are commited to the subreport... If the document header won't repeat on each page with the repeat section property set because the subreport doesn't cede control back to the main report (I would consider this to be a bug), you could try duplicating your document controlls in the subreport in the page header. I would just point the control source to the main report's controls.
- Thread starter
- #10
It would work perfect if the page header didn't show in columns, but on my machine it is doing just that. I am using 2003 with SP2. I don't care whether I am using subreports or not. What I need is the Doc# and related info to repeat at the top of the page and the serial #'s to show underneath. If the report is two pages, then the Doc info will be at the top of each page and the list of serial #'s will take up the bottom of the two pages. Then on to the next record.
- Thread starter
- #11
Did your Master And Child fields on the sub report get broken?
Are you grouping by document number?
Do you have force new page set on the document number footer to After Section?
Just out of curiosity, what was wrong with the Page Header and columns. I looked back and my example was in Access 97. Just curious if it changed.
Are you grouping by document number?
Do you have force new page set on the document number footer to After Section?
Just out of curiosity, what was wrong with the Page Header and columns. I looked back and my example was in Access 97. Just curious if it changed.
- Thread starter
- #13
Thanks for the help. I have got it working using the info that you had posted. It is far from what I had intended. I wanted a form that looks the same no matter how many serial #'s are listed, but settled for the lines be part of the the serial # subreport. When I put the lines and serial #'s into the main report it just didn't work. I could have the lines or the serials but not both. I am also going to look at making the lines a picture that is added just before printing.
Thank again,
Thank again,
- Status
Similar threads
- Locked
- Question
- Locked
- Question