Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: CR XI Post Reply Post New Topic
Author Message
AdamAvish
Newbie
Newbie
Avatar

Joined: 12 Aug 2012
Location: United States
Online Status: Offline
Posts: 1
Quote AdamAvish Replybullet Topic: CR XI
    Posted: 19 Aug 2012 at 7:32pm
Hi Guys! Need Help on this!! I am using a Datetime data type as my Parameter on my stored procedure in SQL Server 2005. I am also using Crystal Reports XI for my reporting using the stored procedure in SQL but my problem is that I want to use ONLY the DATE data type as my Parameter instead of using the datetime parameter in Crystal Reports! Since the SQL server does not have a Date data type, how can I convert this from DateTime to Only Date data type as my parameter??....Thanks!!
Regards..

Adam Avish
SQL Developer
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 20 Aug 2012 at 4:32am
as far as I know, you can't...CR sets up the parameters to the stored proc.
 
since I hate CR parameters...especially the datetime, I would use the calendar and then in the stored proc strip off the time component.
 
luckily I don't have to use the CR parameters (we have designed wizards that allow us to completely control the user input for parameters, then we pass them to the stored proc, and finally pass the results of the stored proc to the report...which also allows us to postprocess the data if we want/need)
 
HTH
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.