Declaring and Using report parameters

I need to declare a report parameter, for example BegPeriod. Once that
parameter has been declared I need to work the parameter. For example the
parameter needs to evaluated with the following statement: "if
right(BegPeriod, 2) = '01' and left(BegPeriod, 4) = '2006' then use the value
in EarnDed00 else 0 Jan". This returns a month, year and deduction value.
that will need to be done for all months.
Will Reporting Services do this? If so, can you direct me to the correct
method.
Thank you,
normadReport parameters are easy to declare. Go to layout tab and report menu,
report parameters. Add a parameter.
Now, you don't really say where you want to use this expression. Is
EarnDed00 a field in a dataset? Are you wanting to use this expression to
pass a value to a stored procedure? Are you wanting the expression to be
shown in a field of the table object?
Read up on expressions. And note, when you create a query parameter RS
automatically creates a report parameter but you don't have to use it, you
can map a query parameter to an expression.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"NormaD" <NormaD@.discussions.microsoft.com> wrote in message
news:98012AA4-B6EA-4270-8BFB-265E8E35152B@.microsoft.com...
>I need to declare a report parameter, for example BegPeriod. Once that
> parameter has been declared I need to work the parameter. For example the
> parameter needs to evaluated with the following statement: "if
> right(BegPeriod, 2) = '01' and left(BegPeriod, 4) = '2006' then use the
> value
> in EarnDed00 else 0 Jan". This returns a month, year and deduction value.
> that will need to be done for all months.
> Will Reporting Services do this? If so, can you direct me to the correct
> method.
> Thank you,
> normad
>|||Bruce: Thank you. I want this expression to be shown in the report. Can
this be done?
Norma
"Bruce L-C [MVP]" wrote:
> Report parameters are easy to declare. Go to layout tab and report menu,
> report parameters. Add a parameter.
> Now, you don't really say where you want to use this expression. Is
> EarnDed00 a field in a dataset? Are you wanting to use this expression to
> pass a value to a stored procedure? Are you wanting the expression to be
> shown in a field of the table object?
> Read up on expressions. And note, when you create a query parameter RS
> automatically creates a report parameter but you don't have to use it, you
> can map a query parameter to an expression.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "NormaD" <NormaD@.discussions.microsoft.com> wrote in message
> news:98012AA4-B6EA-4270-8BFB-265E8E35152B@.microsoft.com...
> >I need to declare a report parameter, for example BegPeriod. Once that
> > parameter has been declared I need to work the parameter. For example the
> > parameter needs to evaluated with the following statement: "if
> > right(BegPeriod, 2) = '01' and left(BegPeriod, 4) = '2006' then use the
> > value
> > in EarnDed00 else 0 Jan". This returns a month, year and deduction value.
> > that will need to be done for all months.
> >
> > Will Reporting Services do this? If so, can you direct me to the correct
> > method.
> >
> > Thank you,
> >
> > normad
> >
> >
>
>|||Easily. If you are using the table control add another column (right mouse
click on a column and add one to the left or right of an existing one). Then
do a right mouse click on the new field in the detail row and pick
expression. This brings up the expression builder. Read up in books online
how to write expressions. You can easily do this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"NormaD" <NormaD@.discussions.microsoft.com> wrote in message
news:FD3119FF-7E16-4B81-B7B9-DBC6AC230A5F@.microsoft.com...
> Bruce: Thank you. I want this expression to be shown in the report. Can
> this be done?
> Norma
> "Bruce L-C [MVP]" wrote:
>> Report parameters are easy to declare. Go to layout tab and report menu,
>> report parameters. Add a parameter.
>> Now, you don't really say where you want to use this expression. Is
>> EarnDed00 a field in a dataset? Are you wanting to use this expression to
>> pass a value to a stored procedure? Are you wanting the expression to be
>> shown in a field of the table object?
>> Read up on expressions. And note, when you create a query parameter RS
>> automatically creates a report parameter but you don't have to use it,
>> you
>> can map a query parameter to an expression.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "NormaD" <NormaD@.discussions.microsoft.com> wrote in message
>> news:98012AA4-B6EA-4270-8BFB-265E8E35152B@.microsoft.com...
>> >I need to declare a report parameter, for example BegPeriod. Once that
>> > parameter has been declared I need to work the parameter. For example
>> > the
>> > parameter needs to evaluated with the following statement: "if
>> > right(BegPeriod, 2) = '01' and left(BegPeriod, 4) = '2006' then use the
>> > value
>> > in EarnDed00 else 0 Jan". This returns a month, year and deduction
>> > value.
>> > that will need to be done for all months.
>> >
>> > Will Reporting Services do this? If so, can you direct me to the
>> > correct
>> > method.
>> >
>> > Thank you,
>> >
>> > normad
>> >
>> >
>>