Link to home
Create AccountLog in
Avatar of kalees
kaleesFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Access 2007 report detail section limit

All,

I am creating a quotation system within Access 2007 and wish to create a report to print the quote in PDF format. I need the report to be about 3 A4 pages long to enable a cover page, details page and a costings page. having started to create the report, I have come across the 22 inch limit.

Can anyone offer any ideas how to overcome this issue?

Many thanks in advance,

Keith

Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Keith,
<<Can anyone offer any ideas how to overcome this issue? >>
  22" is the limit.  Keep in mind that the detail section repeats for each record in your reports recordsource.  If you really need more room then that for a single record, then you'll need to use sub-reports for each of the sub sections that comprise the total information for that one item.  22" is a built-in limit and there is no way to change it.
JimD.
Agree with Jim regarding the sub-reports.

When you drag them to your main report, you can make them .25", and set their CanGrow/CanShrink properties to True, then you stack those one above the other in the detail or in some group header or footer.  The challenge is get the sub-reports to print out on the pages you want them to, and to print only the desired info at in the page header/footer to make sure it is obvious which pages belong to which report.
Avatar of kalees

ASKER

Thanks for the reply's

Are you suggesting with the sub reports to break down the report and create sub reports and then insert them into one report? The report that I am creating with all of the fields is only one record i.e the quote contains all of the information for one quote on one vehicle with one body and one set of contract details / payments.

Keith
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of kalees

ASKER

I have managed to achieve my goal through making use of the report header and footer which can also be extended to approx 22 inches. This has provided me with enough real estate to create the report. I will therefore declare this as solution provided by myself.

Keith
Really?  Would you have figured that out without Jim's help?  I would have thought that Jim had at least earned an assist.
Avatar of kalees

ASKER

fyed,

Not really wishing to get into a disagreement about this, however, based on your comment, I have again read through all of the comments made and still only see that the suggestion is to make use of sub reports, somthing that I have not done, maybe I did not make my resolution clear. I have used one report, streched out the report header to it's max, filled that with fields, using page breaks to split the section into pges. Next strech out the detail section a repeat as above, next strech out the report footer and repeat the steps again, filling with fields and using page breaks.

So againg, my point is, I have not used sub reports and do not think that they would have worked for me in this instance.

Should the group or admin disagree, I am more than happy to be guided.

Keith,

As a foot note, the resolution was stumbled across purly by trial and error.
Well let me say I really don't have an issue with you accepting your own comment, but consider that your question was: "Can anyone offer any ideas how to overcome this issue? "
That is what you received.  However it was your choice not to use that suggestion (which would have worked fine) and find another.  Probably because you didn't want to go through the effort of restructuring the report (it's a lot of work to shift to sub reports).
But from what you posted in your question, there is no way anyone would know that you could achieve your purpose by making use of the report header and footer.
And of course I can't say for sure because I haven't seen the report or the detail involved, but I think you've probably backed yourself into a corner with using them in a way that your probably should not have, and at some point down the road, you are going to wish you had gone the sub report route.
JimD.
 
Avatar of kalees

ASKER

JimD

I appreciate the reply and have read through it and agree that I did ask for ideas. Based on reviewing that, I am more than happy to award the points, please accept my appologies for the confusion (my own!) Sub reports is an idea that would possibly work for me but as you say, could have been time consuming.

Keith