I have one doubt need your help.
I generated one chart in Reporting Services 2008, its data source is from Analysis Services. Here I want to change my chart title dynamically according to the parameter selected.
The following are two ways I need to go:
1. If I selected one parameter, it's named like 'Content Intelligence Platform (CIP)', for this situation, I only want 'CIP' to show in the chart title(as part of the chart title).
2. If I selected one parameter, it's named like 'Wave 16',for this situation, I only want 'W16' to show in the chart title(as part of the chart title).
As I am not familiar with Reporting Service, so I am not sure how to write the expressions. Can you help me? Thanks!
Based on the first samples you have provided, is it possible to treat like any name that has a text within paranthesis, only the word within paranthesis should be shown? Similary for the second sample, can we treat it like any name that begins with Wave? Out of these two condition, which one do you want to be evaluated first? Upon your reply, a suggestion can be provided. Please comment.
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
Thank you for your reply.
For my first example, I only want to words with the paranthesis to be shown. And "Content Intelligence Platform (CIP)" is only one value from the parameter values. their pattern is like "Axx Bxx Cxx (ABC)", and I only want "ABC" to be shown.
For my second example, please leave it, it seems the values don't have any pattern.
All the values in the parameter contains only three words and in between the parathensis if it contains three leteers then use below expression.
=IIF(InStr(Parameters!Pattern.Value,"(") = 0, Parameters!Pattern.Value, Replace(Right(Parameters!Pattern.Value,4),")",""))
Hope its clare & helpful....
Pavan Kokkula Tata Consultancy Services.