Hello,
I am attempting to create a line chart for a report.
Are there any detailed white pages that discuss this particular chart type in detail? So far most of the documentation I have seen fails to cover the extent of the properties available in a chart and the terminology is unfamiliar to me.
What I need to know is how to integrate the chart into an existing table and within a group, plus be able to change the y-band scale to match the particular data being returned by that grouping.
Is this something better suited towards a subreport inserted into the detail band or inserting a rectangle then the chart itself forgoing the use of a subreport?
Any documentation would be appreciated, step by step approaches would be even more helpful.
I have this main chart setup. It pulls data from a query based on the selected parameters.
I want to create multiple charts for every catagory in the result set.
On the main chart there is a catagory called "Missing".
I want a chart for this category to display when the main chart is loaded. So below the main chart it would show a chart for each of the categories on the main chart.
Basically this report returns information on a certain part number displaying its problem types. Then I want it to create other charts for each problem type displaying the problem sub-types.
I was given a task of coming up with the script to recreate an existing database using a command line. I would use this script in case when the server is down and I can't get to Query Analyzer or EM to recreate it. I am not sure where to start. Any ideas are greatly appreciated.
Hello, I need to know what means are available to change the Minimum and Maximum Y-Axis scale values rather than leave them simply as they are in the properties. Right now whatever min/max values I enter into the scale for the Y-Axis are unchangeable. I need to be able to change the min/max scale values based on the value of the data at run time.
Hi, for some AP issue, the file I upload must be without the line feed/carriage return in the last line. for example:
original fixed-length file (exported from SSIS) line NO DATA 1 AA123456 50 60 2 BB123456 30 40 3 CC123456 80 90 4 <-- with line feed/carriage return in the last line
The file format that AP request. The file only has 3 records, so it should end in the third line. line NO DATA 1 AA123456 50 60 2 BB123456 30 40 3 CC123456 80 90
Should I use script component to do it ? I am new for VB . Anyone would help me ?
I need the Trend line for the following data in Line chart they are the following data. The following are the graph are my output and i need the trend line for these Key_gap value.
This is the link [URL] ....
I need the same trend line for the Bar-Chart in SSRS 2005.
I hope I'm posting this in the correct forum (forgive me if I'm not) since I'm not sure if this is an issue with inserting an item into a db or the processing of what I get out of it. I wrote a basic commenting system in which someone my post a comment about something written on the site. I wanted to keep it very simple, but I at least want the ability for a user to have newlines in their comment without having to hardcode a <br /> or something like that. Is there a way for me to detect a newline if someone, for example, is going to their next paragraph? Let me know if you need a better explanation. Thanks in advance!
G'day everyoneThat's a space between the ticks.It's all part of a longer script but seeing as the failure occurs online 1if exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[config]') and OBJECTPROPERTY(id, N'IsUserTable') =1)drop table [dbo].[config]GOThat's three lines only. Does it matter that they're in Unicode?Any ideas?Kind regards,Bruce M. AxtensSoftware EngineerStrapper Technologies
We have a line graph which plots the actual data points (x,y), everything is working fine with this graph. Now we need to add a trend line to this existing graph after going thro. the articles we came to know that there is no direct option in SSRS to draw a trend line. So we need to calculate the trend values ourselves which we need to plot as atrend line. This trend line is similar to the trend line which comes in Excel chart, do anyone know how to calculate the trend values from the actual data points. We got through several formulas, but were not clear, have anyone tried out exactly the same, if so please help us out by providing an example to calculate the trend values.
I have a line graph which shows positive and negative values. Is it possible to have the line one color when its negative and another when its positive?
I'm using DTS in Sql Server 2000 for the first time, and would like to create Ad-Hoc reports with Pie/Charts and graphs. Is this possible in SQL Server/DTS, or would I need something like Cyrstal Reports?
I've got a report with a table holding a subreport that contains a number of Dundas charts. Each of these charts displays A LOT of data.
Now... after deploying the report, only a few charts at the bottom of the report are displayed -- the rest display the Image-doesn't-exist icon (File image with red X across it). Can anyone tell me what's going on? My best guess is that this is a memory issue on the server side...
I have a requirement in Bar charts using SSRS...Assume that I have 3 Products Quantity and the representation will look like following
A - 10
B- 20
C-15
Though it is easy to develop this as a bar chart...The requirement is that a Product Perfomace should be represented using Images in the chart area...Instead of showing that A has 10 quantitites in a single bar, a general product image should be coming in the place of 10 and same with the case of B and C.. I have used smiley icons here for clarity
I am upgrading all my access reports to reporting services. One of my access reports, contains a chart which is set a a multiple chart (so I can see a chart of data for each day in the data set). Is it possible to do the same using the SQLserver 2005 chart component?....I cannot see an obvious button to press which makes a single chart a multiple one.
If this is not possible in vanilla reporting services, can anyone suggest a thrid party add-in that will rovide the functionality I want? (cheaply lol!)
I have a pie chart which is been populated from a sproc.
and for a particular fund the values that generate are 78%,20% and 2% respectively.
And when it generates a chart the pie chart is uniformly displayed... Like for eg.. its been broken into 3 parts and there isnt a difference between the 78% and the 2% so ... How can i get the pie chart to be a displayed according to its values..
Hi, I am creating some earned value reports that display project budget, actual cost to date, projected cost, and earned value. I have all of the data stored by month so I am using the Running Value function to display the data on a graph such that at any given point on the graph, it is showing total dollars as of that date. This works great for a single project or a summation of projects.
I also want the ability to create a batch set of reports for a series of projects, basically they input a list of project numbers, and a new graph is generated for each one. To do this, I created a "batch report" that has a subreport in a table's group with project id being the grouped on field, it passes that project id to the subreport as input.
I get exactly what I want - a new report for each project, but the problem is, running value on the graphs is not working across the projects. It's fine for the first project, but all subsequent projects are getting messed up. For instance, one project with a max budget of 200K is showing with a max budget of 400K, actuals are getting nulled out, etc. It's as if for some reason, the RunningValue isn't getting reset across the subreport....
An example of my value field on one of the lines (not copy and pasted so forgive any syntax errors - I'm not on my development box):
(The point of the max is so that the graph stops on months without actuals - that is months that haven't occured yet)
My FakeSeries is just on projectID and is just for the purpose of resetting the Running Value (or so I thought).
Does anyone have any input or advice on how to get this working? Why is RunningValue getting messed up across subreports? If I only give the batch report one project ID, the data is great. (I know it's the running value because if I take out running value and just graph the SUM - all the values are correct). If anyone has an alternate way of doing this sort of batch report I'm all ears as well!
I'm having problem with Charts any good website or books i can read up on just can't anything good on charts I need to use 2 pie chart and 1 bar chart but i can't get it to work like i wanted to
I'm not sure what Series and Category is used and how to stack the fields in the Charts