Organisation Chart

Mar 8, 2006

Hi folks,
I have a Employee Master table named "Employee_Master". This has got the fields like as follows,

Employee_ID
Employee_Name
Reporting_To


Now I need a query that can help me to build up the organisation chart. I have a query that gives me some data......... Its like

select emp.employee_id,emp.employee_name,
mgr.employee_name as reporting_manager
from employee_master emp ,employee_master mgr
where emp.reporting_to=mgr.employee_id

But the problem with this query is, it gives only 1:1 mapping. And my requirement is to build a tree structure.........

So please help me oput in this regard........


Please lemme know if the problem is not understood to ya guys.......


Waiting for the earliest reply..........


Thanks,
Rahul Jha

View 1 Replies


ADVERTISEMENT

Organisation Question

Jun 23, 2005

I'm pretty new to all things database and SQL.

I'm currently using SQL Server Express Edition.

I want to know what the best way to organise my databases for my "web application".

I currently have all my tables in one database which makes things
easier to manage. However, if I want to make changes to certain tables
or add tables etc it means taking the whole web application offline.

Perhaps it would be easier to logically group the tables into separate
databases; i.e. all things travel related go into a travel database,
all affiliate tables go into an affiliate database and so on.

Is this best way to organise my tables?

View 1 Replies View Related

SSIS - Change Data Organisation

Oct 1, 2007

Hi,

here is my problem
i've a table in my database like this

Col1 | Col 2
____|______
aaa | 111
aaa | 222
aaa | 333
bbb | 222
bbb | 333


to insert data into a flat text file or another table
i would like to make a dataset like that :

Col1| Col2| Col3 | Col4
____|____|_____|_____
aaa | 111 | 222 | 333
bbb | 222 | 333 | NULL

the table is quite big, so i can't make it line by line

i would like to have a maximum of 12 column ( if there is more data than 12, these data should be ignored )

thanks for answering

View 3 Replies View Related

Solution/projects/package Organisation

Sep 22, 2006

I would like to create a set of packages which could be used as a basic package for other people. This package /project/solution should be used in a way that another a person could manipulate it in BIDS nad save it as a stand-alone package.

I already created some child packages and one package which should act as a "template" for developing a new package. The devloper should integrate existing child packages very easily.



All developers will share the same network directoy where all the solutions/projects/packages will be stored (which is not a problem to realize it) But how can it be organized that you can have a basic package which can be used as a general "template"?

Does anybody have a good idea, how this could be organized?



Norbert

View 1 Replies View Related

Reporting Services Report / Chart / Dynamically Hide-Unhide DataFields In A Chart

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

Reporting Services :: Export Server Report Chart To Excel As Editable Chart

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

Reporting Services :: SSRS 2008 R2 Bar Chart Labels Not Staying Outside Chart Area?

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

Reporting Services :: How To Show Bar And Line Chart In Same Chart

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

Refresh Chart Value On Behalf Of Clicking On The Chart

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

How Get The Lift Chart In Datamining.i Am Not Geeting Mining Accuracy Chart And Mining Model Prediction

Sep 14, 2007



Hi,
I am not getting Mining Accuracy Chart and Min ing Model Prediction
Plz tel me how to do.And how to use the filter input data used to generate the lift chart and
select predictable mining model columns to show in the lift chart

View 1 Replies View Related

Org Chart

Apr 2, 2008

Hi,

trying to build Orgchart with MS Access
columns: Name (text), Boss (data source, Name), Phone (int)

the question - how to avoid the "loop"?

1. prohibit choice for the current employee to choose himself as a leader
2. prohibit choice for the current employee to choose any subordinate level employee as a leader

VBA is not an option, we are planning to move this table to MS SQL server, so it should be a choice with "SELECT from Name...." with exceptions or any other checks with warning/error message...?

thank you
Anthony

View 5 Replies View Related

Need Help With Chart

Feb 18, 2008

Hi there,

I'd like to ask how to approach a chart layout when I have the following table:

|--------------------------------------------------------||[Client Name] | [March 2008] | [April 2008] | [May 2008]|
| Client 1 | 200 | 100 | 500 |
| Client 2 | 150 | 600 | 300 || Client 3 | 540 | 102 | 256 ||--------------------------------------------------------|

And I would like the table to be like the one below:

