Skip to Content
author's profile photo Former Member
Former Member

Regarding stored procedures datatype issue in Crystal Reports and prompt panel issue in Business Objects

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jul 25, 2016 at 03:32 AM

    Hi Ashwin,

    What database driver do you use to connect?

    You'd need to use SQL Server Native Client 10.0 or 11.0 driver.

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Abhilash,

      Thanks so much. I would not have been able to figure it out. I was using OLEDB Driver For SQL Server. When I used SQL Server Native Client 10.0 it worked like a charm. One last question, I am still not able to use the prompt panel in Business objects when i save the report to Business objects. If I do not use a stored procedure, the prompt panel appears. But the requirement needs a stored procedure and when I use it, the prompt panel does not appear in Business Objects. In this case, the user needs to open the report each time he or she wants to enter new values for the parameters.Please help me regarding this. Is there a way to make the prompt panel appear in Business objects while using stored procedures in Crystal?

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.