Introduction to SQL Server Reporting Services Architecture Development

Introduction to: SQL Server Reporting Services Architecture, Development & Delivery

About Me • • • Bret Stateham Owner of Net Connex Consulting and Training Services Working with SQL Server since v 6. 5 Teaching it SQL Server since v 7. 0 Contact Me: – Blog: blogs. netconnex. com – Twitter: @Bstateham – Email: bret@netconnex. com • Glad to be here! gettag. mobi

Agenda • Introduction to SQL Server Reporting Services • Developing SSRS Reports • Delivering SSRS Reports

What is SQL Server Reporting Services? “SQL Server Reporting Services (SSRS) is a server-based Microsoft. ”It can report generation software system from Microsoft. be used to prepare and deliver a variety of interactive and printed reports. ”It is administered via a web interface. ” Reporting services features a web services interface to support the development of custom reporting applications. ” SSRS competes with Crystal Reports and other business intelligence tools, and is included in Express, Workgroup, Standard, and Enterprise editions of Microsoft SQL Server as an install option…”

Html pdf xls Architecture Overview Corp Data Windows Server SQL HTTP. SYS Oracle Reporting Services /Report. Server Users & Admins Running IE RDL Other SQL Server Report. Server. Temp. DB Developer Tools Custom Code

Report Authoring Options • Business Intelligence Development Studio – Also Known As: BIDS • Report Builder 2. 0 (3. 0 coming soon) • Custom report generation using RDL (XML)

Report Items Control Description Textbox Show literal text, or expression results Line You guessed it, a line. Table Standard “table” (Tablix) Matrix Cross-tab style region (Tablix) Rectangle Graphical element & a container of other items List Rectangular data region (Tablix) Image Embedded, liked, or data driven images Subreport Master/Detail style control (use nesting instead) Chart 2 D and 3 D column, bar, pie, etc. charts Guage, meter, thermometer style visualizations

Report Authoring Demo

Report Delivery • “Report Manager” Web Application • Report. Viewer control – ASP. NET Control – Win. Forms Control • URL Access (Simply point to a URL) • Web Services – Programmatically render reports – Do whatever you like with the bits returned

Report Delivery Demo

Thanks • Keep In Touch! – Blog: blogs. netconnex. com – Twitter: @Bstateham – Email: bret@netconnex. com gettag. mobi