110 likes | 227 Views
Microsoft SQL Server Reporting Services Technology Overview. Ike Ellis – Ellis Team Son Nguyen – Fish & Richardson P.C. Agenda. Architecture Report Creation Business Intelligence Development Studio Report Builder 2.0 Report Delivery Delivery Options Format Options
E N D
Microsoft SQL Server Reporting Services Technology Overview Ike Ellis – Ellis Team Son Nguyen – Fish & Richardson P.C.
Agenda • Architecture • Report Creation • Business Intelligence Development Studio • Report Builder 2.0 • Report Delivery • Delivery Options • Format Options • Application Integration • SharePoint • Custom .NET Applications
Architecture • Cost • SQL Server 2005 • Requires IIS • Security Holes • Memory and Processor Intensive • SQL Server 2008 • Does not require IIS • Secure • Faster
Report Creation • BIDS – Business Intelligence Development Studio (Integrates with Visual Studio 2005/2008) • Vastly improved in VS 2008 • Report Builder 2.0 • Released in October 2008
Report Delivery • Delivery • Push subscriptions • Ad-Hoc • Report Formats • Excel • PDF • HTML • JPEG • TIFF • XML
Application Integration • SharePoint 2007 • Show SP Report Portal • Custom Applications • Customized Report Options • Context Based Report Generation • .NET RDL Viewer
Conclusion • Q & A • Contact Information • Ike Ellis • ike@ellisbi.com • Son Nguyen • nguyen@fr.com