Hi
I am showing graph in my report as Column Chart .When my graph have more values it shows all values as crowded and look messy.
Is there is any way to restrict values on X axis up to limited number.
so that graph will be seen clearly.
Regards
Pankaj
I have a SQL Agent job that runs at 4:15 in the morning. The job has 5 steps, each step only runs if the preceding step succeeds. The second step, which calls an SSIS package that does the main processing, appears to finish as it goes on to the next step; however, when looking in 'View History' there are 2 entries for this step - the first one shows it as still running (Circled Green Arrow) but with a start and end time. The second entry says the job succeeded.
I have been seeing conflicts, such as deadlocks, with later jobs. I suspect this job is causing the conflicts - maybe the package is still running in the background instead of having actually completed?
what conditions a job step my be showing in the job history as both running AND completed successfully?
Hello,
I have a messy (and slow) piece of SQL that I'm sure can be written much more efficiently.
I have a table called parts:
Part(id, stopcode, s_num, a_num, tagnum, description)
The nature of the table is such that it is possible for two entries to share a tag number; when this is the case, it represents an 'in' part and an 'out' part. I would like to run a query which returns the in and out details in one row for parts. The id field is simply an autonumber and is unique for each entry.
Currently, I am pairing parts on their tag number using a join, so I have
Part p1, Part p2
I join them on the tagnum and select p1.s_num AS 's_num in' and p2.s_num AS 's_num out'. I also know how to tell that p1 is definitely an in part and that p2 is definitely an out part by their description, which will always be 'in' and 'out' respectively. So I have:
SELECT p1.s_num as 's_num in' p2.s_num as 's_num out' ... etc
FROM Part p1 JOIN Part p2 ON (p1.tagnum = p2.tagnum AND p1.description = 'in' AND p2.description = 'out')
This is great -- it will pair my in and out parts perfectly.
However, there isn't always an out part for an in part, meaning that I have a table filled with stuff to be paired and not-paired. I would like to display both of these in the result, with null values for any out value when there isn't a pair. So for this, I can do:
SELECT s_num as 's_num in', NULL as 's_num out' ... etc
FROM Part
WHERE description = 'in'
This will return ALL in parts, even the ones where there IS an associated out part for it. Consequently, when I union the two queries, I get an entry for the paired parts twice -- one where it thinks it just shows its in data (with out fields set to null), and one where it shows both the in and out, i.e., the correct result. I don't want the former.
To get round this, I have to use a NOT IN on the second query before I union it with the first. So, the final query looks like this:
SELECT p1.s_num as 's_num in' p2.s_num as 's_num out' ... etc
FROM Part p1 JOIN Part p2 ON (p1.tagnum = p2.tagnum AND p1.description = 'in' AND p2.description = 'out')
UNION
SELECT s_num as 's_num in', NULL as 's_num out' ... etc
FROM Part
WHERE description = 'in' AND NOT IN (
SELECT p1.id
FROM Part p1 JOIN Part p2 ON (p1.tagnum = p2.tagnum AND p1.description = 'in' AND p2.description = 'out')
)
As you can see, this is horribly messy and very inefficient.
I am not very competent with SQL (as you can see!), and I feel there must be a nicer way to accomplish what I'm trying to do.
If anyone can help me on this I would appreciate it (and if I haven't explained very well please do say).
I apologise if I have posted this in the wrong forum, too, and would ask that it could be moved accordingly if this is the case.
Thanks,
Simon
I've been working on a performance review web application (i.e., employee's annual reviews done via the web). In the process of creating the application I've been teaching myself .NET - maybe not the best way to do it but I've been learning a lot. However, I still feel like I'm not doing something right.On each Page_Load I'm doing database work with a data reader: Reading the data in, displaying it, letting the user add, edit, or delete it, etc. So every Page_Load code behind looks like this: string sql = "SELECT UserID, Passwd, RecID, Name FROM UserList";
SqlConnection myConn = new SqlConnection("Server=BART; Database=WSSD; User ID=sa; Password=wss1231");
SqlCommand cmd = new SqlCommand(sql, myConn);
SqlDataReader dr;
myConn.Open();
dr = cmd.ExecuteReader(); And so forth and so on. Now since I re-use this code again and again - I imagine it's a good idea to implement my connection code in a class that I can re-use easily. But I have no idea where to start on something like that. What can I say? I'm a newb. A push in the right direction would be great.
2 questions, actually:
I am new to database design and a lot of things never made any sense to me regarding relationships and such. I have been working on a very large design that started out well enough, but as tables were added a lot of organization fell by the wayside. Now that I am getting closer to the end, I am finding a lot of places where there should be Foreign keys, maybe some triggers, etc (I have the same data item in 5 different places, when it is deleted in one place it must go from all). Assuming that the datatypes and sizes are identical for the duplicated bits of data, can I go about making FK-PK relationships and such now that there is a lot of stuff in the database, or do I have to start from scratch and rebuild the whole thing.
The other question is much more simple:
How do I make multiple rows "unique". I have a primary key, and an identity column, but I can't add a secong primary key, and Enterprise Manager only lets me make 'int' datatypes identity columns. I have tried the "add constraints" but it asks for an expression and I have no idea what the syntax might be.
Any help is appreciated.
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 RelatedIm 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?
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?
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
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
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
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
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 RelatedGood evening,
View 8 Replies View RelatedHi!
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
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.
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
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?
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?
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
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.
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
Hi
Is it possible to specify the last value as a data label on a line graph...
Regards
Karen
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
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.
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?
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 + "&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
}
}
I'm investigating my production server because there appears a deadlock every day. So, in SQL Profiler, I use the the Deadlock graph to capture the trace in a file.
When I click on the textdata to see the graph an error appears:
- Failed to initialize deadlock control.
Cannot find process victim in process list.
I also get the following error from another deadlock:
- Failed to initialize deadlock control.
Object reference not set to an instance of an object.
I stopped my trace, so this can not be the problem.
Does anybody knows why I can't see the graph?
I also captured the trace in a table and then used the following query to see it in xml:
select convert(xml,textdata)
from TableName
This works fine.
Hi,
I have created a multi column report (2 columns), which is working fine. However, I need to have a chart on the same report, but it needs to be the width of the page, and not just the width of one column.
If I could put the chart in the report footer / header that would be perfect, but obviously I can't!
Has anyone else come across this, and any ideas / suggestions you have would be appreciated!
Cheers
Chris
I have some problems in understanding the dependency network graph which is built in the association rules algorithm. My questions are:
1) Assuming an arrow goes from Node A to Node B ( A --> B), is Node A dependent from Node B or is Node B dependent from Node A?
2) Are only rules used with one element on each side of the rule (itemset size = 2) or is the graph also influenced by rules with more elements?
3) it is said that the slider on the left side is related to the probability of the rules. when viewing my rules table I don't understand why some rules are viewable later then other ones because they have the same probability. Is there another parameter influencing this slider? Which one?
I would be grateful for your help!
Regards, David
when I create graph (Pia)
the graph take 80%, and the labels take 15%,
example here:
http://img2.tapuz.co.il/forums/1_91779074.jpg
is it possible to grow the place of the labels?
I try look on the properties and I didn't find.
thanks!
Hello
I am making the switch from using MSACCESS to do required reporting to using Reporting Services to accomplish the same tasks.
A requirment I have is that whenever a graph (chart) is created, it contain the underlying data in a connected and aligned data table. MSACCESS allows this by selecting the chart options and then "show data table".
Is this ability included in Reporting Services in MS Visual Studio 2003 .NET? If so, how can I enable it? I currently can only enable the legend.
Currently we are using:
SQL Server 2000 (sp3a)
Reporting Services (sp2)
Visual Studio .NET 2003
Thanks for any and all help.
Ben
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...