Hi Guys,
I am using a SQL Server stored procedure in Crystal. I am filtering on a Date parameter. When I save the parameter as Datetime in the stored procedure , crystal displays the date using a calendar control with the current timestamp. I need only the date to be displayed without the timestamp. When I save the parameters as Date in the stored procedure, Crystal stored the datatypes of the date field as a String and does not show the Calendar Control and the user needs to manually enter the date. Is there any way for the user to use the calendar control without needing to manually enter the timestamp while entering the date fields.I am using Crystal Reports 2011. Another issue I face is while saving the report to Business Objects, there is no prompt panel. Therefore the user needs to open the report each time, he wants to enter new values for the parameters. Any help will be much appreciated.
Regards,
Ashwin Jayagopal