Some Questions Related To Donut Charts In SSRS
May 3, 2007
I am interested in knowing the following things:
How to show total of all legend items in legend block itself as "Total".
How to show Total (say amount) in the center of donut chart.
How to customize the thickness of donut in donut chart and radius of inside and outside circle (the other thickness).
The lable markers (arrow) are not coming as a right angle arrows when i tried to use the donut and pie charts, the are coming as randomly angular lines which is hampering the beauty of the report.
Please reply as soon as possible. Thanks in advance.
View 1 Replies
ADVERTISEMENT
Jul 1, 2015
Is it possible to fill color within SSRS donut chart. For Example, based on overall status column RAG Status, it should fill the color.
View 2 Replies
View Related
Sep 8, 2006
Hi, I don't use SQL much but I need to know how to form the following query against a SQL table. I have a single table with two columns - CurrentPage and LastPage.
I need to write SQL to perform a number of iterations of a particular insert into another table, depending upon the count from CurrentPage to LastPage i've put the following Pseudocode together, but need help implementing this.
Declare counter
Set counter = currentpage
If counter > lastpage
Goto task exit loop
Else perform task - (insert string into table)
Increment counter and loop
I've been playing / reading up, but i'm getting nowhere fast -
DECLARE @Count int
DECLARE @Current string
DECLARE @Last string
SET @Current= dbSL.tblPaging_colCurrentPage
SET @Count= dbSL.tblPaging._colPagingCount
SET @Last= dbSL.tblPaging._colLastPage
WHILE @Count <= dbSL.tblPaging._colLastPage
BEGIN
PRINT 'Hello World'
SET @Count = @Count +1
END
Any help much appreciatted.
Thanks
nme
View 1 Replies
View Related
Oct 21, 2006
I have a couple questions about replication (for both 2000 and 2005 servers):
1. which system tables/dmvs/system sprocs can I look at to determine which columns of a table are being replicated?
2. which system tables/dmvs/sprocs can I call to get metadata about publishers and subscribers?
Thanks!
View 2 Replies
View Related
Dec 5, 2006
Good morning,
i have four tables
Student(iid , lname, address)
Teacher(tid, lname, salary, d_number)
Lesson_teach(tid,les_name)
Lesson_attend(iid,les_name)
Well, I'm trying to find the teachers who teach one lesson and more (e.g. only if sm teaches >= 2 lessons )
I do:
select teacher.lname
from teacher,lesson_teach
where teacher.tid = lesson_teach.tid
group by lesson_teach.tid
having count(*) >= 2)
Thanks,in advance!
View 19 Replies
View Related
Nov 7, 2006
0) We are migrating data from SQL Server 2000 OLTP design to SQL Server 2005 OLAP design.
1) We have an data flow task SSIS package.
2) We managed to send a mail with various variables & their values in subject or body of mail.
3) How do we send mail with details of Error/Warning using OnError/OnWarning events?
4) Can we have bad tables i.e where records which failed to migrate get inserted into. If yes, what are the steps to implement this.
5) Can we have a mix of in-built & custom logging. Is logging provider necessary to do logging. What logging provider to use?
6) Where are the errors that come during build, deploy, install and execute stored? Is there a log file(s) & what it their location?
7) Please post links if that is better.
View 3 Replies
View Related
Jan 10, 2007
Hi everyone,
I'm just a newbie with clustering.
We've got a 64-bit A-P cluster running with Sql25k 64-bit too.
Each node own two local network adapters. One of them (the one currently is Active) own three IP and the another one only one.
Why? From CLUADMIN I see as one of these three is set as Cluster IP Address in Active Resources. So I see the following configuration for the Active node:
Adapter 1: IP public for Active Directory
Adapter2: IP1 (reserved or ???????)
IP2 (used as SQL IP Address 1 in Active Resources)
IP3 (used as Cluster IP Address in Active Resources)
Passive node:
Adapter 1: IP public for Active Directory
Adapter2: IP (only have one ???)
Is this correct/necessary? Does anyone have similar configuration?
Thanks for your time,
View 2 Replies
View Related
Jan 4, 2008
Hi,
How can we use the line chart in the Sql Server Reporting Services 2005.
Please explain about the each and every properties in chart control.
Thanks In Advance
Shoba
View 1 Replies
View Related
Jul 2, 2007
Friends,
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
The look of the chart should be like following
|
|_________________
|_________________|
|
|________________________________
|________________________________|
|
|______________________
|______________________|
|_________________________________________________
Please let me know if there is a way to customize this bar chart using SSRS Charts...Thanks in Advance
View 2 Replies
View Related
Aug 31, 2007
Hi,
Can you please solve my below problem.
I have a data in the report with one column having hyperlink. And below am showing Pie chart with respect to Whole data in the same report. But I want to view for particular value which has to reflect in Chart.
Very Very very Urgent...
Any help would be appreciated.
Thanks
Dinesh
View 2 Replies
View Related
Dec 31, 2007
Hello
I have a windows application that connects to a SQLExpress database hosted on a shared server. The client machines will run an interface software and interact with the info within SQL The SQL database isn't huge (50 megs) and all of the info is text. The interface application isn't too complex either, it was designed using VB.net05. I have a few setup questions:
1 - Is it best to use Windows or SQL authentiaction? Currently I am using Windows authentication and I have a user group setup on the DNS that is setup as a user for the SQL database. That has worked so far, but I've only had a few users logged in at one time so far. My plan was to add all DNS accounts that will use the software to the DNS user group, thus giving them access to the SQL database.
2 - I know this gets asked a TON, but I am interested in knowing how many users I should be able to support using the current setup. I have the one user acount setup for the DNS user group. The SQL table is not huge and it is all reading and writing text. The server is running Windows Server 03 and is a couple years old (not sure of exact specs).
Thanks for any help, I am still learning my way around SQL and it's great to have such a vast amount of support for the product.
Happy New Year!
Paul
View 1 Replies
View Related
Jul 20, 2007
In a press release ( http://www.microsoft.com/presspass/features/2007/jun07/06-04sqlserver.mspx) It statedthat "...Microsoft licensed our Dundas Chart for .NET technology for inclusion in SQL Server Reporting Services 2000 and 2005 (SSRS)..."
Does that mean that I can download Dundas Charts for free ? - and where is the link ?
If not then what does it mean ?
View 1 Replies
View Related
Feb 17, 2008
Hi,
Is it possible to add an Excel chart to SSRS 2005 somehow?
thanks
View 3 Replies
View Related
Aug 2, 2015
In SSRS reports i have multiple charts and tables. per page i have to display one chart and one table. How to put page break after the chart and table. I have not used rectangle. I created all the charts and tables in the body area.
View 5 Replies
View Related
Jun 2, 2015
I have a requirement to display each student Fitness test results in the form of a Box plot chart with High Whisker , Low whisker , Low box,high box , Mean and Median in a stored procedure since test areas are dynamic. But , i have never done this before.
Test Type
TestSeq
Test Date
Student ID
TestArea
Test Result
[code]...
View 2 Replies
View Related
Nov 16, 2007
Hi,
We have our SSRS on Win Server 2003 which uses Windows Authentication. But, when we try to deploy the report solution from a .NET project (Business Intelligent Project) from a client System (WinXP), sometimes it deploys but sometimes it gives error specifying guest user (IUSR_***) is not having privileges to perform the operation. However, the client machine is not part of Active Directory login. We tried giving all privileges to guest user from Report Manager but in vain.
Actually, we want to know whether we can specify the windows credentials somewhere while deploying the report solution. Please suggest.
Thanks & Regards,
Rahul
View 1 Replies
View Related
Mar 20, 2008
Hi thanks for looking at my question
Using sqlServer management studio 2005
My Tables are something like this:
--Table 1 "Employee"
CREATE TABLE [MyCompany].[Employee](
[EmployeeGID] [int] IDENTITY(1,1) NOT NULL,
[BranchFID] [int] NOT NULL,
[FirstName] [varchar](50) NOT NULL,
[MiddleName] [varchar](50) NOT NULL,
[LastName] [varchar](50) NOT NULL,
CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED
(
[EmployeeGID]
)
GO
ALTER TABLE [MyCompany].[Employee]
WITH CHECK ADD CONSTRAINT [FK_Employee_BranchFID]
FOREIGN KEY([BranchFID])
REFERENCES [myCompany].[Branch] ([BranchGID])
GO
ALTER TABLE [MyCompany].[Employee] CHECK CONSTRAINT [FK_Employee_BranchFID]
-- Table 2 "Branch"
CREATE TABLE [Mycompany].[Branch](
[BranchGID] [int] IDENTITY(1,1) NOT NULL,
[BranchName] [varchar](50) NOT NULL,
[City] [varchar](50) NOT NULL,
[ManagerFID] [int] NOT NULL,
CONSTRAINT [PK_Branch] PRIMARY KEY CLUSTERED
(
[BranchGID]
)
GO
ALTER TABLE [MyCompany].[Branch]
WITH CHECK ADD CONSTRAINT [FK_Branch_ManagerFID]
FOREIGN KEY([ManagerFID])
REFERENCES [MyCompany].[Employee] ([EmployeeGID])
GO
ALTER TABLE [MyCompany].[Branch]
CHECK CONSTRAINT [FK_Branch_ManagerFID]
--Foreign IDs = FID
--generated IDs = GID
Then I try a simple single row DELETE
DELETE FROM MyCompany.Employee
WHERE EmployeeGID= 39
Well this might look like a very basic error:
I get this Error after trying to delete something from Table €œEmployee€?
The DELETE statement conflicted with the
REFERENCE constraint "FK_Branch_ManagerFID".
The conflict occurred in database "MyDatabase",
table "myCompany.Branch", column 'ManagerFID'.
Yes what I€™ve been doing is to deactivate the foreign key constraint, in both tables when performing these kinds of operations, same thing if I try to delete a €œBranch€? entry, basically each entry in €œbranch€? and €œEmployee€? is child of each other which makes things more complicated.
My question is, is there a simple way to overcome this obstacle without having to deactivate the foreign key constraints every time or a good way to prevent this from happening in the first place? Is this when I have to use €œON DELETE CASCADE€? or something?
Thanks
View 8 Replies
View Related
Sep 5, 2007
Hi all ,
i need to have outside label position for my data in 3d pie chart. How can i implement outside labelling?
Thanks
View 1 Replies
View Related
May 4, 2007
I have created a bar graph but cannot find a way to change the bar's color for different series.
I have a graph which has sales men and their sales between dates
Thanks for your help
View 5 Replies
View Related
Jan 10, 2007
Hi, I have a quick question about charts in SQL reporting services...
Is it possible to have a page through chart, meaning that an user can page through multiple pages of the same chart?
View 1 Replies
View Related
Mar 1, 2007
hi,
I would like to have a bar chart with the values of each bar on the top of the bar. How can I do this.
thanks,
naveen
View 1 Replies
View Related
Nov 14, 2007
Hi All,
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?
Thanks!
Matt
View 2 Replies
View Related
Jun 21, 2008
Hi
I have developed some line charts in reporting services with some parametrs
On the bottom axis is the month and the upper is no. hours.
The problem is that when i select certain parametrs becaus there is no data for that month the line just ends and then starts at a new month.
Does anyone know anyway of telling it to go to zero if there is no data for it so there is a continous line
Thanks
View 2 Replies
View Related
Mar 18, 2008
Can you loop through the records of one dataset and create a chart for each record?
View 2 Replies
View Related
Aug 2, 2007
Does anyone here use 3rd party graphs and charts for SSRS 2005?
What do you use? Is there a superior package out there?
Thanks
-JW
View 1 Replies
View Related
Feb 28, 2007
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...
View 1 Replies
View Related
Aug 24, 2007
Hi,
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!)
Cheers,
Kevin.l
View 18 Replies
View Related
Aug 14, 2007
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..
Any help will be appreciated..
Regards
Karen
View 7 Replies
View Related
Jan 18, 2007
Hi all,
I have done 2 charts.while clicking one chart it is navigating to another chart. it is working in Report Server.
But using this graph in the UI page(putting Iframe and calling reports) it is not navigating to another chart.
Can u guys help me to solve the problem
Thanks in advance.
View 1 Replies
View Related
Feb 7, 2008
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.
Thanks.
View 1 Replies
View Related
Jul 3, 2007
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):
Code Snippet= Iif(MAX(Fields!actual_de.Value + Fields!actual_work.Value) >0, RunningValue(Fields!actual_de.Value + Fields!actual_work.Value, Sum, FakeSeries), Nothing)
(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!
Thanks much!
Jen
View 1 Replies
View Related
Apr 25, 2007
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
View 1 Replies
View Related
Jul 9, 2007
Hi,
Is it possible to fix the max width of the columns ?? Sometime the report only generates 1 or 2 columns and it looks a bit odd as they're stretched to the width of the page.
Also, when we have a large number of culumns, say 20 odd, the legend text get's real squashed up and un readable, are there any tips/tricks so i can have more flexibility over what's displayed ?
thanks
Steve
View 2 Replies
View Related
