Using a Line Graph

[User (Legacy)]

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

[Software FX]

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

>

>