Basline to show on graph

[jschill2628]

Is there a way in Crystal XI, on a line graph to show a contatnt Basleine number?

What I was hoping to do in Crystal instead of Excel was show a count by month and have a contsant meamurment line in the graph.

For example if I have 9 months worth of date:
3/2011 23
4/2011 17
5/2011 12
6/2011 24
7/2011 16
8/2011 8
9/2011 12
10/2011 13
11/2011 14
and a baselime meansurment of 17. So I want a line graph for the data (3/2011- 11/2011), adn a contact line for the nine month period of 17.

Is this possible?

Thank you in advance!

 

[jschill2628]

I am trying to get two line in a graph at the same time. I have a sub report that finds the average count for a time period, I then pass that up to the main report that gives me the count. I want to put this in my graph so I would get a solid line, and then I would add in the count of incidents by month. Right now I cannot do it at the same time, it’s either the straight line or the incident count line (up and down). Is there a way to put two lines on a graph at the same time?

 

[lbass]

That you are getting some data for the chart from a subreport is a big piece of information to leave out. I think you would have to use the method described in the white paper:

http://www.sdn.sap.com/irj/boc/go/p...a54ff4cd?QuickLink=index&;overridelayout=true

-LB

 

[jschill2628]

Good news: I have two lines on a graph, exactly what I wanted, however I know I have something wrong with my {KYLO} formula, because it is showing me more then the correct count of incidents in the graph.


GRAPH:
On change of box:
IRSCLAIM.CREATE_DT-A (grouped by month)

Show value(s) box:
Avg of @BaselineTrial
Count of @ KYLO


FORMULAS:
{BaselineTrial}
{@BaslineAvg_KYLO}

{BaslineAvg_KYLO}
Shared NumberVar BaselineAvg;
BaselineAvg

{BaselineAvg }
WhilePrintingRecords;
Shared NumberVar BaselineAvg:=
(Count ({IRSCLAIM.CLAIM})/24)

{KYLO}
stringvar strMBO;
strMBO := strMBO + {Location.LOCA};
{Location.LOCA} = "KYLO");


Can you help?!?!?!

 

[lbass]

Please explain where each formula is located (sub or main, and what report section). You need to lead with "whileprintingrecords" in your KYLO formula.

-LB

 

[jschill2628]

GRAPH- Main report, group header

FORMULAS- Main report
{BaselineTrial}
{BaslineAvg_KYLO}
{KYLO}

FORMULAS- Subreport
{BaselineAvg }

I did the subreport in order to get the data (baseline) for the past two FY years. In the sub report selection criteria I have that the {IRSCLAIM.CREATE_DT} in between 07/01/2009 and 06/30/2011.

 

[lbass]

You didn't identify what report sections each was in.

-LB

 

[jschill2628]

All formulas in the main report ({BaselineTrial}, and {KYLO}) are in the graph, which is in the group header-A

GRAPH:
On change of box:
IRSCLAIM.CREATE_DT-A (grouped by month)

Show value(s) box:
Avg of @BaselineTrial
Count of @ KYLO

The one formula that is in the subreport ({BaselineAvg }) is in the Report Header- A of the subreport

The {BaslineAvg_KYLO} formula is in the main report, I am not pulling it in but referencing it when using the {BaselineTrial} formula

{BaselineTrial}:
{@BaslineAvg_KYLO}

The selection criteria in the Subreport is the following:
{IRSCLAIM.CREATE_DT} in DateTime (2009, 07, 01, 00, 00, 00) to DateTime (2011, 06, 30, 00, 00, 00)
and {IRSLOC_Unit.LOCA} = "KYLO"

The selection criteria in the main report, is the following:
{IRSCLAIM.CREATE_DT} in dateserial(year(currentdate),month(currentdate)-9, 1) to
date(year(currentdate),month(currentdate),1)-1

 

[jschill2628]

So I have tried something new, which I have put the graph in the group header. This is great because it gives me the correct count by month for each separate Hospital (42 total). The problem I have now is that my subreport is not working correctly to give me my baseline.

What I need is ad different baseline for each hospital (42 total), and I need the baseline to show up in the graph, along with the count of incidents by month.

I hope this makes sense, and I hope someone can help me out.

Thank you!!