visual basic 6.0 and data report

can anyone tell me how to do grouping in data report i have foll tables in
A-containing all account numbers
B-containing transaction with account no,debit credit amount for a year 2007
C-containing transaction with account no,debit credit amount for a year 2008
D-containing transaction with account no,debit credit amount for a year 2009

i want to display the details in one data report as and wen user enters the year the report for that year shud display everything in one single report.

is that possible?
how to do multiple grouping in one single report.plz help my job on stake.

Hi,
Welcome to the forum
I suggest Crystal Report. You can have multiple grouping in one report. And also it is good in complex reporting.

In data report, I have no idea because I just use data report once or twice and transfer to crystal report.


Good Luck,
Jerome And Gail