Posted: 6/19/2012
Hi,
Crystal Reports can put some formula fields in another formula for creating dynamic effects.
Just wondering:
Is it possible to put some expressions in another expression through SSRS 2008?
For example, I would like to use an Expression for a dynamic chart title like: =Fields!field_name.Value & " - " & (Expression 1) & (Expression 2)
If it is possible, how to create an independent Expression?
Or the only for the above purpose is to use Custom Code References in Expressions?
Thank you in advance.
Can you elaborate on exactly what you plan to do with Expression1 and Expression2? Is there a reason you can't just build everything into the chart title expression?
You might be able to use a hidden/invisible textbox or an internal parameter to build your expressions.
Posted: 6/22/2012
Thank you Daniel,
I just want to do the following steps as I can do in Crystal Reports with Formula Fields:
1) set up the 1st expression independently and give it a name <<Expression 1>>
2) set up the 2nd expression independently and give it a name <<Expression 2>>
3) create the 3rd expression for a dynamic title like: =Fields!field_name.Value & " - " & (Expression 1) & (Expression 2)
I know how to embed expressions in another expression in SSRS.
However, according to my current knowledge, I don't think SSRS 2008 have the above function as CR with Formula Fields.