January 19, 2009 at 6:10 am
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
----------------------------------
We born to learn and help :hehe:
January 19, 2009 at 7:10 am
You have asked for specific answers to general questions. Please see the links in my signature.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 19, 2009 at 11:32 pm
ok you are right ,
I try more for better question , so I ask one by one .
**I make a report for several state of my report , that depends on Input of stored procedure , if one of them is "" I invisible it in report Layout but if it is not "" I visible it in layout . this stored procedure have 15 parameter input and 20 field output and more records.
i made it but it is very slow and take cpu of server very very very !
u think where is problem ? my way to make dynamic report(**) or my setting of cache or ... , I use defualt of configuration and settings
is it clear ?:)
----------------------------------
We born to learn and help :hehe:
January 19, 2009 at 11:42 pm
I still don't understand your question.
Let's see if we can narrow things down a bit.
You have developed a report using SQL Server Reporting Services, correct?
This report retrieves data from the database using a stored procedure?
The stored procedure has 15 input parameters and outputs 20 columns and N number of rows based on the parameters provided?
This report performs poorly and you need to know how to improve the performance?
If you answer these questions someone may be able to help. You should also provide the stored procedure code and the DDL for the tables accessed.
Please take the time to read the articles linked in my signature.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 19, 2009 at 11:52 pm
How much varied your parameters are?
If it varies a lot, sometimes cached execution plans are not as useful
you can recompile it each time.
But you can tune the query by looking at the execution plan and adding appropriate indexes. To be able to get a more clear idea, please post your code
January 20, 2009 at 4:38 am
tanx my friends ,
I solved the problem my query has problem .
now 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?
----------------------------------
We born to learn and help :hehe:
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply