Crystal Reports 7.0 problem. No data from stored procedure.

[mdl]

<b>Crystal Reports 7.0 problem. We should be producing online Crystal reports </b> based on the criteria selected on a web page. Instead, when the parameters are passed to any one of our SQL Server Stored Procedures from the ASP, <b>the result is the Crystal Report showing report headers and titles only. <i>Data is not returned from any of our stored procedures. </i></b><i><u>This is only happening in our staging environment.</i></u> <b>In development all the reports produce the proper results. </b>

 

[MalcolmW]

Are you using dates for one or more parameters? <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>

 

[mdl]

Yes, we are are passing 2 dates. Start and End dates.

 

[MalcolmW]

I've had problems getting dates to work right with SQL Server 7 and Crystal 7.&nbsp;&nbsp;Apparently it works with datetime in v8, but not smalldatetime in Crystal 8, but I still don't trust it.<br>Because SQLServer does implicit conversion of dates in char format, I pass date parameters as strings, and that works. <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>