Thursday, November 4, 2010

Programming SQl Server R2 Reporting Services

Integrating reporting services into your applications

Paul Litwin

Slides from www.deeptrainging.com/litwin

SSRS has a number of APIs. 

Changes in R2:

  • Report Manager revamped
  • Support for Geospatial data
  • Shared data sets
  • New VS2010 Report / Viewer controls
  • New ReportService2010 web service endpoint
  • More data visualizations

URL Access – same as we have used, but there are options to render in other formats such as PDF.  So, no need to launch report viewer.  rs:Format=PDF  You can also pass in the page orientation and Margins.

Security – still requires local domain access.  External users could get access if you write an anonymous extranet web app which runs under someone with RS access.

Report Viewer Controls – Remote (server) Reports and Local Reports.  Not sure I understand the need for a local report unless your intention is to keep all your reports local to your solution.  They are less powerful as well.

No comments:

Post a Comment