SSRS Cascading Parameters not working in Sharepoint 2010 Dashboard

Question

Hi

I have two SSRS reports in Sharepoint 2010 dashboard.Both Reports use 6 parameters ,first is a date parameter and rest all are cascading parameters dependent on value selected in date parameter.FYI,these cascading parameter query Oracle DB from a shared date set . 

In Sharepoint i created Date Parameter and passing the value to corresponding date value to ssrs reports .Date Parameter is passed correctly to SSRS reports ,but cascading parameter values are empty.The report work fine from Sharepoint library ,but doesnt work from Sharepoint Dashboard.

Please suggest

Thanks in advance !! 

Answer 1

Hi,

Thank you for your question.

I am trying to involve someone familiar with this topic to further look at this issue.

---

Xue-mei Chang

TechNet Community Support

Answer 2

Hi,

Can you clarify the SharePoint Dashboard?  Is it a Performance Point Dashboard or something else?  Please let us know how you created this.  The closest match to your description so far is:

http://blogs.msdn.com/b/performancepoint/archive/2011/08/18/using-reporting-services-in-sharepoint-integrated-mode-with-pps-2010-with-sql-server-denali-ctp3.aspx

We just need a little more clarity on this.

---

Regards, Savoeurn Va Microsoft Online Community Support