Dear database gurus

I am just a baby beginner of using stored procedure.
My newly joined company is using Sybase sql db and crystal report 10.
To improve the processing time of a CR report, I would like to create stored procedures to created a file populated with pre-filtered data with customized field name triggered by user when they run the reports which use this/these stored procedures.

To start at baby level, How should the store pro be....

I am not a techie and am only an accountant who likes working with data...Your kind advice or guidelines will be highly appreciated.

Here are the steps in general:
1. Create the Stored Procedure with the input parameters you want to filter the data with.
2. In crystal report datasoure , select your Stored Procedure as data source.
3.Crystal Report should create a Parameter Field with the Stored Procedure input parameter you created.
4. Provide value to this paramter field.

It should work. To know about how to populate and use Crystal Report Parameter field and datasource you can checkout this link http://www.businessobjects.com/produ...rystalreports/

Hope it helps