Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Passing Stored Procedure between CR XI and SQL Server 2005

Status
Not open for further replies.

report2000

Technical User
Mar 1, 2005
45
0
0
US
I have a stored procedure that is resides in SQL Server 2005.
**Bring back all results for multiple firms
EXEC dbo.USP_RPT_BOB_CONTRACT @Firm_ID_MULTI = '2888, 18458, 21505, 2842, 13254'

Now I used the CR XI to link the reprot to Stored procedure (using command box).

Now I need to let user to type lets say , ('2888, 18458) and bring back only those two sets of records. Pass the parameter back to SQL Stored procedure and return only ('2888, 18458)

Do not want to bring everything in and then filter it in CR XI. It takes too much time.

Any suggestion?

Thank you
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top