Post reply

Expression in a report

  • April 18, 2016 at 7:31 am

    #309925

    Dear all

    I have a report that shows the way people have contacted our business - phone, email etc. When people run the report, they choose the contact method via a drop down parameter. They can select one / many / all contact methods.

    I have added a chart to my report that shows top 10s by contact method - basically why did people contact us.

    In order to be reasonably dynamic, I have added this expression to the title of the chart:

    ="Top 10 contact reasons:" + " " + Parameters!Contact.Value(0)

    This works fine when one contact method is chosen, but not more than one.

    Ideally I'd like the title to say, if someone has chosen more than one contact method (say phone and email):

    "Top 10 contact reasons: phone and email"

    At the moment it just shows one value, because my expression isn't dynamic enough to include more than one choice.

    If anyone has any suggestions to improve my expression, I'd be very grateful.

    Thanks.

  • April 18, 2016 at 7:40 am

    #1872750

    You could use the JOIN function to concatenate the values of the selected parameters.

    https://msdn.microsoft.com/en-us/library/ms157328.aspx

  • April 18, 2016 at 7:49 am

    #1872755

    tripleAxe (4/18/2016)

    You could use the JOIN function to concatenate the values of the selected parameters.

    https://msdn.microsoft.com/en-us/library/ms157328.aspx

    And that is what I did:

    ="Top 10 contact reasons:" + " " + join(Parameters!Contact.Value,",")

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply