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