It seems to me that I have to do some sort of pivot with my dataset/query before I could use it for the chart. Any ideas would be highly appreciated. I really need help with this. Thanks in advanced!

Regards,
Ver

View 3 Replies View Related

Chart Top N

Jun 22, 2007

With 2k5 I am trying to make the "Top N" operator, used in a chart "category," return only N categories. But it almost always returns more than N categories. Can someone explain the nuances of the Top N operator, so I can get past this?

View 6 Replies View Related

Chart - Bar Colors

May 4, 2005

Hi All,

I like RS for SQL server.
However, I am surprised (and frustrated) how limited the chart capabilities are; perhaps we have been spoiled by Excel...

Anyway, is there any way to change the color of the chart bars programatically.
I can select different schemas (excel, pastel, grayscale, etc) but I need to go a little bit further, is that much to ask?

Oh, by the way, we can't mix chart styles, can't we?
Need to show a chart and a line in the same report...

I appreciate your help on this, hopefully any answers to my questions might also help with other RS users with the same needs,

Thanks,
L

View 7 Replies View Related

Chart Problems

Nov 8, 2005

Hey all, I'm in a bit of a problem. I have a set of data on an excel spread sheet and i want that data to make a chart on a user form. I figured out how to get a blank chart on the user form but don't know how to link any data. Anyone think they can help?

View 1 Replies View Related

Something Like A Pivot Chart

Jun 12, 2008

Hi,

Thanks a lot for answering my previous questions.
Here's one more thing that I need. I have my data in one table called as Team_Aggregate.
The fields there are TeamID, Date (1st of every month), Permanent Employeed, Contractor, Open Positions, Total Employees, Max Posns.

Now, when a user selects some months data that he wants to display I want it to appear something like this -

Columns as Month Names (Jan 08 Feb 08...June 08)
Rows as Team Name
and each cell = Team Total for that month and the corresponding team.
Can I do something like this in sql? I want to display the data on the web eventually where I am using Gridview with datasource and databind methods.


Thanks a lot

View 11 Replies View Related

SSRS Chart

Mar 19, 2007

Hi,

I have created an area graph.My requirement is the following:-

When the user moves his mouse over the graph on different points, the values corresponding to that points should be shown as a tool tip or as a textbox value.

Any idea to capture the values in the graph(Category,Series and Data values) and display them in a textbox or tool tip in a SSRS chart?



Thanks

Arobind.B

View 2 Replies View Related

Lift Chart

Feb 13, 2007

Is there a Lift chart viewer like the model viewers that can be embedded within your windows apps ? If not, then can this be easily created via Adomd.net api calls ? Has anyone done this easily in custom DM applications ?

Thanks in advance,

anil

View 3 Replies View Related

Bar Chart Scale

Sep 7, 2007



Can you have different scales on a bar chart. I want to chart sales and quantity. Oracle lets you label the top of the bar chart as money and the bottom as quantity.

I am dividing my sales by one million and quantity by one thousand to make them similar in size on the same chart. I am using the sum of the sales/1000000 as a point label. Is there any way to limit the number of decimal places displayed. Currently it is displaying something like 1.94889312043; 1.95M would be better.

Thank you.

View 2 Replies View Related

Lift Chart

Dec 25, 2007

how can i change the language of lift chart for description of vertical axis and horizontal axis and howcan i see the script of this chart for time series algorithm

View 1 Replies View Related

Regarding Chart Control

Mar 3, 2008



Hi All,

I have got a query regarding SSRS report chart control. Can i have a chart with both bars and lines within it?

I have a dataset which has two columns as my outputs.Can i have a chart showing bars for one column and line chart for the other column in the same chart?

I will appreciate if somebody can help me out.

Dinesh

View 3 Replies View Related

Chart Axis

Oct 17, 2007

I created a graph which retrieves value from database.And currently,my axis is in ranged 0-10.But i have a doubt that my value in will exceed my maximum y-axis value 10..My question is, could it be possible that i make my y-axis dynamic??Thanks!!

View 5 Replies View Related

Pie Chart Having Percentage

Aug 22, 2007



Hello,
I am working on generating a Pie Chart in Reporting Services. I want to display percentage (%) in the pie chart slices, rather than having the actual values, since it does not fit properly into charts. A percentage would be better as a report.

Hope the question is clear. I would be grateful to anyone who answers this question.

thanks a lot.

View 5 Replies View Related

