HELP - problem with data reports

Hello All

I am using vb6 and have created data report using data environment designer.

But report is being generated only for the first record in the table.

I want to know HOW TO RUN A QUERY IN THE DATA ENVIRONMENT AT RUN TIME - SO THAT THE VALUE DISPLAYED ARE THE ONLY ONE TO BE SHOWN IN THE REPORT.

Anybody there to help me out.......

waiting eagerly for the reply

Thanx in advance

Moved.

I found something through Google that I hope will help. Also, if you did a search on Data Reports on this forum, you may find some good stuff as well.

Here is a data report demo using the data envirnoment.