Expanding the Report Size ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that takes up all of the 22" that i am able to see. Is there
a way that I can make the report in design to go past the 22". any help would
be appreciated.

thanks

matt
 
You can add additional sections (grouping) or include subreports. Depends
on what you are trying to accomplish. I can think of almost no instance
where a report larger than about 12" per record would be of much use.

Post some details if this does not help.
 
Rick,
as you can see i am a rookie @ access... but
i have a report that has 32 Text's & Labels that need to be on this 1
report. some fields i can really make small but i am running out of room. i
might be able to get away with a subreport but have not tried that yet. any
additional help would be appreciated. thanks matt
 
Well 32 fields will fit just fine, just move them around. Are you trying to
print every field vertically or horizontally? Can't you make two or three
rows for each record? What type of data are you printing? What does your
report look like?
 
Rick,
it has date, check#/cash, account name, subtotal. i need these 4 to repeat
on the 2nd page. but every field has a dollor amount in it. it's a pretty
lengthy report, i am just having an issue with the report design going past
22". i appreciate all the help rick.
 
I don't understand. That is only about five fields.

There may be one record or 5,000 records, but it still only sounds like four
or five fields to me. They would go in the detail section of your report.



Page Header----
Date Check# Account Name subtotal

Detail Section-----
[RecordDate] [CheckNum] [AcctName] [RecAmt]

Page Footer----
[*** Total ------>] [=sum(blah
blah)]



------------------------------example---------------------------------
Date Check# Account Name subtotal
01/01/05 1234 Electricity $100.00
01/05/05 1267 Phone $ 75.00
01/15/05 1298 Water $ 42.00
*** Total ------> $217.00
------------------------------------------------------------------------




Your report design for this would be about 2 1/2 inches.
Page header 1/2 inch or so
Page Detail 1 inch or so
Page footer 1/2 inch or so
 
Back
Top