• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 507
  • Last Modified:

Datetime Parameter on Sql Stored Procedure-Masking the time portion on Crystal Side

Hi:

We want a calendar pop up on the  Crystal side.  However we want to hide the time portion of the calendar.  

We are dealing with stored procedures and the feed will have to be datetime.

How can we be creative about this?


Thank you,
Lucy
0
Lucia
Asked:
Lucia
  • 2
1 Solution
 
SpykairCommented:
Right click on the DateTime field -> Format -> DateTime tab -> Then choose whatever format you desire or you can customise you format.

Hth,
Spykair
0
 
vidruCommented:
Here are (some of) your options:

1) Instead of using a SMALLDATETIME or DATETIME parameter, change it to a VARCHAR, and convert it back to DATETIME in the procedure.  The downside of this, is that your users need to type in the dates in valid date format, or the procedure might blow up.

2) Tell the users to ignore the Time portion, and handle the Time part within the procedure definition.

3) Create a blank report, and add in your existing report as a subreport.  In the 'new' report, define a parameter that is a Date datatype.  Create a formula that converts the parameter field to a DateTime result, then use the formula field as the 'link' between the main and subreport.

I usually go the option 2 route, but any of them will work.

-dave
0
 
LuciaAuthor Commented:
Hi :

Thank you all for your responses.

I think we have also decided to goto option 2.

Thanks,
Lucy
0
 
vidruCommented:
Glad to help.

-dave
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now