Question about Reports - Live Outcomes / Save Rate % between two dates

[Jasbury93]

Hello!
I'm looking for a little help with a figure under reports.

On the report for Live Outcomes / Save Rate % between two dates a drop down box comes down and you need to select a specific species. How can I edit this to show ALL species within the date range? Thanks! I'd like to get the total save rate percentage.

`$VAR from DATE Enter from date$
$VAR to DATE Enter to date$
$VAR sp SPECIES$

SELECT t.LiveOutcomes, t.EscapedStolen, t.Died, t.Euthanised,
t.LiveOutcomes + t.EscapedStolen + t.Died + t.Euthanised AS AllOutcomes,
ROUND(t.LiveOutcomes / (t.LiveOutcomes + t.EscapedStolen + t.Died + t.Euthanised + 0.00) * 100.0) AS LivePercentage

FROM (

SELECT
(SELECT COUNT() FROM adoption WHERE MovementType IN (1,3,5,7) AND MovementDate >= '$@from$' AND MovementDate <= '$@to$' AND EXISTS(SELECT SpeciesID FROM animal WHERE ID = adoption.AnimalID AND SpeciesID=$@sp$)) AS LiveOutcomes,
(SELECT COUNT() FROM adoption WHERE MovementType IN (4,6) AND MovementDate >= '$@from$' AND MovementDate <= '$@to$' AND EXISTS(SELECT SpeciesID FROM animal WHERE ID = adoption.AnimalID AND SpeciesID=$@sp$)) AS EscapedStolen,
(SELECT COUNT() FROM animal WHERE SpeciesID=$@sp$ AND PutToSleep = 0 AND DiedOffShelter = 0 AND DeceasedDate >= '$@from$' AND DeceasedDate <= '$@to$') AS Died,
(SELECT COUNT() FROM animal WHERE SpeciesID=$@sp$ AND PutToSleep = 1 AND DiedOffShelter = 0 AND DeceasedDate >= '$@from$' AND DeceasedDate <= '$@to$') AS Euthanised

) t`

[bobintetley]

Sorry, I'm afraid there isn't an easy way to do that without completely rewriting the report as it's geared around a single species.

[Jasbury93]

Darn, ok. We’re working on lowering our euthanasia percentage and that would really help us keep track.

Thank you so much for replying.