1 / 10

SSRS Reporting Tips & Tricks authored by Chris Liley, Principal Consultant, I.B.I.S., Inc.

SSRS Reporting Tips & Tricks authored by Chris Liley, Principal Consultant, I.B.I.S., Inc. Regional Chapters. Topics. Installation & Security Query Design Working with Parameters Report Design Demonstration Sharing Tips & Tricks?. Installation & Security.

tillie
Download Presentation

SSRS Reporting Tips & Tricks authored by Chris Liley, Principal Consultant, I.B.I.S., Inc.

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. SSRS Reporting Tips & Tricks authored by Chris Liley, Principal Consultant, I.B.I.S., Inc. Regional Chapters

  2. Topics • Installation & Security • Query Design • Working with Parameters • Report Design • Demonstration • Sharing Tips & Tricks?

  3. Installation & Security • When possible, install SSRS on a separate server from the database server • Use Snapshots when possible • Think about using a single SQL account to connect data sources to the SQL database • Manage users folder/report access with AD accounts on the Report Manager site

  4. Query Design • Use Stored Procedures for your queries • Perform complex calculations with the database engine which is better optimized to handle tasks such as • Sorting • Filtering • Data aggregation • Expression Evaluation • Retrieve only the data we need for our report using parameters which we will cover next

  5. Working with Parameters • Uses of Parameters • To control Report Data • To control Report appearance • To connect to other reports • To select specific data columns • Creating Parameters • Attach to their own dataset • Different types available (Text, Date, etc.) • Choose whether visible or hidden • Set available and default values

  6. Report Design • Controlling Page Size • Logical Page Breaks (XML and CSV) • PageBreakAtStart • PageBreakAtEnd • Soft Page Breaks (HTML and WinForm) • InteractiveHeight • InteractiveWidth • Physical Page Breaks (PDF and Image) • PageHeight • PageWidth

  7. Report Design (cont.) • Adding new lines in text boxes • Use the vbcrlf command • Alternating Row colors • =iif(RowNumber(Nothing) Mod 2, "#eefafd", "White") • Setting the “NoRows” property • Always name objects within a report • Leverage existing reports when creating new reports

  8. Demo Environment Information • Windows 7 Enterprise • GP 2010 R2 • SQL Server 2008 R2 • 8 GB RAM

  9. Demonstration • Will use a stored procedure (Best Practice!) • Will use two parameters • Will add new lines in a text box • Will alternate row colors • Bonus!!! Will turn on toggling at the grouping

  10. Sharing Tips & Tricks? • Your experiences? • Questions?

More Related