DATA REPORT AND MS ACCESS

0 pts.
Tags:
Access
Development
While reporting using data reports I want a set of records to come in paragraph way which takes almost 4 sentence what is now happening is a part of the paragraph is coming in next page which alters the impairs reports. I have a heading in report header section and a heading in page header section. I want the heading of report header to be printed only in the first page. In addition a page footer is also there. Is there any solution for this.
ASKED: May 26, 2005  8:14 AM
UPDATED: May 26, 2005  9:55 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Vineeth,

I.d recommend reducing all margins to 0.67 inch, turning grouping and widow protection OFF, dropping the headers/footers/page_numbers/dates (except at the top) and dropping separator lines except fot the first group before the detail sections. Then set all fields that might need to wrap text to neither shrink nor grow and make all the font sizes the same: smaller.

After you find that an appropriate number of record .paragraphs. fit on a page, you can add/increase the neat style stuff until the page is filled. Then, after a few reports are run, you can tell which fields will need resizing and whether, or not, to activate grouping and widow protection.

If you.re are using the wizards, I.d stongly recommend letting the wizard only do the connections and basic page design (ie. column vs. matrix vs…..), default on everything else and do all of this other fine tuning in design mode. You.ll most likely end up there, anyway, as I.ve never been able to run directly off of the wizard.s resulting report and don.t know anybody who has.
:) Gene

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following