Graph(Chart) Showing Data
Apr 28, 2006
Hello
I am making the switch from using MSACCESS to do required reporting to using Reporting Services to accomplish the same tasks.
A requirment I have is that whenever a graph (chart) is created, it contain the underlying data in a connected and aligned data table. MSACCESS allows this by selecting the chart options and then "show data table".
Is this ability included in Reporting Services in MS Visual Studio 2003 .NET? If so, how can I enable it? I currently can only enable the legend.
Currently we are using:
SQL Server 2000 (sp3a)
Reporting Services (sp2)
Visual Studio .NET 2003
Thanks for any and all help.
Ben
View 5 Replies
ADVERTISEMENT
Jul 27, 2015
I have a scatter chart in SSRS (SQL Server 2012, Visual Studio 2010) that is producing the following:
There are five data points on there, however the result set I am using has 10 rows (a 'Completed Date' of datetime and a 'Lateness' integer whose values can be positive or negative.
This is the Dataset and the results it produces:
SELECT DISTINCT TOP 10
a.ACTIVITY_NAME As [Activity Name]
, ad.COMPLETED_DATE As [Completed Date]
, ad.DAYS_LATE As [Lateness]
FROM ACTIVITIES a
JOIN ACTIVITY_DATA ad ON ad.ACTIVITY_ID = a.ACTIVITY_ID
[code]....
How can I tell SSRS to show every data point in my chart?
View 7 Replies
View Related
May 23, 2007
Good evening,
View 8 Replies
View Related
Mar 8, 2007
Greetings,
I dont know where to post this. I am hoping someone else has run into this in the past.
I have a report with a chart component that works fine in i.e and safari. In fire fox the chart is stretched really bad. If I right click on the image or press reload from the report toolbar the chart is correct.
Whats really odd is this happens only when the toolbar is visible.
View 4 Replies
View Related
Sep 3, 2015
I have a table that contains some data.
LabelName
LabelValue
TotalForRetire
10337
dummy1
0
TotalForRelatives
5850
dummy2
0
TotalForDisability
7337
TotalForOrange
23
I have a pie chart and a bar chart.
In the pie chart I want to plot only TotalForRetire and TotalForDisability and TotalForOrange
In the bar chart I want to plot only TotalForRetire,dummy1,TotalForRelatives.
Also, here I want the horizontal axis not to show the label for dummy1 as the value is 0. How can i do that for each chart?
View 2 Replies
View Related
May 1, 2006
I am developing several charts with column type and sub type as stacked. There is a requirement from the users that they want an option to choose the type of chart.
Is it possible to change chart type dynamically from say Column type to Line type based on user option in front-end?
Any help will be appreciated.
Thanks in advance !!
View 5 Replies
View Related
Oct 25, 2015
I developed a rdlc report. I have a graph chart. Sometimes the value of a label can =0. If the value =0 I want to hide the labelname. However, I also have dummy values =0. This is so that I can have spaces between the bars. The dummy values labels isn't shown in the graph. This works great. I need to add to the expression that if the name of the label isn't dummy but the value =0 to hide the labelname.
The data from sql:
Expression in graph under chart data->category groups->category group properties->label:
=Microsoft.VisualBasic.Interaction.SWITCH(Fields!LabelName.Value = "aTotalForRetire", "Retirement", Fields!LabelName.Value = "cTotalForRelatives", "Relatives", Fields!LabelName.Value = "eTotalForDisability",
"Disability")
The result is below. I want to hide the label relatives as in this example the value=0. It will not always be the case. How can I do that?
View 2 Replies
View Related
Apr 29, 2008
Hi All,
I am using SQL Server 2008 Reporting Services Charts. I am using Chart Type as Column (3-D Cluster Cylinder). I am using X axis of graph as Time/Date field. I have two questions while displaying report in desired format:
1. Currently I have grouped Category field on Date field fetched from database. It groups values per day. Now whenever there is no data for a particular date, it skips that date in chart. How can I show each and every date on report graph in user given date range?
2. If there is no data for a legend of a chart, how can I display a Bar in Chart with value 0. This means, I have to show Bar with Zero value.
Currently if I Show data labels of Chart, it just shows data for 0 value but does not show Bar with 0 value which could be residing as flat on X axis for a particular legend.
Please help me resolving this issues for Chart graphs.
Please let me know if you need any more details.
Thanks in Advance.
Regards,
Ashwin B
View 1 Replies
View Related
Mar 13, 2012
I am trying to create a report using the below data:
Report_Date Base_Name
2010-12-15 00:00:00.000Main
2011-01-27 00:00:00.000Outer
2011-06-27 00:00:00.000Main
2011-06-28 00:00:00.000Main
2011-07-18 00:00:00.000Inner
2011-09-21 00:00:00.000Inner
2011-10-11 00:00:00.000Outer
2011-10-04 00:00:00.000Outer
2011-10-14 00:00:00.000Central
2012-01-18 00:00:00.000Inner
I want to create a line chart showing the bases, split by 6 month periods, on the X axis and a count on the Y. I have tried but am well and trult stuck!
View 4 Replies
View Related
May 24, 2007
Hello again
I have a graph which lists cell phone minutes broken down by month. I want the specific data for that month to show in either a matrix or table underneath the graph. The key is that I just want the date for that month only. When the user clicks on a specific month on the graph I just want to show that months data. I know how to accomplish this using the "jump to report" option with parameters,but how do I do this on the same report -- right underneath the graph??
thanks
km
View 3 Replies
View Related
Jan 7, 2008
I'm hoping to create a graph with durations as bar graphs and % met as a line graph. Is this possible in BIDS?
View 1 Replies
View Related
Sep 16, 2015
One of my report has different data types like decimal,percentage and integer values.
When I exported the report to excel , all the values are showing as "general" data type.
How to get excel data type same as ssrs report data type by default when exported to excel?
View 2 Replies
View Related
Nov 25, 2015
I created a report in Reporting Services which was working. Then I filled in the "No Rows" section in the properties of a tablix in the report. Now it shows the No Rows message even if there is data. If I open the Shared Dataset that is used in the report and open Query Designer and run the query I get data.
View 11 Replies
View Related
Mar 26, 2007
Hello All,
I have a reporting services report in the form of a chart. I have two datafields on the chart.
I need to be able to dynamically hide one datafield and view the chart for the other one and vice versa.
How do I do this ?
Any help would be appreciated..
Thanks!
View 4 Replies
View Related
Jul 17, 2014
When I export the report in excel format the chart is displayed as picture. I want it to be displayed as editable chart.Does Office Writer work in this situation and did anyone use Office Writer to accomplish same type of problem.Is there any other method or product we can use instead of the office writer.
View 2 Replies
View Related
Feb 13, 2012
I have a report designed in SSRS 2008 R2.My issue is that the data labels do not stay outside the bars for high values.
View 4 Replies
View Related
Mar 13, 2008
Here is my code. Basically what I am doing is selecting from the database based on the current user. The ReaderResults.Text label is not showing the info pulled from the database, and the ReaderError.Text label is not showing an error. I also tried putting the ReaderResults.Text label inside the loop and that didnt work. Any suggestions?
'Database ConnectionDim con As New SqlConnection("Data Source = .SQLExpress;integrated security=true;attachdbfilename=|DataDirectory|ASPNETDB.mdf;user instance=true")Dim currentUserID
currentUserID = Context.User.Identity.Name.ToString()
Label1.Text = currentUserID
Dim selectSQL As String
selectSQL = "SELECT companyKey FROM Company WHERE UserID = ('" + currentUserID + "')"Dim cmd2 As New SqlCommand(selectSQL, con)
Dim reader As SqlDataReaderDim CompanyKey
Try
con.Open()
reader = cmd2.ExecuteReader()Do While reader.Read()
CompanyKey = reader("CompanyKey").ToString()
Loop
reader.Close()Catch err As Exception
ReaderError.Text = "Error selecting record."
ReaderError.Text &= err.Message
ReaderResults.Text = CompanyKey
Finally
con.Close()
End Try
View 1 Replies
View Related
Mar 13, 2008
The ReaderResults.Text is not returning a value. I am not sure what is going on because the table and all columns are full, Label1.Text shows the current username of the user loggedon, and no error is showing up in ReaderError.Text. Anyone have any ideas?
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
'Database ConnectionDim con As New SqlConnection("Data Source = .SQLExpress;integrated security=true;attachdbfilename=|DataDirectory|ASPNETDB.mdf;user instance=true")
'Job1 InfoDim currentUserID
currentUserID = Context.User.Identity.Name.ToString()
Label1.Text = currentUserID
Dim selectSQL1 As String
selectSQL1 = "SELECT companyKey FROM Company WHERE UserID = ('" + currentUserID + "')"Dim cmd1 As New SqlCommand(selectSQL1, con)
Dim reader As SqlDataReaderDim CompanyKey
'Job1 Select
Try
con.Open()
reader = cmd1.ExecuteReader()Do While reader.Read()
CompanyKey = reader("CompanyKey").ToString()
Loop
reader.Close()Catch err As Exception
ReaderError.Text = "Error selecting record."
ReaderError.Text &= err.Message
ReaderResults.Text = CompanyKey
Finally
con.Close()
End Try
View 3 Replies
View Related
Apr 3, 2008
I have a Report Parameter Non-queried list for all months (Labels January, Februari... and Values 01,02...).
When I pick a month in my report all works fine
But I would also like to have data for the complete year (via an All selection)
How should I get this done . Any help appreciated
Edwin
View 4 Replies
View Related
Oct 21, 2015
I need to create a chart with the following features
1) Bar chart that has data for 3 years (3 series)
2) Line chart that has the same data as per the above points on the bar chart but this is a running total. (3 series)
3) These data points are for the 12 months
4) there should be a secondary axis for the cumulative one
Can I create this using the same data set?
View 6 Replies
View Related
Nov 23, 2007
hey folks,
i am looking for code to show the last entry of a database that has a unique field. for eg.. i have columns AREA, NAME, NUMBER. i need to show the last entry for each unique area.
so if there was 5 seperate areas, the table would show the last five entries for each area. anyone help?
View 6 Replies
View Related
Sep 3, 2014
I have a linked server that was built on PostgreSQL database connection. When I try to query one of the tables in the linked server it is giving attached error.
View 1 Replies
View Related
Jun 24, 2014
I have this script which outputs a combination of financial data. I have recently joined a table that includes a narrative and when I run the query, it runs perfectly. However, when I copy and paste the output into Excel, not all the data is showing. After the process of elimination, it is because Excel doesn't like the narrative column and not all data is copied across which is very annoying. If I remove the narrative column, then all the data copies over correctly.
I am using Excel 2010 which is quite up-to-date.
View 3 Replies
View Related
Sep 28, 2007
Hello all,
I have a simple query "Select distinct batch_id from batch WHERE batch_id = 123 or batch= 345
I run this query in MS query on the proper db and it gives me nothing.
I run the same query in the sql server console and the data is there.
As mentioned I am on the proper db since it works fine for some of my batch_id's for the 2 most recent one !!!??? They are in the db but I cant select them ....
Any idia ?
View 4 Replies
View Related
Mar 21, 2007
Everything is set up the way it should be, as far as we can tell.
However, when we drop in a SQL data source and try to configure, it, we
get a blank box for choosing the connection string, and it won't let us
make a new one.
Has anyone encountered this before? If so, how can we fix it?
View 1 Replies
View Related
Dec 2, 2014
I'm trying to only show yesterday's data based on a date that is stored as a varchar. I converted it to smalldatetime but I'm getting an error that says "Conversion failed when converting date and/or time from character string." I don't know how I have to alter the conversion.
Here is my code:
CONVERT(varchar(20), CONVERT(date, CONVERT(varchar(8), date_added), 112),110) = dateadd(day,datediff(day,1,GETDATE()),0)
View 10 Replies
View Related
Nov 11, 2015
I created a procedure called 'Longtextprocedure'. The length of this procedure is 650000 characters long. When I was giving the following query - select len(routine_definition) from INFORMATION_SCHEMA.routines where ROUTINE_NAME = 'Longextprocedure'; Length is showing as '4000' characters long. It is not showing the remaining part of the procedure, it is showing upto the 4000 characters of procedure code. But when you execute the procedure(exec 'Longtextprocedure') it is showing the exact result.
My question is i want to read all the 650000 characters long procedure code{select routine_definition from INFORMATION_SCHEMA.routines where ROUTINE_NAME = 'Longextprocedure'} to a variable which is varchar(max).
When i am trying to read the whole procedure code it is taking 4000 characters of data into the variable not the whole. Is there a way to read the huge procedure code into the variable?
Code:-
CREATE PROCEDURE FAKEPROCEDURE @procName VARCHAR(50) --@procName is 'Longtextprocedure'
AS
BEGIN
DECLARE @routineDefinition VARCHAR(MAX);
DECLARE @replaceToChar VARCHAR(MAX);
[Code] ....
When i am trying to execute the line EXEC(@dupliacteRouteDef), it is showing like there is no procedure defined. This is due to '@dupliacteRouteDef' variable is having 4000 characters of data not the whole data. Is there a way to read whole procedure data into the variable irrespective of the length of the string?
View 3 Replies
View Related
Feb 25, 2008
Assume I have a heirarchy like the following:
- John Smith
- James Jones
- Robert Allen
- Lisa Andrews
- Bob Thompson
Now, I have a report where whoever is logged in will only see data for themselves and those below them, so John Smith would see everyone including himself, but Lisa Andres would only see herself and Bob Thompson. James Jones would be able to see everyone except John Smith.
How do I go about implementing this code, for example in an asp.net page where one of the user's logs on to view the report. Currently, there is a T-SQL function that creates a user heirarchy table, but it is very slow and I am curious if SSRS 2005 has any new capabilities in handling this.
Thanks,
Saied
View 3 Replies
View Related
Dec 27, 2006
I have two instances in SQL on my machine. When creating a New Data Source in BIDS, I can only see the default instance. I have checked the SAC manager to make sure the second instance allows remote connections and the setting are exactly the same as the default. Any ideas? Thanks.
View 4 Replies
View Related
May 13, 2008
Hi All,
would like to make a report with sales figures per month even is there are no sales figures that month.
Report should still show the month.
Any help to get me started in the wright direction much appreciated
edwin
View 1 Replies
View Related
Aug 12, 2015
I have a database available and it is in live production.
I want to show only three tables in the front end. asp.net application in dropdown menu. I checked the internet and found only query for seeing all the tables from the DB.
View 3 Replies
View Related
Oct 10, 2007
Hello,
I am new to using the Web Services interface of the SSRS 2005, and would like to know if there is a way to export the resulting data of a report as XML.
Note that the Reports I have are composed of Charts, mainly Dundas Charts. I would like to export the data behind the Chart as an XML string for example so I can work with it independantly.
Has anyone done something similar?
Any guideline is appreciated...
Thanks,
Grace
View 1 Replies
View Related
Mar 27, 2008
Hi Guys..
i don't know weather is it possible or not..but Can any One tell's me How can i refresh the Chart Values.. acutally what's happening..
i have two Chart in a reprot .. One is Main Category and other one is SubCategory... acutally what i want.. in Main Category chart sum of Quantities of Subcategory values comes in bar or any other format.. and when i click on Main chart any bar it's refresh the other chart and return the result of subcategory under that main category in details...
i don't know is this possible .. acutally i m very new in reproting.. infact that's my first report.. so i want to do this.. if any article or any help anyone can provide me..
Thanks
View 1 Replies
View Related
