Parameterized Expression

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

I don′t think taht this will work, perhaps you might be able to get the data through the object model in custom code. I never tried that for myself, so I ccan not help you with that.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

A user in another forum gave me the correct syntax. I had tried every combination similar to this, but never got it right.

=Fields(Parameters!chrt.Value).Value

|||Cool, yes this is what I ment by object model, but I wasn′t aware that it was that wasy :-D|||

Cool, yes this is what I ment by object model, but I wasn′t aware that it was that easy :-D