Hi,



I am developing few reports using Stored Procedures.

Few facts :-

1. These reports will finally be used in different environment which means 

different Database, machine, username/pwd etc.

2. I can use OLE DB Drivers only(pdsoledb.dll)

3. These reports will be served on the web and are being called by an ASP 

page.

Problems :

1. Data is not displayed on the report(when previewed during design) but 

Stored Procedure is running fine when run independently.

2. How to convert a string in date format in crystal reports. This is 

needed as Date type parameter has some problem in Web repoting.

3. How to overcome the problem of change of environment, I mean what 

changes has to be made when any of the database properties changes.



Its urgent !!



Thanks



Shashi