Developpe Axis On A Graph As On A Grid

Apr 4, 2007

Hi !
I have A question about the developpe of the axis on the graph.
I explain, when you use a matrix, you can developpe your group with a clic on (+) or (-)
, does it possible on a graph ?
For example, if I display on my axis few years, and if I want to developpe specially one, does it possible, the user clik on a (+) and my axis displays every month in my year...

I have another question, does it possible to have tooltip on a graph ?

Thank you for your answer...

View 1 Replies


ADVERTISEMENT

Question (X-axis): How Does Automatic X-axis Label Positioning Work?

Jul 19, 2007

All,

I have read through the following:

http://technet.microsoft.com/en-us/library/aa964128.aspx.

The relevant section of this document is :-

Question (X-axis): How does automatic x-axis label positioning work?
Answer: Currently, built-in Reporting Services charts only allow automatic positioning in order to avoid overlapping the x-axis labels. The label direction (horizontal/vertical) of the axis labels depends on the label string sizes and the available space. X-axis labels are either shown horizontally in one line, horizontally in multiple lines with line breaks, or vertically. Showing x-axis labels at an angle, or explicit manual control over individual x-axis label positions is currently not supported.

Note There are several third-party chart add-ins that enable more control over axis labels. These add-ins can be installed on top of Reporting Services 2005.

I have exactly the problem indicated above in that some sectors of my Pie Charts I am are trying to produce are small and are close together thus labels overlap in some cases. As it says above, only automatic placing of the labels is available, but there could be a solution through third party software.

Does anyone know of a 3rd party solution/add in or a workaround?

Thanks
Msuk

View 3 Replies View Related

Chart Problem: Multiple Values To Y-axis For The The Same X-axis Value

Jan 14, 2007

I have a simple-column chart and in the x-axis I put the date values and in the y-axis the sale price values.

The chart works perfectly in the case when there is only one sale price for the same date. But, when the price changes during the same day, then there is problem. In the following example

x y

1/1/2007 6.25

2/1/2007 7

2/1/2007 4

3/1/2007 8

the chart will have three columns and in the date 2/1/2007 will display the min or max of the two values. What I need is to represent all the values i.e. the chart must have four columns , as much as the rows of the dataset

Is it possible?

View 1 Replies View Related

Is Is Possible To Have More Than 1 Graph Type In One Graph?

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

Chart X-axis Y-axis

Jan 17, 2007

I'm trying to convert an old chart to Reporting Services.
We have used the same dataset for years, it is very very simple. But it seems to me that Reporting Services can't deal with this simple dataset.

My question is: How can I get create a line chart using this dataset.

The data set consists of 1 row with 96 columns (a day divided into 96 sets of 15 minutes). Each column records how many events occurs within the 15 minutes. Along the x axis I would like to display a vertical line every 4 hours. The y axis should be numbered 0 to the highest value in the results.


I could not make this dataset any more simple than it is. But Reporting Services just chokes on this.

Here is a sample of the dataset :
1 2 0 4 5 6 7 8 9 10... 96

View 1 Replies View Related

Help With A Graph

Jan 23, 2008

Im a beginner here and i have a graph, in the graph I need to show the actual number that the graph is showing can i do this. My graph has numbers that go down the side from 5,000 to 0 in 1000, increments. Say the number is 2234 i need to show thatnumber in that graph somewhere. Can i do that?

View 1 Replies View Related

2nd Y Axis

Jul 17, 2007

How do i add a 2nd Y axis? i can't believe MS would leave out such an obvious feature?

View 6 Replies View Related

Second Y Axis

Aug 6, 2007

Good day,

I would like to know if it is possible to add a second Y axis to a reporting services chart?

Please can someone advise on how this can be done

Thank you in advance

View 5 Replies View Related

Red Line On Cpu Graph

Mar 11, 2008

Hey guys. I feel like the prodigal son that has returned. It's been while!
In your experience, what is the most like kind of cause to the cpu graph sitting quite high most of the time along with a constant second graph line in red at around the 10% line.

