sql server reporting services: DateTime parameter without time part -- sql server reporting services

You're in the

sql server reporting services

group:

DateTime parameter without time part

Michael
1/14/2005 12:36:55 PM

sql server reporting services:

There is a post that tells how to do this:

[quoted text, click to view]

but where do you set the field format of a parameter?

--
Michael White
Programmer/Analyst
Marion County, OR

Re: DateTime parameter without time part

Vaibhav
1/14/2005 4:47:59 PM

Have you tried inserting the parameter on the report and then right click
properties and set format?

Another option is using code file.

[quoted text, click to view]

Re: DateTime parameter without time part

Wayne Snyder
1/14/2005 4:50:46 PM

I don't think you can set the format of a parameter past the fact that it is
a date, but the time does NOT have to be entered when using the parameter.

Some people choose to use the string data type instead of date...

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

[quoted text, click to view]

Re: DateTime parameter without time part

Mardy
1/17/2005 6:51:03 PM

Wayne described what I do. I create the parameter as a string. My stored
procedures then convert the string to datetime datatypes. If you don't do
somthing similar, the parameter fields on the report append hh:mm:ss to the
parameter value supplied.

Mardy

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn