Blog Home  Home Feed your aggregator (RSS 2.0)  
.Net Jonesie - Wednesday, February 23, 2005
A simple programmers blog
 
# Friday, January 28, 2005

I've create a component for viewing SQL Reporting Service reports in WinForms applications.  Unlike the MS suggested method of using the webbrowser component, mine uses a PrintDocument and calls the RS Web Service directly.

I can't take much credit for this as it's mostly just a wrapper for some code by Bryan Kellar.  See his post here.

Anyways, you can download the code from here: SQLRSPreview100.zip (76.11 KB). If you have any suggestions or find any bugs, drop me a line and I'll do my best to improve it - at least until MS provides something better.

Usage

There are 5 main properties on the component:

RSServerURL URL for the report server ASMX file.
ReportPath Folder containing the report.  You must include the trailing backslash.
ReportName Name of the report (excluding .RPT extension)
Document The PrintDocument.  Use this in you PrintPreview control, PrintPreviewDialog control or PrinterDialog control.
Parameters

When you set all 3 of the RSServerURL,ReportName and ReportPath properties, the component will try to connect to the web service and retrieve the report parameters.  You can then use the Parameters array to set values before executing the report.

 

Exception handling is non-existent.  There are no nice property editors and very little validation.  This is scheduled for a future release.

 

Friday, January 28, 2005 6:05:00 AM (New Zealand Daylight Time, UTC+13:00)  #    Comments [0]   Old Blog  | 
Copyright © 2012 Peter G Jones. All rights reserved.
DasBlog 'Portal' theme by Johnny Hughes.
Pick a theme: