From the CR help file under Stored Procedures
-------------------------------
-
Choose Options from the File menu.
The Options dialog box appears.
-
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.
-
In addition, you can specify Table name LIKE and Owner LIKE options if you wish.
-
"Table name LIKE" is based on the SQL LIKE clause. This option allows you to specify the kinds of table names you want to appear in the Choose SQL Table dialog box. You can use the underscore character (_) or the percent sign character (%) as wildcards with this function. The underscore character specifies any single character, while the percent sign signifies any character string. For example, DAV_ matches DAVE only, while DAV% matches DAVE and DAVID. Table name LIKE C% would display only those tables that have a table name beginning with the letter C.
-
"Owner LIKE" is also based on the SQL LIKE clause. The Owner LIKE option allows you to select the Owner (or Creator or Alias) of the table, not the table name itself. For example Owner LIKE C% would display only those tables that have an owner beginning with the letter C.
Note: For more information on the SQL LIKE clause, refer to your SQL documentation.
-
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.
-
-
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.
The first time you refresh your report's data the parameter you entered is used. Only the records that satisfy that value are used in your report. Subsequent refreshing prompts for new parameter values.
----------------------------
Hope this is what you looking for.
Regards,
John W.
... pleas give me some sugestions... thank you 
IP Logged
