Graphing certain groups together

[reitter]

Ok, I'm stumped!

I have a report with 6 different group representing vital signs. The Groups would be Pulse, Temperature, O2Saturation, Respiration and Intake and Output. (All of the data comes from the same table). I can easily make line graphs that show up in each individual group footer. My problem is the physicians want to see 1 graph that contains: Pulse, Temp and Respiration and 1 graph that has both Intake and Output, and 1 graph for 02 Saturation.

By making the individual ones in various subreports I can get the output to work the way they want to see it, but it takes hours to run, which won't work at all.

I sense that I must be able to make some type of formula that says: if QueryID = Pulse or Temp or Resp then graph

but I don't have a clue where to start or where I would actually end up putting the formula.

I hope this is enough info,

Thanks, Kim

 

[FVTrainer]

What does your table look like? Is each Vital Sign Category (Pulse, Temp, etc.) a separate field? I'm trying to picture your graph. How have you completed the Chart Expert? What fields are you using in the "For each Record" combo (if applicable) and the Show Values combo?

 

[reitter]

My 1st group is: Adm.PatientName and
My 2nd group is: Assesment.VS which will have several
different responses: Pulse, Temp, Sa02, Respirations,
Intake and Output.
My 3rd group is Assesment.VS.DateTime which shows the vital
sign response and time taken.

I've put my chart in my Adm.PatientName footer. Using chart expert I used the following:

On Change of Assessment.VS.DateTime and Assesment.VS show VS Response I'm not summarizing the data.

The way I have it now I can get 1 graph in each patient footer that shows ALL Vital Signs. Unfortunately because of the range of values this isn't a good way to look at it. So in the main report I left my 3 vital signs I want to go on 1 graph: Temperature, Pulse, and O2Saturation. Then I made 3 subreports, each one showing only 1 vital sign so that I can have a graph that is only showing 1 parameter.

My report looks like:

Patient Footer
graph showing 3 combined vital signs
Subreport1 graph that shows 1 vital sign- Respirations
Subreport2 graph that shows 1 vital sign- Intake
Subreport3 graph that shows 1 vital sign- Output

Does this help??

Thanks, Kim

 

[lbass]

Instead of subreports, I think you could create separate graphs by making use of the specified group order option. In your chart as you initially designed it, click on Assesment VS in the "On Change Of" section and then select group options->specified order and enter the three vital signs you want displayed, using the dropdown list. Then click on the "Others" tab and choose "discard all others".

Create the other charts and repeat, limiting the display by your choice of specified group and discarding the rest.

-LB

 

[reitter]

This worked great! Thanks for pointing me in this direction, I've never tried using the specified order function.

Thanks again!!!