actually, i don't know if there is such information that you looking for out there in i'net.
but for calling/adding stored procedure (SP) from CR for new report is same as adding tables.
as per my experience, using Cache and MS-SQL database, i can add the SP (whether with/without parameters) to CR and put all the fields on the reports.
currently i'm using CR XI.
and, I think, the process for adding a SP to new report in other CR version are similar.
correct me if i'm wrong.
when you create new report from CR (and plan to use SP for it):
1. you need to connect to ODBC
there will be a window with 2 columns (available data source in the left side, and selected tables in the right side)
2. in left side column (available data source)
a. right click on empty area
b. click 'Options'
you'll find 'Data Explorer' with options
c. check 'Stored Procedure'
so you can see all the SP on that DB
3. click on 'Create new connection'
4. select ODBC
and select the ODBC that you want.
and follow the wizard (one of them is selecting the DB).
5. you'll see the DB name
6. expand DB name
you'll see Tables, View, SP
7. select which SP that you want to use
and continue the wizard.
if there is a params in SP then it will directly ask you the params.
hope it help.
IP Logged
