.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

Adding a Chart to a Local Report

Posted By:      Posted Date: August 27, 2010    Points: 0   Category :ASP.Net

Dear All

I have created a report as a local report which looks like this:

I'm trying to add a chart to this report and I'd like it to display something like this (so sorry for the crude drawing):

It seems like it should be quite straight forward but I've tried dragging the fields into the chart all different ways and can't make it happen. I'm using Visual Studio 2010 and here's what my list of fields from the dataset look like:


I thought ObservationYear would be the series and all the other fields would be the data but this doesn't work. It produces a chart like this which wasn't what I was hoping for:

Please could you help me understand what it is I'm doing wrong? I'm very grateful for any help/advice you might be able to provide.

Kind regards








View Complete Post

More Related Resource Links

report viewer: Adding Image to local report export drop down list


Is there an easy way to add image to the drop down list that is build into the report viewer export list?



crystal report -visual studio 2008 dual axis chart (bar & line)


dear all, 

i use crystal report integrated with  vs.2008, and i want to make chart with dual axis (bar & line).

i have used bar chart and input the data with 2 values..

then in chart options > template, i activated the dual axis..

my question is, how i can change the 2nd value with line chart not bar chart??

i'd tried to find the right settings in "chart options" but still can't find the solution.

for information in "chart options" there are 4 sub menu : template, general,titles,grid..

i read in a tutorial there's more sub menu called "series" in crystal report (stand alone version)..

is it possible doing it in Crystal Report VS. 2008?

please,, i need your advice and solution..

Thanx before..


Local Report - nested objects



I trying to use Object data source for my local report. But the problem is that the datasource is having nested objects and I am not able to access the properties of the nested object.

I tried using =Fields!HomeAddress.Value.Zip as mentioned on this site


but couldn't get it working. Its returns #Error for this field.

I am using visual studio 2010 for developing this report

Please help.






Adding a button to the Report Portal

Hi everyone, I am using SSRS 2008 and would like to know if there is a way to customize the Report Portal?  I need to add a button that the user can click on when they find a bug or the report doesn't work.  The button would open an email window for the user to type in the problem they are experiencing and it would be sent to our Ontime system.      Thanks for your help!  Youngmon...  

Adding SharePoint Toolpart to SQL Report viewer

I am new to the Business Intelligence Project plug in for Visual Studio. I have a SQL Report created in Visual Studio using the Business Intelligence Report Server Project.  I am hosting the report in a SharePoint Report Viewer Web part. I have 2 questions:  1.  Is it possible to create a code behind module for the report in C#?  The only codebehind module I see is in XML.  I have seen many posts with C# code in them however they do not explain how to get to the code behind. 2.  Is it possible to pass values from a SharePoint Toolpart to a SQL Report (via the Report Viewer web part) and use the value to generate the report? Thanks in advance.

creation of Chart in report ssrs 2008

HI All, I have to create report based on the chart in ssrs 2008 in which i have to use different bar for different coulmn,Kindly suggest how to start the same.   Shraddha

Setting Local Report Data Source

I am a college professor and am updating my undergraduate database course to use Reporting Services as the reporting tool.  The student labs cannot run IIS so I assume that using server-based reports is out and am looking at using local reports and the VB ReportViewer control. For several reasons (waaayyy too long to list here) I do not wish to use the drag-and-drop datasets that seem to be the core of the ADO.Net 2005 architecture.  Instead I prefer to create connections, commands, and datasets in code and to set data binding and manage data updates in code.  All command objects map to SQL Server stored procedures. I need to be able to do the same thing with reporting services local reports but have run into a brick wall in getting the report and/or report viewer to recognize a dataset table created in code. I would like to do the following (which worked very well in VB 2003 using Crystal Reports): 1. Design report--I am willing to accept the requirement to manually set the Value property of controls since I don't want to set data sources to .xsd files. 2. Instantiate a report object at run time and set it's data source to a dataset table.  The underlying query that fills the table would have to contain all columns needed by the report's controls. 3. Set the report object to be the LocalReport for a ReportViewer control. Can anyone point me to a tutorial or walk-through tha

Adding a table or view multiple times when building a query with BI Report Designer and Report Build

How can I add a table/view multiple times to a single query by using BI Report Designer or Report Builder 3.0? In Report Designer I managed (workaround) to add one table multiple times by creating multiple Named Queries and having the same SELECT. Still I don't know how to add one table multiple times in Report Builder 3.0.

Problems deploying Report in Local Server (localhost)


OK, I'm kind of new to SQL Server 2008 and I'm having issues trying to deploy a report in my local server.


