sql server reporting services: date parameter in textbox -- sql server reporting services

RE: date parameter in textbox

code_slayer_bkk
4/21/2006 11:05:30 AM

sql server reporting services:

Hello:

I have done the following and I am not sure if thi8s method is for you or
not - but:

I included an additional line in my detail headers - that reference the
parameters passed for execution of the application.

You can define within the text boxes - the !Parameters passed - and define
as a field element - but just for the headings

Not sure if I was clear enough -

Warm regards,

[quoted text, click to view]

date parameter in textbox

Jackson
4/21/2006 1:34:48 PM

Hello,

I have two parameter one for Begindate and EndDate.

I was wondering how I can reference these two parameters so that it shows up
in a textbox.

I was hoping to have the textbox with the begin date and end date so that
when users print out the report they know that it is between those two
dates.

TIA,

Jackson

Re: date parameter in textbox

Bruce L-C [MVP]
4/21/2006 4:09:01 PM

Yes, that is how you would do it. But I suggest instead of typing you use
the expression editor. Right click on the textbox (or cell), select
Expression. You will be able to select the parameter you want to show. Note
that the name of your parameter is case sensitive. Also, sometimes you might
want the lable, not the value. If so then replace .value with .label (label
is not a choice with the expression builder).

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Re: date parameter in textbox

Jackson
4/21/2006 5:02:23 PM

Thanks for replying back so fast.

Do you have the syntax for referencing the parameters?

If I had an parameter called begindate. would I type
Parameters!begindate.value or something like that?

Thanks again for the help,

Jackson
[quoted text, click to view]

RE: date parameter in textbox

Joe
5/1/2006 11:49:01 AM

Try this. = "Begin Date " & Parameters!Begindate.Value

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