"randscott" <rscott@plato.com> wrote in message
news:1152724801.223473.94690@h48g2000cwc.googlegroups.com...
>I am trying to write an expression based on a parameter for a text box.
> If I write it without the parameter it works fine, but when I add the
> parameter, the expression evaluates as just text.
>
> My dataset contains a field called "PeakSessions"
> I have a parameter called "chrt", type string, containing the value
> "PeakSessions".
>
> =Fields!PeakSessions.Value <= Works fine. Displays the PeakSession
> data.
>
> ="Fields!" & Parameters!chrt.Value & ".Value"
>
> This parameterized version evaluates to: Fields!PeakSessions.Value.
> So it seems the parameter resolved correctly, but my expression is
> being evaluated as text. What am I doing wrong?
>
> SQL 2005 Reports Services, SP1, Standard Edition
>

"randscott" <rscott@plato.com> wrote in message
news:1152729191.900859.300580@m79g2000cwm.googlegroups.com...
> You are right. I was just creating text, but I couldn't figure out the
> right way. I had tried something similar to your suggestion
> =Fields!(Parameters!chrt.Value).Value but the extra exclamation point
> caused me problems. Your way worked. Thanks!
>
>
> Bruce L-C [MVP] wrote:
>> You are just creating a string. Let's say you were trying to create a
>> string
>> to display. This is how you would do it. RS will not evaluate the string
>> which is what you are trying to do. You should be able to do something
>> like
>> this:
>>
>> =Fields(Parameters!chrt.Value).Value
>