I feel that my aim should be to get rid of the red line alltogether. I've got a few ideas, but I don't know for certain how to target that particular symptom.
Any suggestions?

View 7 Replies View Related

Getting Rid Of 'NaN' Values In The Graph

Apr 23, 2007

Hi folks,



I run into problems where some metrics have value associated with dim attributes Markets where some don't have... The graph shows NaN, in the reporting services. Is there a way to get of NaN. something like filter out.



--Imran

View 1 Replies View Related

Graph Hierarchy: What Is It Exactly?!!

Dec 21, 2007

Hi everybody,
I've been reading the book MCITP Self-Paced Training Kit (Exam 70-441): Designing Database Solutions by Using Microsoft SQL Server(TM) 2005 (Self-Paced Training Kits) as a part of my preparation for exam 70-441
The book is really clear, and I could understand everything easily because I've some experience as a database developer.
Until now, there's only one thing that I didn't fully understand:
On pages 53 and 54, it mentions a type of hierarchy called: a graph hierarchy, and it gives a small example made the things even more complicated
I've many books about database design theories, but they don't use the term (graph hierarchy) any where...
So, I appreciate if you can point me to an online resource or a book that discusses this term thorougly.

Thank you

View 3 Replies View Related

Set Series On Graph

Nov 19, 2007

Hi,
I have setup a chart with series on right hand side.
The series is from one of the fields.
How is it possible to remove series and instead place each series name on a graph line?
Or at the very least, how can I place a text on each graph line?
Thanks

View 1 Replies View Related

Drill Down From A Graph

Apr 4, 2007

Hello everybody,



I have a small challenge for you.



I'm developing an application using SQL Integration Services and SQL Reporting Services. I need to have the ability to drill down from a graph created with Reporting Services.

Let me explain: If I have a pie chart, I want to be able to click in one of the slides and see the information details that could be in another graph or in a table.



Somebody know how to do this?



Thanks for your help

View 3 Replies View Related

Labels On A Bar Graph

Mar 27, 2007

I have a simple bar graph. All I am looking to do is display the values on each bar. Can someone please help me. Thanks

View 1 Replies View Related

X Axis Intervals

May 4, 2008



Hi All,


I am working on a line chart. The variable on the X- axis is DateTime. The requirement is to have the values displayed with an interval of 4 hours (or mabe 5 or 6 hours - basically every regular intervals). I am using a list control to Subreports to show around 10 reports.

HOW can I do this? The Major and MInor intervals only help in separating which samples will be displayed. But we cannot configure for regular intervals.
Please help.

Thanks in advance,


Manoj Deshpande.

View 1 Replies View Related

Formatting Y Axis In Mm:ss

Mar 22, 2008

my data fields are in seconds so my y-axis shows seconds. But i want to format Y-Axis so that instead of showing seconds it should show mm : ss so this is what i have tried, in the "format code" i put this :

=(Fields!Seconds.Value)/3600

to check if it shows the division result but it doesnt, t shows the exact same result as it was before. Further testing of something like:

=(Fields!Seconds.Value) & "%"

does display the percentage sign with the values but division isnt right.

I am new to this, can anyone tell me how this can be done?

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

X-Axis Labeling

Jan 12, 2007

Hi,

In my report, I have StartDate and EndDate parameters.In my Line chart on x-axis i need to show the dates like this:Suppose startdate=1/1/2005 and enddate=12/31/2005 then x-axis labels like this:1/1/2005,4/1/2005,7/1/2005,10/1/2005,1/1/2006.In x-axis i put the Minimum value:Parameters.StartDate.Value and the Interval is 90( days),it is not working properly.

How to show quarter of the year on x-axis.

Please help me

Thanks in advance

View 9 Replies View Related

Creating A Chart/graph

May 23, 2007

Good evening,

View 8 Replies View Related

Representing A Graph In TSQL

Sep 9, 2004

Hi!

