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.