Forms Data Controls :: Create A Report Chart Via Sql Command?
Feb 9, 2011i would like to create a report chart via sql command by using asp.net vb.net.
my sql coding:
[Code]....
i would like to create a report chart via sql command by using asp.net vb.net.
my sql coding:
[Code]....
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.
im using the ms chart feature in vs. I was just wondering if there was a way to create one for each row in my datagrid. My datagrid has columns like student name and student test result. The number of datagrid rows can change. Not necessarily from the same page the charts will be on, so i need the chart generation to be kinda dynamic,
View 1 RepliesI want to create dynamic pie chart in asp.net
View 3 RepliesI have to create a line chart from a sql query. It is as follows:
[Code]....
However,I need to take PlayerName into account too.For example,if there are 2 different PlayerNames,2 different series will be shown on the line chart.
I am using Repeater control. In DataBound event I am preparing output of item and everything works ok. But now I need to add a command button to item. I cannot add button to item template in designer (some project specifications do not allow it). I create new button at DataBound, set unique ID, command name and argument and bind it to command event and, thenm place it to Item controls container. It is not working as command button.
View 7 Repliesim using Vs2010 to plot real time line chart. i have been looking for the section that allow me to set X and Y axis..
i jus couldn't find the place for me to set.
my Y axis is a double, min =0, max = 100 and my X axis, min =0, max = 300(seconds).
how we can make Multi- series 3D column chart using ASP charts
View 4 RepliesHas anyone had any success creating GANTT charts using MS chart controls?
View 1 Repliesi'm trying to issue a select command in my app soi could execute the command and retrive the data into a string variable.the problem is that this command is overloaded with DataSourceSelectArgument and i can't figure out what it is.i'm using sql server express and when issue a n insert command for example sq.Insert(); i have no problems.this the command that's holding me:
SqlDataSource sq = new SqlDataSource();
sq.ConnectionString = ConfigurationManager.ConnectionStrings["CustomerDatabaseConnectionString1"].ToString();
sq.SelectCommandType = SqlDataSourceCommandType.Text;
sq.SelectCommand = "SELECT * FROM CustomerTable where customerID = 1";
string result = sq.Select(some overload that's stopping me);
I 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).
i need to retrieve values from the database and provide it as a report to the user.
View 4 RepliesI want to create Graphical Report to display Order Summary,etc. how to create Graphical Report???
View 4 RepliesI,am trying to create a self association relation for an organization chart data tree in Entity Framework,after trying different ways for prevention of exceptions like 3007 and etc. I found that when I put my foreign key in my POCO near Parent and Items navigation properties its work.but I think this is not correct that we have both ParentID scalar property and Parent navigation property. review this and tell me is it correct or not.I'm using VS 2010 RC and ofcource .net framework 4.0 RC
[Code]....
I want to generate the yearly report.
how i get my input in dropdown list as march2015 to febuary 2016.
i want to extract and generate the datas from database and sorting by using month and the year of the date? How?
I am creating a web site through command line. I am able to create a web site with single host address. But i want multiple host address for a website. this is the command I am using iisweb /create D:Test Test.com /d [URL]
View 6 Replieshow would i do my Gridview delete command like a update command?
im using a datasource... and my delete command is like my update command... so i can change the status into "INACTIVE"...
DeleteCommand="UPDATE ACCOUNT_MAINTENANCE SET am_status = 'INACTIVE' WHERE (accmain_no = @accmain_no)"
UpdateCommand="UPDATE [ACCOUNT_MAINTENANCE] SET [account_type] = UPPER(@account_type), [min_deposit] = @min_deposit, [min_capital] = @min_capital WHERE [accmain_no] = @accmain_no"
when i press my delete command at gridview... the status changed into "INACTIVE" but when i refresh or press f5... it automatically update the status into "INACTIVE" also...
I need to generate a report by comparing two values in rdlc in c#.net
I am having a product with the price Rs 150 in 2010.
In 2011, the product price rises to Rs 200
In 2012, it decrease to Rs. 100
I need to show this in chart.
It should display as Waves.
Can I use one SQL command to call many sprocs ?
I would then use the returned data to create a dataset table like I did with one SPROC in this code :
[Code]....
[Code]....