Hagerty Insurance, headquartered in Traverse City, MI, has an opening for a BI Data Analyst/Data Mining Specialist. To find out more about this position and check out more about Hagerty’s great career opportunites visit here!
Follow @Hagerty on Twitter to experience what we are all about! Trust me, it is an AWESOME place to work.
Here are a few tips I’ve discovered whilst building SSRS reports to host in SharePoint. Some of these are report based tips and a few apply to SharePoint. I willadd to and update these as I discover more.
1. [Report based] Avoid using the Total Pages built in field as if you use this the rendering engine has to complete a full pre-render of the entire report primary dataset before it starts the final render. This can add a great deal of processing overhead and the report will take much long to finally display;
2. [Report based] Ensure results are paged. This should occur by default but if you choose to turn it off for your report there is a risk that you will encounter problems as the HTML rendering format that is used to initially render a report opens the report in your browser. If the report is not…
View original post 94 more words