I need to represent a graph in TSQL.
The graph is directed. It is essentially a number of trees which all have various (non-root) nodes in common with each other.

Any ideas or pointers would be most welcome :)

Thanks,

Angelos

View 1 Replies View Related

Rolling Month Graph

Feb 12, 2007

Hi,

trying to develop a report that shows the sum total for each month during a specified date range.

I have parameters asking for the start date and end date of the date range, the report needs to show the months in between this date range.

One of the fields in the dataset is durationminutes which I need to sum for each month then divide by 60 to show hours. I then need to show the total of each month in a bar graph (with each month along the x axis).

If anyone can shed some light on how I am going to do this it would be greatly appreciated.

Thanks.

View 5 Replies View Related

I Need To Show Only Date In My Graph

Dec 20, 2007



I'm going to create a graph using SSRS. there is a date field. I want to show only the date , not with the time. How do I do this?

Also Can I use two different data sets in a single graph?

Thanks

View 3 Replies View Related

Drawing Two Lines On The Same Graph

Jan 7, 2008

i wanna create two line types on the same graph. I'm using the following queries.






Code Block
select count(l.created) as LoanOriginationNumberPreApproved , convert(char( 11), l.Created) as PreApprovedDate
from LoanApplication l
where l.Status <> 'Cancelled'
Group by l.Created






and





Code Block
select count(l.SubmittedOn) as LoanOriginationNumber , convert(char( 11), l.SubmittedOn) as SubmittedDate
from LoanApplication l
where l.Status <> 'Cancelled'
Group by l.SubmittedOn




I combined these queries. I add clumns of the second query to select statement of first code. also added group by l.submittedon to group by l,created as group by l.created, l.submiited on. This is the problem.(I mean grouping)

But then SSRS does not allow me to put preaaproveddate and submitteddate to drop category filed?
Does anyone know how to do that?

View 2 Replies View Related

Formula For Graph Size

Jul 8, 2007

I have a report control in my report. But I want to expand graph depending on the selected number of months (Parameter) by users.



But there is no formula option for graph control. Is there any workaround?

View 1 Replies View Related

Write On Graph Line

Jun 6, 2007

In SSRS 2005, I have created a graph with x and y axis.
On the graph there are several lines based on the sql query.
The question is, how is it possible to place the last value in (y axis) on the last point of the graph line.
Thanks

View 8 Replies View Related

Chart Graph Stretching

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

Graph Bar In Table Cell

Oct 22, 2007

Hi,

A few months back i saw a sample rds file where there was a kind of line graph in a table cell
that indicated how much percent a sales person had to the complete sale figure.

But i cannot find the link anymore.

I would like to have such a linge graph next to all my agents that indicates a value againts a total value.

Does anybody has any pointers where i could find that info ?

Greetings
Vinnie

View 5 Replies View Related

Is It Possible To Specify The Last Value As A Datallabel On A Line Graph

Aug 24, 2007



Hi
Is it possible to specify the last value as a data label on a line graph...

Regards
Karen

View 14 Replies View Related

Printing Graph Report

Feb 28, 2007

Hello

I have a report with pie and bar graphs, I have the paper size 16.54 x 11.69 for landsacpe, there are twelve graphs ,two placed side by side , and in the report manager, the appearence is perfect ,spread over six pages. I have Pagebreakatend True for all the graphs. The problem is with printing, on printing , the are tottaly misaligned,any tips are welcome



Thanks

Inder

View 4 Replies View Related

Creating Graph With Two Scales

Dec 6, 2007

Hello.

I have a dataset with two data types.

I want to show them on the same graph but with two different scales.

for example:
I have "work hours" by months whice there values can be between 12,000 - 10,000 and I have "money" by month which value can be between 0 - 1.

I want the "hours" to apper as a bar graph and the scale of values will be showen in the right side (from 10K to 12K) and on the same graph I want a line graph of money that his scale of values will be showen on the left side.

