Results 1 to 4 of 4

Thread: DataReport Help!!!

Hybrid View

  1. #1

    Thread Starter
    Member
    Join Date
    Aug 2007
    Posts
    37

    DataReport Help!!!

    Hi. I'm new to data reporting and have some questions regarding the design. I want to create a report of an Access database. Here is my problem:
    I want the first page to have a design, and the pages form 2...n another design.
    The first page should give details about the order like quantity, name, description ( which i pull out of the database) and the pages form 2..n should contain records that compose the order.
    Is there a way i can create that with DataReport included in VB6?

    Thanks and regards

  2. #2
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,513

    Re: DataReport Help!!!

    there are acouple of things,

    Put the all the first page data in the report header
    Manually Assign the data to the text boxes in the report header

    rptCrop.Sections("pageHeader").Controls.Item("name").Caption = _
    frmMain!Adodc1.Recordset!Name

    then set the pagebreak property for the report header

    or make two reports

    report1.print
    report2.print

    Sorry I could give more details but I have to leave. I won't be back till Monday but if you still need help let me know.

  3. #3

    Thread Starter
    Member
    Join Date
    Aug 2007
    Posts
    37

    Re: DataReport Help!!!

    I saw that the datareport has some events like initialize, activate, deactivate ...
    Can i write code to make some controls on the datareport visible only at certain time? How can i do that? For example on the first page i don't want to see some controls, but i want to see them on the second page.
    Code:
    Private Sub DataReport_Initialize()
    DataReport1.Sections("PageHeader").Controls("lblCod").Visible = False
    DataReport1.Sections("PageHeader").Controls("lblOP").Visible = False
    DataReport1.Sections("PageHeader").Controls("lblCat").Visible = False
    DataReport1.Sections("PageHeader").Controls("lblMunc").Visible = False
    DataReport1.Sections("PageHeader").Controls("lblNT").Visible = False
    DataReport1.Sections("PageHeader").Controls("lblNP").Visible = False
    End Sub
    With the code above i'm able to hide those controls on the first page, but i can't figure out where 2 write the code that makes them visible on the second page.
    Can u help?Many thanks!
    Last edited by JazzAddict; Sep 27th, 2007 at 05:30 AM.

  4. #4
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,513

    Re: DataReport Help!!!

    Put the information you want only show once in the "ReportHeader" section. This section only prints once.

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