I need to drill down for the Chart in asp.net 3.5, i.e i have a bar chart(horizontal), i need to go to the detail part by clicking on the bar or i need to go to the detail part by having a button against each bar.
View 1 RepliesIs it possible to have a scroll in chart for asp.net 3.5
View 2 RepliesIs it possible to show the chart like the image in my attachement in Column Chart and in 100% Stacked Column Chart of SSRS 2008.
I like to show two series in same chart. Is it possible in SSRS 2008?
I provided the sample data to test it.
Select 'Fruits' as Category, 'Apple' as Item, 20 as Sales UNION
Select 'Fruits' as Category, 'Orange' as Item, 20 as Sales UNION
Select 'Snacks' as Category, 'Biscuits' as Item, 10 as Sales UNION
Select 'Snacks' as Category, 'Chips' as Item, 10 as Sales UNION
Select 'Snacks' as Category, 'Cakes' as Item, 40 as Sales
I am using 3d chart control and displaying a column chart. Is there a property I can set to get a small space between each column?
View 3 RepliesI am using Chart control to loop through and fill from GridView and it works fine.
Code:
myProductSeries.Points.AddXY(GridView1.HeaderRow.Cells(i).Text.ToString, GridView1.Rows(0).Cells(i).Text.ToString)
My question: How would I do that using a DataTable instead, is that possible. Does DataTable have a "Header" like GridView so do I fill the X value?
I have a simple chart control on my form. it displays data fine in X and Y axis. On X axis, i have time period (1 day,1 week, to 30 Years- total of 27 points on x axis) and Y axis has interest rate.
when the cursor is moved in the chart area, I want to show the exact value of Y axis. Just like yahoo finance shows when we click on a graph of a stock symbol. Say on my chart, when user hovers on say 2 Y on the graph, it should show the exact interest rate which is on the Y axis.
I am using .rdlc report. On click of the toggle button report gets refreshed. I want to avoid the post back and focus of report should not go at the top.
View 2 RepliesWhen i click on the toggle button of the rdlc report it jumps up i.e the cursor positon is not maintained could
The same issue is faced when i search for a word uisng the find control in the report viewer
I've a requirement to know if drill down is expanded then what would be value and if it is collapsed then what would be value in SSRS 2005 reporting. So on the basis of this; i can show and hide data column in the matrix control.
I tried to use inscope() function but always getting - True.
I need something if drill down ------> + = Inscope(Grid) value, - = Inscope(Grid) value.
i would like to hide the % of toggle item when image is + then it sum up the % which is incorrect.
Hence i would like to hide the % column when toggle image is + otherwise show the % column value.
i tried something - IIF(TextBox.ToggleState,false,true) or iif(toggle state = 'Collapsed', Parameter A, Parameter B)) in visibility column with expression but it does not seems to work in SSRS 2005.
I have a simple .aspx page.
I want to show the data either in Chart control or Gridview control. When the user selects an option to see the data either in chart control or grid view control, that specific control has to show up and other control has to become invisible.
So far, I am able to populate data successfully in the chart control. If the user chooses "Grid view" option, how can I show the data in grid view control in the same location. I don't want the gridview control to be shown in a pop up window or any other window.
Is it possible to programmatically disable/enable say column field drill through capability of the matrix table report depending on the textbox.text of dropdownlist value but retaining drill through capability of row fields ?
View 1 RepliesSELECT *
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME =
'Description'
vw_aspnet_Applications Description
aspnet_Roles Description
vw_aspnet_Roles Description
aspnet_Applications Description
The above query returns only those columns that are named "Description" from the default asp.net membership tables. That is not what I want. Each column has a property called "Description" which allows the developer to provide a detailed description for each SQL field (a.k.a. "column"). Example: aspnet_Membership has a column "Password" which does not have anything in the "Description" property although it should have imo
because without a description, it is not obvious that the password's value happens to be encrypted.
Scenario: Assume that I have a table called Trucks that has data like
Number Odometer ... et cetera
It's schema looks something like this (abbreviated)
COLUMN_NAME Description
Number yyyynnnn where 'yyyy' is year truck was purchased, 'nnnn' is sequential number.
Odometer most recent odometer reading in kilometres
How would I code a SQL SELECT statement in SSMS 2008 to display the schema data such as a column's name, its description text, et cetera? because "description" is such a generic term, I've so far been unsuccesful at locating further information in Google.
We are working on a drill up/drill down application. The drill functionality is provided by the dropdown list box. The data breaks down during drill down and roll ups during drill up (sum and averages)
We have used the gridview (which is not databound) for data presentation to generate a column during each drill level to indicate the current drill level.
At one particular drill level, a hyperlink has to be provided for an existing field on the data, to display its details.
Can hyperlink be provided in a gridview that is not databound?
Can a hyperlink control be created in a gridview during runtime (when the specific drill level is selected in the drop down list box)?
As a solution to this problem, we created a databound gridview, with the hyperlink for the required column and made it visible for that particular drill level.
I am using Excel 2007 to connect to a SQL Server 2008 Analysis Services database.
View 4 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).
I have X and Y data columns coming from database.
I have to show scatter plot chart with Linear, Exponential, Log, power using asp.net chart control.
How to do that?
Does anyone know how to explode a certain section of the piechart, which is part of microsoft chart controls?
View 5 RepliesI referred this link [URL] ...
In order to add pie chart into my website, but i want to remove black border and add % sign to the numbers showing graph and also want to set colours in pie chart based on my website theme.