-
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
-
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.
-
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!
-
Re: DataReport Help!!!
Put the information you want only show once in the "ReportHeader" section. This section only prints once.