problems passing parameters to reports

Hi,

I am using the following line of code to pass parameters to reports.

dtaEnvSample.Commands("com").CommandText= "select.....

There are 4 command buttons for the different reports on the screen with different SQL statements behind each. My problem is that as soon as I run the first one it seems that every one I run after it is recieving the same SQL code. Is there any way of 'refreshing' the command text ?

[karunakaran]

Hi,
I am not sure where you are held up. But I used in one of my projects ,data reports.
I created command objects for each report drag and drop them in to the data report(even with parameters).Whenever I click the button the report will be generated.(call the data report to display or print).

Thanks
karun