Problem With Report Length?

[MarcieFess]

I've created a report (thank you for the help on the Modules & VBA forum!) that is 6 pages long. I had to actually create all 6 pages by hand (it's a government report and a long story).

The problem is, Access 2010 won't let me create a report "longer" than 22 inches. I need a report that is 51 inches long at least.

Is my only recourse to create 2 reports (which I have already done) and make pages 4-6 a sub-report of the first report?

It works that way, with one exception: the letters sbrptHMIR prints at the top of the detail of the first page of the sub-report, underlying the print at the top of the sub-report. I don't know how to stop that.

My other question about this is, if my menu button that calls this report limits the records for the report, will it also limit the records for the subreport as it should?

 

[boblarson]

I've created a report (thank you for the help on the Modules & VBA forum!) that is 6 pages long. I had to actually create all 6 pages by hand (it's a government report and a long story).

The problem is, Access 2010 won't let me create a report "longer" than 22 inches. I need a report that is 51 inches long at least.

Is my only recourse to create 2 reports (which I have already done) and make pages 4-6 a sub-report of the first report?

Yes, subreports are the way to go.

It works that way, with one exception: the letters sbrptHMIR prints at the top of the detail of the first page of the sub-report, underlying the print at the top of the sub-report. I don't know how to stop that.

That is a label that is added when you add the subreport. If you select that label on the top left little square and click DELETE it should remove the label while keeping the subreport.

My other question about this is, if my menu button that calls this report limits the records for the report, will it also limit the records for the subreport as it should?

If the subreports are linked using the same PK field(s) as the main report, it should be fine.

 

[MarcieFess]

I'm not sure how to link the subreport to the report?

It's saying I can't do it. It says "Can't build a link between unbound forms."

 

[emorris1000]

That's either due to the forms not being bound to some table, or its caused by a remarkably frustrating bug that seems to have existed throughout time for access. Anyways, if it's the bug you simply have to type the field name you are linking through into the master and child sections. The wizard won't work and will always say "can't build a link blah blah blah", but if you manually type the field names in it should work.

Also you don't need brackets or anything.

 

[MarcieFess]

Thank you. It was because I was relying on the code for each field and hadn't named a source for the reports in general. They are now bound nicely.

I'm having one issue still involving the sub-report.

The store address, city, state, zip are printing nicely now on the last page of the report, so I know that the link is working.

This is a report full of "if/then" statements...if the statement is true then a graphic must be changed, otherwise the default graphic is to be shown.

There's only 1 graphic in this sub-report that is involved regularly...and it's not changing as it should. It's staying at the default. If I get this one fixed, it'll all be good!