I have a table where I have
Amount paid, payment date
I want to write a query which will fetch the total amount of sales for a month based on the payment date.
And i want to represent the result in a pie chart like january(3000),february(90000),march(20000) etc.
how to group data in gridview.for example grouping data by sales or yearly or monthly or by country or region.....
View 2 RepliesI want to create a trafic controlling system and show data in a tabular format. as follows
----------------------------------------------------------------------------------------------------------------------
August
1 2
3 4
5 6
7 8
9 10 .......31
How to achive this using any of the data control gridview, datalist or repeater control ?the numbers 1,2,3....31 are the days in a month while "HomePage", "Maps" etc are the name of the pages and the entry below each date will show no of users visited the page. I want to show the same for every month
i have fetched required data and the output is as follows .
PageId VisitedDate VisitCounts PageName
The problem is that we have 5 different categories and we have to calculate the percentage of products sold in each category. Then we have to show that in sort of a chart. The interface of chart is shown here
http://img64.imageshack.us/img64/5397/52805880.gif although this chart has 14 boxes but I will be using 20 boxes in the final chart, the reason for that is that I want each box to represent 5% of sales. Now the question is suppose that the percentage for sales in each category is 34.4%, 12.6%, 23.2%, 22.6% and 7.2%. How do I convert these values to nearest 5 and then fill each box with that color. For example 34.4% means that almost 35% or 7 boxes will be colored with that color. The problem is that the sum of all of these must always be 20. I understand that this will not be very precise representation but this is the demand from the user.
how to design a monthly updated report the report design is like below
[Code]....
I have a grid view to show a listing of domestic sales and international sales. I share the same grid view for both. So if i select 'Domestic' radio button, i have to change the label of first column as 'SalesNo' and also set the sort expression as 'sales_No', if i select 'International' radio button, i have to change the label of first column as 'ExportNo' and also set the sort expression as 'export_No'. How can i do it using C# ?
View 1 Replieshow can I generate weekly and monthly attendance report calculating total attendance for each student that I have in mu database table?
View 1 Repliesi would like to create a report chart via sql command by using asp.net vb.net.
my sql coding:
[Code]....
I need to display a large monthly calendar of events for one of my websites and was wondering if the DayRender event loops through all days in any given month when the calendar control is displayed on the webpage.
Here is some sample code i found on the MS website:
[URL]
This part for the DayRender event is what i am refering to:
[code]....
The code above looks like it loops through the DataSet row by row and matches the e.Day.Date item. But i'm just not too sure about the loop going through all days in a given month displayed on the calendar?
I am new to asp.net. I am suppose to continue a project. The previous person has created a line chart and I have to create a bar chart. However I do not know how to create a bar chart. Could u email me for the code as I realise that I can't upload the files.
View 5 RepliesI have 2 MS Charts(OriginalChart, encryptedChart) which are working well. I spent hrs trying to set these charts so that they display the same AxisY value. Example, OriginalChart displaying max AxisY value 50 (this value may change depends on the data), I need the encryptedChart to display max AxisY value 50 (regardless of its data) as well, This would allow user to compare the differences in these chart more easily. Currently, my encryptedChart is showing 5 to 10 for the AxisY value. I tried most of the possibility to set below but no luck. Research on this also not much useful info (or I don't understand them.)
"encryptedChart.ChartAreas(0).AxisY.ScaleView.... = OriginalChart.ChartAreas(0).AxisY.ScaleView....."
Below's my HTML code fyi.
[Code]....
I am using Mschart in that I want to display null value or zero value in pie chart. How to display that.
View 2 RepliesWhen I try to generate a StackedBar char, some Y fields are not displaying because of space. Example with following chart
Ex :columns in DataSource : 2,4,6,8,10
Columns displayed on chart : 2,6,10
I have use chart controller in my web application but it display wrong percentages this are the value:
TOTAL COST : 75000000000.00
LOYALTY DISCOUNT : 7500000000.00
When it display on pie chart it display TOTAL COST :90.91% and LOYALTY DISCOUNT=9.09%
but it should be 90% and 10 % how can I correct it
chtSavingBrekDown.Series["Series1"].Points.AddXY("Total Cost", totalCost);
chtSavingBrekDown.Series["Series1"].Points.AddXY("Discounted Dolers", discountValue);
chtSavingBrekDown.Series["Series1"].ChartType = SeriesChartType.Pie;// Set the Pie width
//chtSavingBrekDown.Series["Series1"]["PointWidth"] = "0.5";// Show data points labels
chtSavingBrekDown.Series["Series1"].IsVisibleInLegend = true;
chtSavingBrekDown.Series["Series1"].LegendText = "#AXISLABEL";
chtSavingBrekDown.Series["Series1"].Label = "#PERCENT";
chtSavingBrekDown.Series["Series1"]["BarLabelStyle"] = "Center";// Show chart as 3D
chtSavingBrekDown.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;// Draw chart as 3D
chtSavingBrekDown.Series["Series1"]["DrawingStyle"] = "Cylinder";
chtSavingBrekDown.Series["Series1"].Points[1].Color = System.Drawing.Color.Yellow;
chtSavingBrekDown.Series["Series1"].Points[0].Color = System.Drawing.Color.Blue;
chtSavingBrekDown.Series["Series1"].Points[1]["Exploded"] = "true";
chtSavingBrekDown.Legends[0].Enabled = true;
chtSavingBrekDown.Titles[0].Text = "SAVING ESTIMATE BREAKDOWN";
I am using asp:chart control in my 3.5 application. My dataset have three columns i.e. Subject, Score, testDate. I am drawing the chart like this,
[Code]....
And my chart is displaying like this. And what I want is, the third column testDate should be displayed on the top of the series as follows.
I have a chart to display the percentage of available time for a machine, but it won't display all the labels. It will only display a select few, spread out evenly apart but I need it to show ALL of them. Here is how it's set up, however, I don't know what I would change in order for it to display all labels:
[Code]....
I am working on charts with ms chart 3.5 control my question is I have to display legends of pie charts in tabular form. Which will contain the color used for different points and x values and y values. I managed to show the colors and x values but not able to show the y values. I am giving the code also. Example of x and y values are:
xvalues- InCorrect YValue- 5
xvalues- Correct YValue- 10
xvalues- UnAttempted YValue- 15
Here is the code used to bind legend values.----
LegendCellColumn firstColumn = new LegendCellColumn();
firstColumn.ColumnType = LegendCellColumnType.SeriesSymbol;
firstColumn.HeaderText = "Color";
firstColumn.HeaderBackColor = Color.WhiteSmoke;
Chart1.Legends["Default"].CellColumns.Add(firstColumn);
// Add second cell column
LegendCellColumn secondColumn = new LegendCellColumn();
secondColumn.ColumnType = LegendCellColumnType.Text;
secondColumn.HeaderText = "Name";
secondColumn.Text = "#LEGENDTEXT";
secondColumn.HeaderBackColor = Color.White;
secondColumn.Alignment = System.Drawing.ContentAlignment.MiddleLeft;
Chart1.Legends["Default"].CellColumns.Add(secondColumn);
// Add header separator of type line
Chart1.Legends["Default"].HeaderSeparator = LegendSeparatorStyle.Line;
Chart1.Legends["Default"].HeaderSeparatorColor = Color.FromArgb(64, 64, 64, 64);
// Add item column separator of type line
Chart1.Legends["Default"].ItemColumnSeparator = LegendSeparatorStyle.Line;
Chart1.Legends["Default"].ItemColumnSeparatorColor = Color.FromArgb(64, 64, 64, 64);
// Set Min cell column attributes
LegendCellColumn minColumn = new LegendCellColumn();
minColumn.Alignment = System.Drawing.ContentAlignment.MiddleLeft;
minColumn.Text ="#TOTAL{N1}";
I want to show the individual value of each data point is there any idea how to show the Yvalue of each datapoints
minColumn.HeaderText = "Questions";
minColumn.Name = "Questions";
minColumn.HeaderBackColor = Color.WhiteSmoke;
Chart1.Legends["Default"].CellColumns.Add(minColumn);
how to display barchart in gridview of one column depending on that cell value
View 1 RepliesI have an issue in using dot net chart control. In chart last column is not completely shown which give bad appearance and on right side of chart it looks like TickMark are enabled. I set MajorTickMark of AxisY2 disabled but still tick marks on right side.
View 2 Replieshow to freeze the x axis of the chart control in ms chart? need to use because data displayed at large amount that is scrollable.
View 1 RepliesI have a drop downlist,and next to it there is an MS bar chart.i want to change the datate of the MS chart ,once the user selects another year from the dropdownlist.
When the page loads ,the chart displays the default year(2011) and it works.The problem is that is does not change the data when you select another year from the dropdownlist.
Am I going mad/blind? Probably a combination of the two.
How does one go about removing the data labels from a pie chart with the new chart control in .net 4?
I can get these to display as tooltips absolutely fine, but ultiamtely I'd like the labels not to be present as it looks rather busy.
I've searched previous answers and seen code behind resolutions but surely there must be some sort of code infront option to turn these labels off?
I am using MS Chart control (3.5), and have a requirement where I need to display 2 pie charts. The datapoints for the pie charts is set programatically. My doubts are as follows:
1. Can I display both the pie charts in a single chart control and area, or do I have to use two controls? (Currently I am using two controls)
2. How can I maintain the same size for both the pie charts? This is my main concern, since the pie sizes keep changing, depending on the number of datapoints. I tried using custom properties like "MinimumRelativePieSize", but it's not working.
i'm trying to create a stacked bar chart on a vb web form using vs2010.My data source returns:
Error in Functionality Awaiting on Supplier
1IMT IssuesmActive6
IMT Issues,Awaiting on Supplier
2,IMT Issues,Awaiting on User 4
IMT Issues Closed 120
Login / Password Active
But I can't get this into a stacked chart. I know I must have to do quite a bit of work declaring what the series are and soforth, or having a different dataset but can't find any documentation on it.A link to some documentation or an example of a stacked chart from an sql datasource would be much appreciated.
I started using the awesome chart controls with my asp.net apps recently and so far they've been nothing short of breath taking. Right now I have a weird problem, on the first load of my page, the chart control appears correctly and the tooltip is correct, however, when I update it with new data, the chart displays correctly, but the tooltips are for the previous set of data.
I hope this makes sense. The first time I load the chart, the pie chart segments and tooltips are correct, after a partial postback (to get the new data), the pie chart segments are correct but the tooltips are for the previous data set.
Basically once the tooltips are set the first time, they can't be updated after that without a full page postback.
Here's how I set the tooltip:
[Code]....
Anyone else noticed this behaviour and have a work around?
Currently my only workaround is to check for a partial postback and not render the tooltip, which I'd rather not do as the tooltip display actual statistical data as opposed to the pie itself (which uses percentages).