<div>
It probably notices the DataTime param and wants an exact format for it. &nbsp;You can try entering '01/01/2008' in the report...it will probaby work for you that way. &nbsp;If not, then you can change the stored procedure to accept a varchar(10) as the date, and handle it in your proc that way. &nbsp;You can cast the string '01/02/2008' as a date like this: &nbsp;CAST('01/01/2008' as DATETIME). &nbsp;Hope this helps.<br />
Tim
</div>


It probably notices the DataTime param and wants an exact format for it.  You can try entering '01/01/2008' in the report...it will probaby work for you that way.  If not, then you can change the stored procedure to accept a varchar(10) as the date, and handle it in your proc that way.  You can cast the string '01/02/2008' as a date like this:  CAST('01/01/2008' as DATETIME).  Hope this helps.
Tim

<div>
Let me test <br />
So Set the field in SQL server as text and then extract using the CAST?<br />
<br />

</div>


Let me test
So Set the field in SQL server as text and then extract using the CAST?



<div>
Thankk you solution works fine
</div>


<div>
<div class="content wysiwyg-content">
When the parameter is prompted<br />
It wants date in the following format mm/dd/yyyy hh:mm:ss AM or PM<br />
<br />
How do I correctly set this up<br />
I can address it in the SQL Server table I create or on the Crystal report side<br />
<br />
<br />

</div>
</div>


When the parameter is prompted
It wants date in the following format mm/dd/yyyy hh:mm:ss AM or PM

How do I correctly set this up
I can address it in the SQL Server table I create or on the Crystal report side




Using SQLServer DateTime as parameters in Crystal Reports

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

Crystal Reports

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.