Im a newbie here. Im using VB6 for frontend and MS access for database. Im new in creating Data Report. I want to use it to create simple reports that can group by specified field.

Ex. Fields:

Doctor_Name
Address
Sched
Laboratory
Count(Laboratory) as LabCount

I want to place Doctor_Name,Address, Sched on the Group header.
Then Laboratory and LabCount in Detail section.

I've already created a Label and Textbox on the group header section and Set its DataMember and DataField on the properties window. Still Error occurs: "Report section do not match the data source".

And I use this code to call the report on click event:

dataenvironment1.connection1.open
Call dataenvironment1.Command1 (cboDocName.text) '<---its a parameter
datareport1.show

Can anyone please help me or give sample codes that i can use. Thank you.

how about if you have 20 parameters to pass?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.