I'm trying to add a picture of it. I hope it will look OK. its a hand made picture so I apologaize in advanced


If the picture isn't visible you can see it here: http://www.friend.co.il/scale.jpg

Thanks.

View 5 Replies View Related

Action In Ssrs Graph

Jan 23, 2008




I have a graph and on the graph I have created an action to go to another chart. My first chart has two parameters. When I click the actions points to go to my second chart I have three parameters. Since my first one has 2 and second one have 3, I keep getting an error "invalid parameter" in the first graph. Can this be corrected. Can I use 2 parameters - pass them to the second then select the third parameter?

View 1 Replies View Related

Graph Export To HTML

Oct 10, 2007



I have created a report with subreport.My subreport contains a graph/chart control which retrieves data from the database.My problem now,is when i deploy my report in HTML,the graph wont show.But it works perfectly in PDF and Excel..I am currentlt using now the getimage.aspx codes.I am confused now,what fornat will be used in the code(getimage.aspx.cs)Would i be evaluating the subreport??use HMTL as format??or PNG as fornat(because as i have read,PNG will be the format of the chart)??

This is my current code :



{

/// <summary>

/// Summary description for getimage.

/// </summary>

public partial class getimage : System.Web.UI.Page

{

protected void Page_Load(object sender, System.EventArgs e)

{

try

{

string reportPath = Server.UrlDecode(Request.Params["report"].ToString());

string streamID = Request.Params["streamid"].ToString();

string format = "HTML4.0";

ReportingService2005 rs = new ReportingService2005();

rs = (ReportingService2005)Session["rs"];

string mimeTypeImage = "";

string encodingImage = "";

byte[] image;

ReportExecutionService rptExec = new ReportExecutionService();

string deviceInfo;

string streamRoot;

streamRoot = "getimage.aspx?report=" + reportPath + "&amp;streamid=" + streamID;

string extension = "";

Virtx.VF_ReportExecution.Warning[] warning = null;

string[] streamIDS = null;

switch (format)

{

case "HTML4.0":

case "HTML3.2":

{

deviceInfo = "<DeviceInfo>";

deviceInfo += "<StreamRoot>" + streamRoot + "</StreamRoot>";

deviceInfo += "<Toolbar>False</Toolbar>";

deviceInfo += "<Parameters>False</Parameters>";

deviceInfo += "<HTMLFragment>False</HTMLFragment>";

deviceInfo += "<StyleStream>False</StyleStream>";

deviceInfo += "<Section>0</Section>";

deviceInfo += "<Zoom></Zoom>";

deviceInfo += "</DeviceInfo>";

}

break;

default:

deviceInfo = "<DeviceInfo></DeviceInfo>";

break;

}

image = rptExec.Render("IMAGE", deviceInfo, out extension, out mimeTypeImage, out encodingImage, out warning, out streamIDS);

//image = rptExec.RenderStream(format, streamID, deviceInfo, out encodingImage, out mimeTypeImage);

Response.Clear();

Response.ContentType = mimeTypeImage;

Response.AppendHeader("content-length", image.Length.ToString());

Response.BinaryWrite(image);

Response.Flush();

Response.Close();

}

catch (System.Threading.ThreadAbortException) { }

catch (Exception ex)

{

Trace.Write(ex.Message);

Virtx.Tracer.WriteTrace(1, "Exception caught while performing getimage(): " + ex.Message);

}

}

#region Web Form Designer generated code

override protected void OnInit(EventArgs e)

{

//

// CODEGEN: This call is required by the ASP.NET Web Form Designer.

//

InitializeComponent();

base.OnInit(e);

}

/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

}

#endregion

}

}

View 2 Replies View Related

How Change The Scale Of X Axis?

Mar 29, 2007

Hi, how do I change the scale of x axis to a larger time scale than the data ?

Data is in quarters and I want that to be displayed in a line graph, but I want the labels to show hours

(it becomes messy otherwise when showing several days)



Thank You,

Regards

Göran



View 4 Replies View Related







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