|
-
Sep 26th, 2007, 01:49 AM
#1
Thread Starter
Member
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
-
Sep 26th, 2007, 06:27 PM
#2
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.
-
Sep 27th, 2007, 02:11 AM
#3
Thread Starter
Member
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.
-
Oct 2nd, 2007, 11:18 AM
#4
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|