Post reply

SSRS Multi-value parameters - Total/Sum/Count

  • September 11, 2015 at 8:57 am

    #311535

    I have a multi-value parameter that I am having a hard time writing a COUNT expression for in SSRS. Here is the situation:

    1. If the "(Select All)" in the drop down is selected, COUNT all last names for ALL of the Auditor parameter

    2. If a specific or multiple auditors are selected from the drop down, COUNT all last names based on that selection for the Auditor parameter

    Currently, I am having it COUNT by ALL and it works but if a specific or multiple auditors are chosen, then the COUNT doesn't work.

    Thanks in advance for any assistance you can offer.

  • September 11, 2015 at 10:06 am

    #1826062

    Try it like this...

    =Parameters!ReportParameter1.Count

  • September 11, 2015 at 10:58 am

    #1826079

    This works if I'm only needing to use the SELECT ALL piece but where I have a multi-value parameter that if a specific or multiple auditors are selected from the drop down, COUNT all last names based on that selection for the Auditor parameter...then the COUNT doesn't work as you've added here.

  • September 11, 2015 at 11:10 am

    #1826084

    trvlbabie (9/11/2015)

    This works if I'm only needing to use the SELECT ALL piece but where I have a multi-value parameter that if a specific or multiple auditors are selected from the drop down, COUNT all last names based on that selection for the Auditor parameter...then the COUNT doesn't work as you've added here.

    Works fine for me. I tested in VS 2010 & VS 2012. I use it on a pretty regular basis to prevent long arrays from being passed when "Select All" is chosen...

    =IIf(Parameters!CompID.Count = Parameters!CompIDHide.Count, 0, Parameters!CompID.Value)

Viewing 4 posts - 1 through 4 (of 4 total)

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