Results 1 to 9 of 9

Thread: how to modify the report ???

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jan 2007
    Posts
    121

    how to modify the report ???

    i have made a data report in VB6 and and it is about patients records and all this...
    in the database on access i cud make a report where every record is in a separated page

    example

    the table or query has the fields Name, Age, Address
    we have inserted these records
    Name Age Address
    1- Mike 18 LA
    2- Ryan 19 NY
    3- Tre 22 LB

    Now when i form a report in VB6 i want to form a report that has a layout of Landscape not the normal one and i want each of the three records to be on a separate page.....
    so ryan will have a page
    mike will have another page
    and tre will have his own
    and each page will contain the complete info about the record or person

    i used data environment to make the connection to the database "Database.mdb"

    so can yall help me ????

    thanx

  2. #2

    Thread Starter
    Lively Member
    Join Date
    Jan 2007
    Posts
    121

    Re: how to modify the report ???

    Oh My God
    Where are the replys ????

  3. #3
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: how to modify the report ???

    i want to form a report that has a layout of Landscape
    Set the Orientation property to landscape (it can only be set in code). If you don't see the Orientation property you must install at least service pack 4.

    want each of the three records to be on a separate page
    Set the ForcePageBreak property of the Details section to 2 - rptPageBreakAfter

  4. #4

    Thread Starter
    Lively Member
    Join Date
    Jan 2007
    Posts
    121

    Re: how to modify the report ???

    thanx for ur reply but
    are u talkin about VB6 or Access???

    i told u i did this in access and its perfectly working
    i want to do it in VB6

    I dont find that ForcePageBreak in VB6 although it is there in access, and plus in access i could set the orientation from the page set up, what code are u talkin about and how to write it

    thanx for ur reply but cud u help me a lil bit more??

    thanx

  5. #5
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: how to modify the report ???

    I am talking about the DataReport in VB.

    Click the mouse anywhere in the Details section. Hit F4 to bring up the properties window.

    To print landscape use this code
    DataReport1.Orientation = rptOrientLandscape

  6. #6
    Fanatic Member amrita's Avatar
    Join Date
    Jan 2007
    Location
    Orissa,India
    Posts
    888

    Re: how to modify the report ???

    For orientation try this

    Printer.Orientation = vbPRORLandscape

  7. #7

    Thread Starter
    Lively Member
    Join Date
    Jan 2007
    Posts
    121

    Re: how to modify the report ???

    my friend, i still cant find orientation or report orientation in the data report properties
    and the code is for the print, i want to show a report that way

    thank you

  8. #8
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: how to modify the report ???

    Then upgrade

    If you don't see the Orientation property you must install at least service pack 4.

  9. #9

    Thread Starter
    Lively Member
    Join Date
    Jan 2007
    Posts
    121

    Re: how to modify the report ???

    where can i get it from ??

Posting Permissions

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



Click Here to Expand Forum to Full Width