How To Pass Stored Procedure Parameters To The Report?

1.	How To Pass Stored Procedure Parameters To The Report?
Answer» Choose File–>Options menu. In the Options dialog box : Click the Database tab and ENSURE that Stored Procedures is selected. Selecting “”Stored Procedures”” automatically displays any available stored procedures when you LOG on to an SQL database. Click OK to exit the Options dialog box. On the Start Page, click Blank Report. Locate and select the SQL Server data source that contains the stored procedure you WANT to use. Click Next to go to the Connection Information dialog box–>Enter the required information to log in. Click Finish. Highlight an SQL stored procedure in the Stored Procedures folder, and click the–>ARROW to add it to the Selected Tables list. The Enter Parameter Values dialog box appears. Highlight a parameter in the Parameter Fields list. Assign a value by typing into the Discrete Value box and then click OK. You are returned to the Database Expert. Click OK and create your report using the fields in the stored procedure. Choose File–>Options menu. In the Options dialog box :

Answer»

Choose File–>Options menu.

In the Options dialog box :

Click the Database tab and ENSURE that Stored Procedures is selected. Selecting “”Stored Procedures”” automatically displays any available stored procedures when you LOG on to an SQL database.
Click OK to exit the Options dialog box.
On the Start Page, click Blank Report.
Locate and select the SQL Server data source that contains the stored procedure you WANT to use.
Click Next to go to the Connection Information dialog box–>Enter the required information to log in.
Click Finish.
Highlight an SQL stored procedure in the Stored Procedures folder, and click the–>ARROW to add it to the Selected Tables list.
The Enter Parameter Values dialog box appears.
Highlight a parameter in the Parameter Fields list.
Assign a value by typing into the Discrete Value box and then click OK.
You are returned to the Database Expert.
Click OK and create your report using the fields in the stored procedure.

Discussion