Parameters autorefresh

Question

Hi there...

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...

Cheers!

---

Elias

Answer 1

Hello,

Follow the link below. It may help you.

http://www.mssqltips.com/sqlservertip/1904/optimize-report-parameter-dropdowns-in-sql-server-reporting-services/

Answer 2

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.

Cant avoid.

---

Rakesh M J | MCTS,MCITP ( SQL SERVER 2008 )

Dont forget to mark it as Answered if found useful | myspeakonbi

Answer 3

Hi there

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.

Many thanks

Syed Qazafi Anjum

Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Answer 4

change the parameter as in following image.

regards,

Noman Rao

---

NOman Rao