Cascading Parameter SSRS Report hangs on Production Server

Question

I have a report in which i used two multivalue parameters Affiliate, TFN. Both fetch their available values using query. Affiliate is independent while TFN list is populated once Affiliate is selected. The report works fine when i run in development mode in ssrs. But when i deploy, it always gets stuck after i select the first parameter, Affiliate. All buttons are grayed out and i'll have to re-run the report. Report always gets stuck, regardless of the TFN result set size.

Any help would be highly appreciated.

All buttons are grayed out...does this mean all options in the affiliate control are grayed out or the TFN control is grayed out? — Ross Bush
Yes, all options are disabled. I have to re-run the whole report. — aadi

Sam Sam · Accepted Answer · 2015-03-13T00:24:22

Add ScriptMode="Release" to the scriptmanager object on your aspx webpage

<asp:ScriptManager ID="ScriptManager1" runat="server" ScriptMode="Release">
</asp:ScriptManager>

Cascading Parameter SSRS Report hangs on Production Server

1 Answers