Basically, I installed SQL Server 2008 R2 in my personal desktop and because of this, I thought no Service Account were necessary since I was going to be the only one accesing it; anyway; I've created a set of reports and everything works fine; but when I try to deploy them, they won't go through.

I open a browser and type http:\\localhost\reportserver and it actually requests me for a password; the username is already populated, which is the name of my computer, but then for the password, I didn't set up any password for anything, during the installation and if I put my computer password, it doesn'y work either, after three attemps, the browser simply goes blank.

I'm sure this might be a very basic issue, but I've been trying to look for answer, online, through forums etc; and no good luck yet...


Thanks in advanced for all your help!



Adding Lookups to Report fields in Report Builder 2.0


Since Report Builder 2.0 is targetted at making reporting simple to create by end users, and most databases are normalised, I am looking for a way to add lookups to report fields.  By this I mean that the report should display a description rather than the code actually stored in the record being reported.


I know that this is possible by altering the SQL for the main report dataset to include a "left outer join" to the table of codes and descriptions related to the foreign key column, returning the description rather than the code (see below), but this is not something that I would expect end users to be able to implement.


select m.id,




... etc ..

from    main_table m left outer join

          lookup_table lu on lu.Code = m.code1


For end users, I would expect a right click menu on the

Adding parameters via URL to a SSRS report stored in Sharpeoint 2007

I am trying to pass parameter to a SSRS Report via URL stored in Sharepoint 2007 (integrated mode) but that doesn't seems to work. The report opens without the parameters taken into account. Any sggestions on how to pass parameters to SSRSreport on sharpeoint?..Thanks for your help...

SSRS 2005/2008 - Chart with bar graph not generating on subsequent executions of report even with mo


For a report executed from Report Manager that has a bar chart component, regenerating the report via refresh or view with same input parameters either gives a different result that is garbled or an empty chart (2008) or no chart at all (2005). I have the report set up to not do any caching, so that does not seem to be the issue. Is there some chart option I may need to set to get the proper chart display.

Status of Accessing Nested Objects in Data Source of Local Report Does Not Function


We recently upgraded out platform to .NET 4.  We are also using Microsoft Reporting dlls.  Unfortunately, we found that the upgrade broke all of our reports.  Researching the cause, we found this article:


It seems that this issue has been open for some time now and I have not seen a good workaround (except for the shim class which is not really feasible for us).  Can I please get a status update for this?  Is there some other type of resolution?

Thank you,

Benjamin Strum 

Ben Strum

An error occurred during local report processing


My report runs fine until I added a new field ("TradeDate") to the datasource. when run the report, I got the following  error:


 Error 1 The Value expression for the textbox 'textbox68' refers to the field 'TradeDate'.  Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope. C:\Pro1\Allocation.rdlc 1 


I can see the "TradeDate" on the Datasource list on the left pane after i built the project. But it seems rdlc file still catch the previous datasource, not the current one..



sql 2005 chart report


Hi i am using sqls 2005,i have creted a Bar chart

MY x axis contained report name and Y axis contain number of user who have access those reports

i am getting proper data at X axis but at Y axis i am getting data in ackward range ie 5 ,84 ,163,251,321

but these are the number of user who have aceess the report ,i want them to come in this patter..5,10,15,20,25...etc
or 10.20,30,40..etc in any of the above 2 patter..what should i do to achieve this in sql  2005 bar char reports 

Export SSRS report to excel with data of pie chart



I am new to SSRS. I have a report with a pie chart . When I export the report in excel format, pie chart is displayed as picture. I want it to be displayed as editable pie chart with data. 

The requirement is, if user want to change the data in excel sheet after exporting, changes should reflect in pie chart of that excel sheet.

Please suggest me the way of achieving it.


Error "OutputStream is not available when a custom TextWriter is used" on Local Report


 Hi, i'm facing this error: "OutputStream is not available when a custom TextWriter is used"


Here's the code:

 internal void RenderReport(ReportViewer reportViewer, HttpResponse response)
            Warning[] warnings;
            String[] streamids;
            String mimeType;
            String encoding;
            String extension;

            Byte[] bytes = reportViewer.LocalReport.Render("PDF", null, out mimeType, out encoding, out extension, out streamids, out warnings);

            String sFileName = DateTime.Now.Ticks.ToString();


            response.Buffer = true;
            response.ContentType = "application/pdf";

            response.AddHeader("content-disposition", string.Format("attachment; filename={0}.{1}", sFileName, extension));

            response.Charset = "utf-8";
            response.ContentEncoding = Encoding.GetEncoding("iso-8859-1");


..The error occurs on the  "response.BinaryWrite(bytes);" section.

The purpose of this code is to generate a pdf report and le the user downlo

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