Third-Party Charting Products that work with ReportViewer?  
Author Message
Eva Pierce Monsen





PostPosted: Visual Studio Report Controls, Third-Party Charting Products that work with ReportViewer? Top

Hi there,

Does anyone know of third-party charting products that work with
ReportViewer in local processing mode I've looked at Dundas and
ChartFX, and I'm waiting to hear back from their sales & support
people, but from all outward appearances those two products only work
with reports that are generated on a server.

Thanks,
Eva Pierce Monsen



Visual Studio27  
 
 
Robert Bruckner MSFT





PostPosted: Visual Studio Report Controls, Third-Party Charting Products that work with ReportViewer? Top

Dundas, ChartFX, etc. are using the CustomReportItem feature of RS 2005 to integrate their products. The CustomReportItem feature is only supported through the report server and cannot be used in local mode of the controls.

In local mode, the closest you can get is to use a custom assembly to generate the chart image (as byte array). However this means that the custom assembly has to retrieve and prepare the dataset itself and cannot take advantage of grouping/sorting/filtering through the RS engine.

-- Robert



 
 
Eva Pierce Monsen





PostPosted: Visual Studio Report Controls, Third-Party Charting Products that work with ReportViewer? Top

I see! Thank you; this is helpful information. I'd like to follow up with one question. Assuming I was able to generate an image at run time, can I embed it in a ReportViewer local report on the fly (as opposed to at design time)



 
 
Jon M.





PostPosted: Visual Studio Report Controls, Third-Party Charting Products that work with ReportViewer? Top

Robert,

Thanks for your reply. Our company would be very much helped if we were able to use Dundas through the WinForms ReportViewer. Just wanted to put a plug in for adding the CustomReportItem API.

Is this even on the radar as a possible future consideration

Thanks,
Jon

 
 
Eva Pierce Monsen





PostPosted: Visual Studio Report Controls, Third-Party Charting Products that work with ReportViewer? Top

Glad to see others desire this feature also.

I just wanted to add that I heard back from tech support at both Dundas and ChartFX, and they pretty much agree with Robert, in that the best approach is to embed a chart as an image. Both companies have "workarounds" for generating a chart image.

I'm still investigating how to embed an image in a report at runtime. My guess has to do with saving a temporary image file and using/setting the value of a report parameter for the image URL.

Eva


 
 
Robert Bruckner MSFT





PostPosted: Visual Studio Report Controls, Third-Party Charting Products that work with ReportViewer? Top

While the image URL approach is a valid option, there is also another approach: you can set the image Source property to "Database". In that case, the Value property expression must evaluate to a byte array that contains the image data. So you would call your custom assembly function directly from the Value property.

-- Robert



 
 
Jon M.





PostPosted: Visual Studio Report Controls, Third-Party Charting Products that work with ReportViewer? Top

...and, should you need to place said image in a header, you can Base64 encode it and pass it in as a parameter, decoding within the design. Hopefully, this'll get easier in a future drop...