Dundas Web Chart Control

Feb 21, 2007

I'm having trouble understanding how to build my bar chart. I have a column of info called Issue and then I'm coutning the record.

I bascially need to alter my query into time periods. I need a series for quarter 1 (1/1/2006 - 3/1/2006), one for quarter 2, 3, 4 and the entire year as a whole.

Can this data all be organized in a single select query?

Here is my current query getting the year as a whole data only:

SELECT Issue, COUNT(*) AS NumRecords FROM CSP_Item CI

INNER JOIN CSP_ProblemNotification CP ON CP.ID = CI.CSPNum

WHERE CP.PNDate BETWEEN '01/01/2007' AND '01/31/2007'

GROUP BY Issue ORDER BY NumRecords ASC

View 1 Replies

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

Repeat Chart Control On Every Page

Apr 16, 2008

Hi
I added a table and chart in the body of my report (.rdl)

If the report spans multiple pages , the chart is visible only on first page.
I need to see the chart on all pages.
Please suggest

View 4 Replies View Related

Can We Change The Chart Control Color?

Apr 19, 2008

Hi all,

Can we optionally change the above without choosing theme? Thanksin advance...

Regards,
Farouk Yew Abdullah

View 1 Replies View Related

Dundas Question

Jul 16, 2007

Are there more opportunities to use expression-based chart configuration with the Dundas charts? With the default charts, you are most limited to hard-coding your chart.

With Dundas, can you choose 3D or 2D based on an expression?

Can you choose chart styles based on expressions (e.g. cones verse bars)?

Can you choose chart types based on expressions?

Thanks,

Michael

View 2 Replies View Related

Dundas Charts In SSRS 2005

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

Release SQL Server 2008 - Dundas Tools

Apr 24, 2008

Hello,

I've installed the release of SQL Server 2008 but i couldnot find dundas control's.

I open SQL Server Business Intelligence but it still shows sql server 2005, why?....I know that 2008 have dundas control included, but i do not know how.
If you can tell me how to refeer them I''ll be pleasure.

Regards,
Karla Ramos

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

Issue With SSRS Report Exporting To Excel With The Matrix Control Inside The Table Control

Jan 27, 2008

Hi All,
I am placing a Matrix inside the table control for grouping requirements,but when we export the report to the Excel, the contents inside the table cell are ignored. Is there any way to get the full report exported, as per the Requirement.Please help me with this issue.

With Thanks
M.Mahendra

View 5 Replies View Related

Is It Possible To Embbed And Ocx Control On A Report Or Some Sort Of Interactive Control Like A Flash.ocx?

Oct 25, 2007

does any one have and example of how to embedd a flash swf file onto a report.??? Is it possable? any examples would be helpful.

View 1 Replies View Related

Reporting Services From WebBrowser Control - Print = Unable To Load Client Print Control

Mar 20, 2007

UPDATE #2: When it said "Do you want to install Microsoft SQL Server" I said "yes" and that caused it to work. I exited and re-ran and now the print runs w/o the "install SQL Server" (If the prompt had said "Do you want to install the print dialog" we wouldn't be having this discussion...)

UPDATE: After posting this i discovered that the same thing occurs when attempting to print the report direct from IE6: First a dialog pops up "Do you want to install this software?" Name: Microsoft SQL Server. When I click "Don't Install" I get the dialog "unable to load client print control." Since this happens direct from IE6 I suspect it's browser settings. I'll resume tomorrow and post a followup.

My WinForm C# app integrates Reporting Services by calling them from WebBrowser controls. The problem is attempts to print cause a dialog: "unable to load client print control."

I've read prior posts that say "enable Active-X in your browser" - I don't know how to do that from a WebBrowser control.

Any ideas how to support Reporting Services "Print" from within a WebBrowser control?

RELATED THREADS

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=332145&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=264478&SiteID=1

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

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 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

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