VB6 Data Report Designer
Posted on 2000-04-17
OK... the question that keeps coming up. HOW do I get the Data Report Designer to work with SQL statements?
I've read it all... In the DataEnvironment:
In Dataenvironment write a command
1)this is in General tab of dataenvironment
SELECT * from customer where custcode = ?
2) In the Paramentrs tab write dataype of ur table field(here datatype of
Custcode) And Host Data Type.
Well, I get that far and I can't even ACCESS the Parameters section under the Parameters tab.
How about this:
No dataenviroment is needed.
Set DataReport.DataSource = rs
Place Unbound TextBoxes on your Datareport and type in the name of the field in the DataField Property. That is it.
That hasn't worked either. I either get a "Invalid DataSource" or "Type Mismatch (13)" error.
So what is it that REALLY needs to be done? What I need is to do is an SQL statement, which means going to a RecordSet. Then once I have my RecordSet, I want to be able to use this as the source for my report. Please tell me how and please be detailed.