How To Use stored procedures in data report ?

If you mean, the DataReport and DataEnvironment built into VB (DataProject). Then you just:
1) select the connection, go to properties, enter all the proper information.
2) Add a command
(To see if any procedures exist)
3a) select stored procedure, then see if the procedure exists
3b) Use the SQL statement, enter the procedure name, followed by the parameter.

Now as far as dynamically... You can try to modify the command via code like the following:

DataEnvironment1.rsCommand1.Source = "StoredProcedure Parameters"
DataEnvironment1.rsCommand1.Open

Or use a temp table.

IE. Create the SQL command to get the results, then insert the results into a temporary table, then have a command and report just display the results from the temp table, not the original command. Then clear the temp table.

Thanks For answering .But How Do I use the stored procedure to display in the form of report.

In the data reoprt properties:

DataSource = DataEnvironment
DataMember = Whatever pops upin the box (the SQL statements, commands etc).

Then you have to right click the report, click retrieve structure.

Open up the connection form, expand the procedure and drag the fields to the report, or just drag the command to the report.

(edit message still doesn't work)

hi thanks for answering.but i am still not able to get it.actually i have a stored procedure with having in out parameters & i am trying to use that in the data report .so i tried all that u suggested but yet i am not getting it.

If you can get just a plain table to work with the data report (displaying and everything)... Then I don't have any ideas as to why it doesn't work.

I have one last idea before giving up:
1) On the connection, you have a command,SQL statement or something that's used to open the procedure.
2) Select the properties
3) click on Advanced
4) Make sure "Recordset Returning" is selected
5) Accept, close the dialog
6) Select the same item in step 1
7) Select "Design"
8) You have the SQL command that'll be executed, Right click in the top pane (you need the menu with "Run" in it)
9) Click "run"
10) if you see the results you expect, then I have no clue, if you don't, modify the SQL statement as to get the results you're expecting and try the report again. (when you close the designer, it'll ask if you want to save the changes)

Like I said, if the above doesn't do anything, I have no other ideas. Good luck.