Design reports using VB designer

[jaya-shree]

I am designing reports using the microsoft designer in VB. I do nt have crystal reports. I have designed the user interface using the wizard. i want to link it to the database.

using access database.

plz tell me how do i link the report to the database. is there any code to be written. if yes, plz send me code snippets.

Eg:

i have transactions table and members table.

transactions - tId,memberid, issuedate,returndate,actualreturndate,fine.

members - memberid,firstname,lastname,address.

i want to display memberid,firstname,lastname,address and fine in the report. how do i do this?

[fifione]

By "microsoft designer" you are refering at "Microsoft Data Report" ?

[usamaalam]

This may help you.

http://www.vbforums.com/showthread.p...ghlight=report