User (Legacy) Posted September 4, 2002 Report Share Posted September 4, 2002 I'm not sure how to get my line graph to display data in 2 seperate lines. Currently I have a query SELECT TargetMonth, InjuryTarget from vw_Custom_InjuryTargets I want a line for each department, the x-axis to be the TargetMonth and the Y axis to be the InjuryTarget The view looks like this: SELECT dbo.customTable_DepartmentTarget.DepartmentID, dbo.customTable_DepartmentTarget.InjuryTypeID, dbo.customTable_DepartmentTarget.TargetYear, dbo.customTable_DepartmentTarget.TargetMonth, dbo.customTable_DepartmentTarget.InjuryTarget, PRISMHR.Admin.UsrTable.LetCol1 FROM dbo.customTable_DepartmentTarget INNER JOIN PRISMHR.Admin.UsrTable ON dbo.customTable_DepartmentTarget.DepartmentID = PRISMHR.Admin.UsrTable.TableEntry What I would like is to have my line graph display a line for each Department but I'm not sure how to do this. It seems to me that I need to have DepartmentID the query where I select from the view. Any help is appreciated Quote Link to comment Share on other sites More sharing options...
Software FX Posted September 5, 2002 Report Share Posted September 5, 2002 Hello, If I understand your database needs correctly then you should look into using the crosstab data provider for your graph. Here is a small sample of this functionality http://support.softwarefx.com/Samples/CfxIE/Extensions/CrossTab/CrossTabADO. asp. JT Tech. Support 561-392-2023 "Jason MacKenzie" <jmackenzie@formet.com> wrote in message news:AyiGpqEVCHA.1284@webserver1.softwarefx.com... > I'm not sure how to get my line graph to display data in 2 seperate lines. > Currently I have a query > > SELECT TargetMonth, InjuryTarget from vw_Custom_InjuryTargets > > I want a line for each department, the x-axis to be the TargetMonth and the > Y axis to be the InjuryTarget > > The view looks like this: > > > > SELECT dbo.customTable_DepartmentTarget.DepartmentID, > dbo.customTable_DepartmentTarget.InjuryTypeID, > dbo.customTable_DepartmentTarget.TargetYear, > dbo.customTable_DepartmentTarget.TargetMonth, > dbo.customTable_DepartmentTarget.InjuryTarget, > PRISMHR.Admin.UsrTable.LetCol1 > FROM dbo.customTable_DepartmentTarget INNER JOIN > PRISMHR.Admin.UsrTable ON > dbo.customTable_DepartmentTarget.DepartmentID = > PRISMHR.Admin.UsrTable.TableEntry > > What I would like is to have my line graph display a line for each > Department but I'm not sure how to do this. It seems to me that I need to > have DepartmentID the query where I select from the view. > > Any help is appreciated > > Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.