I have been creating a report within SSRS containing a number of tablix matrix and charts. My current execution time is just over 10 seconds however I want to get it down to 5 seconds. I'm new to SSRS so apologies if this is a silly question. I have been researching optimisation techniques online and have found I need to look at the execution plans for the reports. I have narrowed my slow rendering issue down to one of the charts within the report (a line graph) for which I have looked at the SQL query and used the execution plan to determine the problem. It told me to index an area of the query which I have now completed however it doesn't seem to have any impact within the running time of the SSRS report. At the moment it's still running at just over 10 seconds. Does anyone have any ideas as to what else I can try?