How to get value with two parameter fro sharepoint list in SSRS reporting

Question

Hi 

I am using Sharepoint list and fetching data in SSRS.

Using three parameter as Department,Section and subsection.

with filter everything working fine,but if i use category All and Sub category all for particular department,unable to get record.

please let me know how to implement.

Help will be appreciated.

---

Hasan Jamal Siddiqui(MCTS,MCPD,ITIL@V3),Sharepoint and EPM Consultant,TCS

| | Twitter

Answer 1

Hi Hasan,

Per my understanding you want to add mutilple value parameters to filter the data in the sharpoint list datasource report, right?

I have a test based on the step by step details information in below link and all works fine which will make the multiple value parameter works fine:
https://audministrator.wordpress.com/2014/02/17/sharepoint-list-add-distinct-parameter-value/

1. Add the custom code from above link
2. Parem1 is the parameter which get values from a query and with all the values(duplicate value),please setting as below:
   
3. Param2 is the parameter which will display in the report have done the deduplication, check the "Allow Multiple values" and then Specify the available value and default value using below expression:
   =Split(Code.RemoveDups(JOIN(Parameters!Param1.Value, ",")), ",")
4. Add the filter and preview.

Similar thread below for your reference:
SSRS reporting with sharepoint list using Distinct and Multivalue parameters

If i have some misunderstanding, please try yto provide more details information about your requirements.

Regards,
Vicky Liu

---

Vicky Liu
TechNet Community Support

Answer 2

Vicky - I'm also trying to use two parameters.  I have the above solution in a report and it works great for one parameter, but I'm not sure what I need to do to add a 2nd parameter.  For instance, one parameter is for the Application (select Word, Excel, PowerPoint for instance) and the other parameter is for the status (Open, closed, etc.)  The Application list could be gotten from a separate SP list, or I can get it from the Request list (multiple applications and statuses).  The Status can only be gotten from the Request list.  I believe I have to do something with the CAML for both parameters to work?  In the example out there in wordpress, the 2nd parameter is filtered based on the 1st parameter and that is not what I need.  I need to select Word and Active and get all active requests for Word.  Or select Excel and Closed and get all closed Excel requests.  Are you able to help?