DataReport Help

[aggeliki23]

Hello all.

I am new in Visual Basic 6 and i need your help.
I am creating an application which handles a database created with Visual Data Manager (Microsoft Access Version 7.0 MDB). I use ado recordsets in my source code.
I have an invoice form represents the data in text boxes and flexgrid. So, i want print this and a print preview before printing. I think I have to use DataReport to do this but i don't think its a good idea for me to use DataEnviroment because my sql query collects many fields from more than one tables. Well, I think I have to do this with code. I have never used DataReport and DataEnviroment before and i don't know what to do. I don't know where to write code in DataEnviroment or DataReport? Also, i realized that in the design situation of DataReport i can design textboxes and labels but no grids, no flexgrids.
How to design a flexgrid in Data Report?
How to display the data i display in the invoice form on flexgrid in printPreview and how to print them? May anyone help me please? I just don't know what to do.

Thank you
very much.

 

[blastingm]

Use the SHAPE command to create Parent and Child data in the recordset. VB6 DataReport can only handle a Shaped RS with a Parent and Child.

Datareport needs a datasource = Shaped Recordset

Set the textbox datafield to the fieldname.
In the child make the datamember = to the child name.
I usually leave this as CHILD in the Shape statement to make it easy.