Set Chart Properties

May 12, 2008

Hi,

I have a chart that is created in SSRS with the size property set to '15cm, 8.5cm', I want to set the height based on a parameter that is passed to the chart ( so that it fits onto a 1 page report it is fed through to), I have tried putting =Code.SetChartHeight() in the height property but it brings up an error saying it needs to be in a format like '8.5cm'. The SetChartHeight() function just returns the height parameter + 5.

Does anyone know how I can do this?

Many thanks in advance

View 4 Replies View Related

Problem In Chart

Jan 17, 2007

Hai all,

I am generating chart using the Sql Reporting services.I have done 2 charts. when i am clicking one chart it will navigate to another chart.It is happened in reports.

when i used in UI page(web Page). when click the chart it is not navigating to another chart.The same chart will appear when i click the chart.

Can u guys help me soon to solve this problem..

Thanks In advance.





View 1 Replies View Related

Line Chart

Apr 2, 2008



Hi,

I am using simple line chart in sql server reporting services 2005.

I am showing 4 lines in my chart.I want to change that line colors.

Please help me for this.

Thanks

Shekar

View 7 Replies View Related

Text Box On A Chart

Nov 20, 2007

how can i place a text box on top of a chart.

I placed text box in a chart but while loading the reoport in a asp page the text box comes down to the bottom of the chart.

If anybody knows it,then please help me out.

View 1 Replies View Related

When Can We Use Profit Chart?

May 3, 2006

Hi, all here,

I have a question about profit chat (with parameters population, fixed cost, individual cost, revenue), so in what kind of cases or scenarios should we use the profit chart?

Thanks a lot  in advance for any guidance.

View 5 Replies View Related

How To Create A Top 10 + Other Pie Chart

Apr 29, 2008

Hi All,

I'm trying to figure out, how to create a Top 10 + Others pie chart. Well, I think I wouldn't have the problem if I could write a SQL statement... but I my data source is from SharePoint list like:

<Query>
<SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction>
<Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
<Parameters>
<Parameter Name="listName">
<DefaultValue>{4FDB998D-31CF-4988-883D-1187ECD12574}</DefaultValue>
</Parameter>
</Parameters>
</Method>
<ElementPath IgnoreNamespaces="True">*</ElementPath>
</Query>

Could someone give me a hint how to do it?

Many thanks in advance.

Nearshore

View 5 Replies View Related

Adding Others To A Chart

Dec 27, 2006

I want to display on a Chart the top 5 doctors by claims and show all others as "Others" and what claims they represent Doctor1 = 50 Doctor2= 20 Doctor3= 11 Doctor4=10 Doctor5= 6 all other doctors = 3. How do I do this? BTW I am 50 years old and have been programming since 1982. I have been so blessed by those of you who offer help...I just want to say thank you for those many times that you have come to my aid.

View 4 Replies View Related

Specify Opacity For A Pie Chart

Jul 31, 2007

I have a pie chart that I want to be able to specify the colors and opacity for each value. I can go to values -> edit -> appearance -> series style to specify the color. But I can't figure out how to specify the opacity. It seems like it should be possible to specify opactiy since there is the "Semi-Transparent" color palette that is one of the default color palettes. Any help with how to specify the opacity would be appreciated.

View 2 Replies View Related

Chart Types

Apr 6, 2007

Hi,



I have seen on the internet that there are more chart types availlable then used by reporting services.



I have seen some pretty charts in exel 2007.



Are there possibilities to use such charts in RS.

I have also seen that you can purchase charts from special dev houses (like dundas).

So i think i must be able to create my own library with charts.

Any idea how i can do this ?



Vincent

View 1 Replies View Related

Add Chart To SQL Report

Nov 19, 2007



I am develping this report using Microsoft Visual Studio .Net 3.0. I added Chart to the report.

All I need is the simple 'x' axis and 'y' axis in the chart.

x need to be the Date
y need to be the ValueOFTheDate

date ValueOFTheDate
-------------------------------------------------------------------------------
1/1/2007 10
1/1/2007 11
1/2/2007 2
1/3/2007 1


Which one should be my Data fields?
Which one should be my Category Fields?
I don't think I need "Series Field". But the "ValueOFTheDate" was keeping showing as "Series Field".

The value of 'y' axis shows the value of "#of record for the date" which is wrong.

Thanks.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved