none
SSRS 2008: How to show part of the parameter value in chart title

    Question

  • Hi,

    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!

    Best Regards.


    Connie Zhu
    Friday, December 17, 2010 6:37 AM

Answers

  • Hi Connie Zhu,

    Try the expression: =Switch(Parameters!YourPara.value = "Content Intelligence Platform (CIP)","CIP",Parameters!YourPara.value = "Wave 16","W16")

    thanks,
    Jerry

    • Marked as answer by Connie Zhu Tuesday, December 21, 2010 5:24 AM
    Monday, December 20, 2010 7:10 AM

All replies

  • Hi,

    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.

    regards


    Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

    BH

    Friday, December 17, 2010 9:58 AM
  • Hi Connie Zhu,

    Try the expression: =Switch(Parameters!YourPara.value = "Content Intelligence Platform (CIP)","CIP",Parameters!YourPara.value = "Wave 16","W16")

    thanks,
    Jerry

    • Marked as answer by Connie Zhu Tuesday, December 21, 2010 5:24 AM
    Monday, December 20, 2010 7:10 AM
  • Hi,

    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.

    Regards.


    Connie Zhu
    Monday, December 20, 2010 7:14 AM
  • Hello,

    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.
    Monday, December 20, 2010 9:12 AM
  • Thanks!
    Connie Zhu
    Tuesday, December 21, 2010 5:24 AM