Results 1 to 9 of 9

Thread: report (2k)

  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    report (2k)

    HI all , In my attch mdb i have 10 record in the table but in reprot it apeer 20 pages i can not adjust it in 10 pages , i want to prient it in a stiker about 11cm X 11 cm .
    Ashraf
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: report (2k)

    Hello Ashraf,

    I don't understand where the 20 pages come from. When I preview the report, it has 2 pages, not 20.

    If I resize the detail section to 11 cm by 11 cm, the report has 5 pages, since 2 records fit on one page.

  3. #3
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: report (2k)

    Dear Hans
    u r right , i want to resize the detail section to 11 cm by 11 cm but 1record fit on one page
    ashraf

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: report (2k)

    Ashraf,

    If you want 1 record per page, try the following:
    - Open the report in design view.
    - Select the Detail section by clicking on the grey bar at the top of the Detail section.
    - Activate the Format tab of the Properties window.
    - Set the Force New Page property to Before Section.

    Each record should now start on a new page.

  5. #5
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: report (2k)

    I do it really and now u can see the 20 pages , i used Epson printer 1170
    Attached Files Attached Files

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: report (2k)

    Are you sure that you attached the correct version? The report is still the same one you attached earlier.

  7. #7
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: report (2k)

    yes i do but i my pc i change to my printer paper as user defined size and choose custom width 850 - lrnth 550, if u choose it u will found 20 pages .
    Thanks for ur help
    Ashraf

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: report (2k)

    I'm sorry, I don't have an option to set a user-defined paper size.

    Have you taken the margins into account? Perhaps your margins are too wide for the selected report width and custom paper width.

  9. #9
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: report (2k)

    ok Thank u dear 4 ur helping me . i will try it again
    Ashraf

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •