1 / 13

Advanced SSRS Find out what you have been missing

Advanced SSRS Find out what you have been missing. Presented by: Emil Glownia. Purpose of the session?. Show you SSRS report examples that you may not have seen before and briefly explain how they are created Give you ideas which you might want to use. “Branding” (Styles).

amos-roberts
Download Presentation

Advanced SSRS Find out what you have been missing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Advanced SSRSFind out what you have been missing Presented by: Emil Glownia www.sql-server-business-intelligence.com emil@itcouple.co.uk

  2. Purpose of the session? • Show you SSRS report examples that you may not have seen before and briefly explain how they are created • Give you ideas which you might want to use www.sql-server-business-intelligence.com emil@itcouple.co.uk

  3. “Branding” (Styles) • Configuration table with lookup function www.sql-server-business-intelligence.com emil@itcouple.co.uk

  4. Save Parameters • Save parameters • Below is very simple example using T-SQL (use stored procedure) www.sql-server-business-intelligence.com emil@itcouple.co.uk

  5. Gantt Chart (Matrix Grid) • Gantt Chart using subreport Grid www.sql-server-business-intelligence.com emil@itcouple.co.uk

  6. Matrix Grid (Design) • Gantt Chart “design view” • + functions (SetParameters, GridFunction, SetPercentageBar, GetColourScale) www.sql-server-business-intelligence.com emil@itcouple.co.uk

  7. Heat Map Algorithm • PUBLIC FUNCTION fGetColourScale(MinValue as double, MaxValue as double, ActualValue as double) as string • dim iRGBNumberas integer • if ActualValue > MaxValue then • ActualValue = MaxValue • end if • if isnothing(ActualValue) or ActualValue <=MinValue then • return "white" • else if ActualValue >MinValue then • iRGBNumber = (200-(200*((ActualValue - MinValue)/(MaxValue - MinValue))))+40 • returnstring.format("#{0:x6}",rgb(255,iRGBNumber ,iRGBNumber)) • else • return "white" • end if • end function www.sql-server-business-intelligence.com emil@itcouple.co.uk

  8. Gantt Chart Heat Map • Heat map using daily time spent on project per day www.sql-server-business-intelligence.com emil@itcouple.co.uk

  9. Gantt Chart (Bullet Chart) • Gantt Chart using bullet chart www.sql-server-business-intelligence.com emil@itcouple.co.uk

  10. To Do list • Javascript tooltip • Milestone Dashboard • Other examples www.sql-server-business-intelligence.com emil@itcouple.co.uk

  11. Q&A Session Questions? www.sql-server-business-intelligence.com emil@itcouple.co.uk

  12. Coming up… • #SQLBITS

  13. Thank you www.sql-server-business-intelligence.com emil@itcouple.co.uk

More Related