assume:
- you use Crystal Reports XI
- you have created the Stored Procedure in SQL server and make an ODBC setting.
just create new report and use your Stored Procedure (SP) as your Datasource (through ODBC).
you'll see a list of all Tables / Views / Stored Procedures from the DB.
- select the SP that you want.
- and design your report using all fields from that SP.
if there are some parameters in your SP then it will automatically appears in Field Explorer - Parameter Fields.
but if the params in your SP using XML format then in CR you'll need to type it manually in 'Parameter Fields'.
hope it help.
IP Logged
