Dynamic Report

[NeverFade]

hi every body
I need help for my reports
I develop dynamic report by this way : I made a report by 15 input parameter to Stored procedure that can be or not , and by my output some of report items can visible or not . i made it and it worked but it take cpu usage of server and take more time .
1- i need some help for this algorithm that i developed
2- I need good information about performance of it.
3- I need good settings for caching & I dont know how can cache RDL s I think fetch RDL s from database take several time and cause low performance and rate .


plz help me if u can
tanx

[NeverFade]

I like to know , how report server works? is it fetch all record and send them to client , or page by page send them to client ?

what is the role of table of report serverTemp database such as chunkdata ..?

would you send me good article?

[Island1]

This omnibus entry consists of a series of (some large) questions. Please restate them singly, so we can deal with each one in an organized way - asking for more information in those that are ambiguous - and offer more useful solutions that others can logically search upon and use.

Many Thanks.

Bill