Hello!

I hate to sound like a n00b, but I have a problem to which I have found no solution.

My report has tables, and one stored procedure (SP) as data sources.

Being that I have an SP as a data source, Crystal has automatically generated params for the report, being @start_date and @end_date respectively in datetime format.

Now that's all fine and dandy, as those are the only parameters required for this report, however, this report will be used in an .ASP page which will pass the parameter values from the web browser to this report, and the dates need to be formatted as string values.

My question is this, how do I change the parameter type from datetime to string for the aforementioned parameters generated by Crystal?

If this is not possible, please let me know and we will have to get the input data type modified in the SP on the SQL server.

Thanks!
Mike-

Thank you for your response!  I am aware that the parameter type must be synchronous with the parameter types on the server, but shouldn't it be possible to use a string inside crystal, and convert it to datetime via cDate? 

That's what I've been doing in my other reports, as the date fields on the tables I'm using is a datetime, however I cannot find those parameters in the report objects section anywhere.

This is my first time using a sproc as a data source, so up until now I've been able to simply convert all my parameters with cDate in the record selection portion via code.

Once again, if it's not possible, I'll make do, but I thought I should ask.

Thank you!


Edited by Speedemon0202 - 27 Sep 2009 at 10:12am