troubleshooting Question

Pass data from SSRS report back to SSRS reports main Stored Procedure

Avatar of thayduck
thayduckFlag for United States of America asked on
23 Comments1 Solution131 ViewsLast Modified:
In my SSRS report, I can tell if a user selected all the choices in the drop down parameter by doing:

=IIF(COUNTROWS("SC_procRptLstBusinessUnit").Equals(Parameters!BusinessUnit.Count), "All ", (Join(Parameters!BusinessUnit.Label, ", ")))

Then in my report, I would show the word 'ALL' somewhere in the report instead of listing out all the individual choices.

Now, my question is:

How can I pass back to my Stored procedure, via a parameter, the letter 'A',  so I know that the user chose all the choices from the drop down parameter ?

I tried passing back a parameter (@BusinessALL) to the SP but this code was not allowed in my parameter expression:

=IIF(COUNTROWS("SC_procRptLstBusinessUnit").Equals(Parameters!BusinessUnit.Count), "A", Nothing)

A aggregate or Lookup function are not allowed in a query parameter function.
Arifhusen Ansari
Business Intelligence Developer and Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Top Expert 2015

The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.

Join our community to see this answer!
Unlock 1 Answer and 23 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 23 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros