sql server reporting services: Formatting parameters -- sql server reporting services

RE: Formatting parameters

Mirela
9/14/2004 5:35:15 AM

sql server reporting services:

hi Bender,

Write this expression in the the textbox that you want to show you the date:

=format(Globals!ExecutionTime,"dd.MM.yyyy")

i hope it will help you.

[quoted text, click to view]

RE: Formatting parameters

Mirela
9/14/2004 5:59:01 AM

For parameters, you must aplicate the function format to
Parameters!parameter_name.value (instead of Globals!ExecutionTime).

[quoted text, click to view]

Formatting parameters

Bender
9/14/2004 12:56:10 PM

Hi!

I would like to change date parameter from
4/30/2002 12:00:00 AM to 30.4.2002 in report.

How can parameters be formatted?

Thanks
Roman

Re: Formatting parameters

Bender
9/14/2004 3:28:11 PM

I'll try to explain again what I want to do :)

In the Report Parameters dialog I define my Parameter and set
Data Type to Datetime (there is not many options anyway).
When I run report I get 4/1/2002 12:00:00 AM in parameter box on
top of report (parameters section of report), which is correct.

But I want to format this to see and make input like
dd.MM.yyyy and without time part.

Any ideas.

Thanks

[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.