Friday, May 04, 2012 5:38 AM
I have a report thathas 10 multivalued parameters...
each time I want to select 1,2 or many on each on of them... the whole report goes to "Loading"
is it to do with the amount of overhead data being loaded? if so, whats the best way to aproach it?
or how can it be stopped from reloading each time I attempt to select a value from the parameters...
Friday, May 04, 2012 9:05 AM
Follow the link below. It may help you.
Friday, May 04, 2012 9:23 AM
I think you report parameters are cascading type.Kindly check.if so then depending on your selection of the parent parameter the child parameters change the values. This is as per design.
Rakesh M J | MCTS,MCITP ( SQL SERVER 2008 )
Dont forget to mark it as Answered if found useful | myspeakonbi
Friday, May 04, 2012 11:30 AMModerator
It depends on the design of your parameters. if you have design the cascading parameter then dependent parameter will automatically refresh if the parent parameter get changed.
Syed Qazafi Anjum
Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
- Proposed As Answer by Syed Qazafi AnjumMicrosoft Community Contributor, Moderator Friday, May 04, 2012 11:30 AM
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Monday, May 14, 2012 1:11 AM
Friday, May 04, 2012 2:08 PM
change the parameter as in following image.