.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Is it possible to make Reporting Services use a different chart rendering engine instead of the buil

Posted By:      Posted Date: September 17, 2010    Points: 0   Category :Sql Server
Is it possible to make Reporting Services use a different chart rendering engine instead of the built-in one? E.g. to generate a datafile (e.g. CSV) and then use e.g. http://www.highcharts.com/demo to display the chart, rather than the built-in chart in reporting services?

View Complete Post

More Related Resource Links

reporting services xy scatter chart with three data series

Hi, I have a report that includes an XY scatter chart with three data series.  Two of the data series are + and - tollerance bands and the thrid data series is the test points.  The data displays in the graph but I only seem to be able to get all three series to display as a line or all three to display as data points.  I need the tolerance bands to be a line and the test point to be displayed as data points without a line joining them up. Please can you provide a solution.   Thanks

"The Database Engine instance you selected is not valid for this edition of Reporting Services" erro

Hi there, I have developed some reports using Visual Studio and everything worked fine in the office. Now I'm trying to deploy them on my customer PCs but this process keeps failing. These reports can be built and even previewed within Visual Studio but they cannot be deployed. Here is the error message I get: ----------------------------------------- The feature: "The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for report data sources or the report server database." is not supported in this edition of reporting services. ---------------------------------------- The versions of the software on my customer machines are: SQL Server Enterprise 9.0.3282 SQL Server 2005 Management Studio 9.00.4035 SQL Server 2005 Reporting Services Designers 9.00.4035.00 Visual Studio 2005 8.0.50727.42 I believe that changing the edition of the Reporting Services from Designers to Enterprise should fix the deployment error but I did not find a way or setup files to do so. Many thanks in advance for your help!

Excel Services / Web Access Line Chart Rendering

I have noticed in beta 2 that line charts are significantly pixelated / low res when the chart is rendered via Excel Services / Web Access, as compared to how the full Excel client renderes it.  Has this been fixed in the production release of Sharepoint 2010?  If not, are there any plans to improve this later? Our user community likes almost everything else but this about Excel Serivces. Unfortunately, the lack of presentation quality line charts in Excel Services maybe enough to disqualify our wide spread adoption of this great tool.  Help!

Reporting Services Chart in SharePoint Web Part, Broken Image Problem

I have a reporting services report that displays a dundas chart, it is a snapshot report executed daily.  When displaying the report inside a page viewer webpart or a report viewer web part in SharePoint, the first time after a recent snapshot occurs, the image shows up broken.  On refresh of the page the image is visible.

MOSS 2007
SQL Server 2005 Reporting Services NOT running in SharePoint Integration mode.

Any ideas or work arounds to get the image to display on the first load of the page or why the image is broken?  I've tried different report parameters, Format, ClearSesson with no luck.  Viewing the report in Report Manager works fine and also going directly to the ReportServer page is fine.  It only occurs when it's inside of SharePoint inside of the Page Viewer or Report Viewer web parts or even if I manually create an iframe in a content editor web part.


Error while Rendering Reports(Reporting Services 2005) in .Net 1.1 web Application on IIS 6.0


I developed an ASP.net 1.1 web application that is written in VS2203 and I am using Reporting Services 2005 to render some reports in PDF Format. My problem was it is working fine in local (XP) and Production environment (Windows 2003 Server).fromo long back the solution was not working for my integration Server which has windows 2003 Server (1.1) and we installed the 2.0,3.5 frameworks. It is throwing an Object refernce error while render the report. Is there any permisions or  something missing.

I have wasted so much time in a finding a solution and I appreciate any help in that.

Reporting Services 2005 now rendering PDFs differently!

We have a server running SQL 2005 and Reporting services. We have a Report we use to generate purchase orders and email the resulting PDFs to our vendors. All fields in this Report use Times New Roman, either 10 or 12, point, some bold, some not. This report has not changed in months.

Since Monday our vendors are reporting they are unable to copy and paste text out of some of the sections of the report. They get question marks, or boxes, not the text. This only happens on some of the fields in the report.

