Layout component reference in report studio

[BiliBoy]

does  too many layout component references in report makes report perfomance very slow?  if it is then what could be the reason ? how to minimize report execution time with too many layout component references?

[blom0344]

Just an idea:

Copy the report and strip it regarding layout component references. Then time both reports with the same input. Make sure to time after multiple executions otherwise  database optimizer and caching can influence the comparison..

[bdbits]

If the layout component references do turn out to be the problem, you could try changing the layout component property "Embed".  If you set it to "Reference" - the default - it will go find the component source each time the report is run. If you change it to "Copy" it will keep a copy in the target report, however if you change the source you will need to right-click the target's layout component and select "Update Component Copy".