Data Report using VB6

[saiabhi]

Hi Every body


I had a problem with data Reports

I am using MS Access as backend and VB 6.0

by Database name is = Cust

The tables are

Table Name The filelds are
inv custname, invno, invdt, invamt

Items_detail_tr ansactions custname, invno, invdt, invamt, paiddt, paidamt

From the above two tables i want the report like

Customer Name MSV COMPUTERS
=============== =============== ==
Inv No invdate invamt paiddt paidamt total Due
MSV/123 11-Oct-09 4,850.00 4,850.00
16-Nov-09 3,000.00 1,850.00
18-Nov-09 1,000.00 850.00


MSV/X1 15-Nov-09 9,375.00 9,375.00
0.00 0.00 9,375.00


custname SURAKSHA INFOTECH
=============== =============== ==
Inv No invdate invamt paiddt paidamt total Due
SI-2345 11-Dec-09 10,750.00 10,750.00
0.00 0.00 10,750.00


I want this without using dataenvironment
It is very urgent
some please help

[Dököll]

You've come to the right place; hope you searched here prior, there're tons of stuff here if you do that:-)

http://bytes.com/topic/visual-basic/answers/714159-datareport

May need to tweak to your needs but it should do the trick.

In a bit!

[saiabhi]

I could not find my soultion