Neither the report nor the database has changed. SQL Server was upgraded over the weekend to 9.0.3282, the CU9 update. There may have also been some security patches applied, not sure which.

PDFs generated after the upgrades now have an additional font listed in the File | Properties dialog of Adobe Reader 9. It's a TrueType font.

Does anyone have any ideas or knowledge about how the PDF rendering component of MS Reporting Services may have changed? Any help would be welcome.

Barry Seymour

Can we have combo chart in SqlServer Reporting Services 2008 ?

I want to have a 2charts in a single chart area, e.g., linear chart on a bar chart 

eg., http://msdn.microsoft.com/en-us/library/Aa964128.moressrschartsfig10(en-US,SQL.90).gif

I'am using SSRS 2008...

Thank you


Rendering Reports in Reporting Services 2008 in Sharepoint Integrated Mode


I have created a site collection using the Report Center template. I successfully deployed my VS2008 Reporting Servivces project to the Sharepoint site. However, when I goto the reports library and attempt to run a report I get "unknown error" message"

Also, I can create a dashboard consisting of one of my reports. However, when I attempt to view the reports via the dashboard, I get the following error message:

An error occurred during client rendering.

The target location you specified is not supported by the report server. A report definition (.rdl), report model (.smdl), resource, or shared data source (.rsds) file must be located within a library or a folder within it.

SSRS Reporting Services issue with Rendering Report.


I have created a report that has a tablix with a single cell.  The tablix is set to a dataset that has multiple records, and for each record I am running another subreport inside the tablix cell.  I have the subreport creating a page break for each record, and when printed out the report is perfect, but in the interactive rendering mode with the SSRS Web Viewer, one of my pages comes out blank except for the header being present.

It is not adding an extra page, because in the print out that particular page is rendered with the correct data, but in the interactive mode it is completly missing. 

I would appriciate any advice someone might have.

Thanks in advance.

Integrate Reporting Services with Silverlight and RIA Services

One of the most wanted future features in Silverlight is the possibility to create business reports using Reporting Services. In this article, I will show how to use the existing Reporting Services technology with Silverlight and RIA Services combination.

Reporting Services SQL 2005 .Net 4 compatibility?


I've been working on my first asp.net application and for the most part it's been pretty smooth.  Right now I'm having trouble getting reporting services working under SQL Server 2005.  I developed the site with Visual Studio 2010 and didn't think about any of the .Net 4.0 compatibility issues that have arisen.  I'm having no problems with the site communicating with SQL Server 2005 for the regular database stuff.  The only problem I'm having is with setting up Reporting Services.  I have the .Net 4.0 framework installed on the server, however Reporting Services is still using 2.x.  I'm not sure if this is a problem with SSRS or with IIS.  When i go to localhost/Reports it's reading my web.config for my application and throwing an error: "Parser Error Message: Unrecognized attribute 'targetFramework'."  This is referring to a line in my web.config where targetFramework is set to 4.0.

Software that I'm using:

  • Visual Studio 2010
  • SQL Server 2005 Standard
  • IIS 7.0
  • .Net 4.0

Any suggestions?  

Reporting services in 2008 r2 how to get a report in a print button click event in my c#.net page


how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services


Thanks in advance

SOA Simplified: Service Virtualization With The Managed Services Engine


By using Managed Services Engine service virtualization technology, you can begin participating in the cloud by simply configuring virtual service endpoints and operations that integrate with the .NET Service Bus.

Aaron Skonnard

MSDN Magazine May 2009

Excel Services: Develop A Calculation Engine For Your Apps


The Excel Services architecture lets users design their own algorithms and share workbooks on a server.

Vishwas Lele and Pyush Kumar

MSDN Magazine August 2007

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services


Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

Data Points: Report Controls in SQL Server 2005 Reporting Services


Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006

Data Points: Designing Reports with SQL Server Reporting Services 2005


Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both Windows® Forms and Web-based applications.

John Papa

MSDN Magazine June 2006

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend