I know there are a ton of threads on this (I couldn't find one that might cover the report I work on)but I am looking for a way to show entries of 0 in a line chart.
Let's see, this is on Crystal 8.5.3 and using Oracle 9.2.
The report starts with 2 group charts each showing a severity for incidents recorded in the group header. The chart is a line chart with markers. (Group 1 - severity)
Management can click on these markers, and it drills down into a group showing how many incidents were reported for each application in a month rated as the severity they drilled down into. (Group 3 - by Application)
From this list, they can then click on the name of an application which then drills down into a subreport that will open 2 more line charts for the 2 severities showing how many incidents were reported in a year for the application on which they clicked. (Group 1 Subreport - by severity)
In the first set of charts, chances of it returning a 0 are perhaps 1% for a severity 1 and 0% for a severity 2 so I am not worried, but in the second set of charts, the chances of it being a 0 is around 33% so on any given report, you risk having gaps in the data. I've checked some applications and it gets ridiculous as a few applications might have 1 incident that came up in the year (such as a misreported/misdiagnosed incident) meaning my chart is nothing but a marker.
----------------------------
In terms of possible solutions given in other threads, the running totals do not seem to work, a subreport for details is out as I am already in a subreport, I cannot manually enter 0s as this will be run monthly, hard coding conditions is not feasible as I've hundreds of applications.
3 possibilities which might work that came from K. Hamady's newsletter/other posts:
-Could I possibly include another severity such as 4 where chances of it being null are next to nothing? But wouldn't my saying 'if severity = 4, then 0' be the same as a month having no severity 1 incidents for an application? Also, the report already takes 45 minutes to run, adding severity 4 would mean pulling a lot more data (I tested an application and came up with 27000+ records instead of 92)... would this make the report run for hours/days?
-Joining a primary table. I could join an application table with an outer join if I can find it, but in addition to adding months with 0's, wouldn't it add every application for which there were no severity 1 and 2 incidents reported? If I suppressed every application with 0, would it show me the 0's on the line chart properly? It would probably double or triple the time its taking to run at this point, but I can live with that.
Creating another table containing all possible dates- is this plausible on a report that runs monthly and pulls data from the previous year?
Are there any other ideas someone might be able to give me. The report works great except for this aspect of it.
Let's see, this is on Crystal 8.5.3 and using Oracle 9.2.
The report starts with 2 group charts each showing a severity for incidents recorded in the group header. The chart is a line chart with markers. (Group 1 - severity)
Management can click on these markers, and it drills down into a group showing how many incidents were reported for each application in a month rated as the severity they drilled down into. (Group 3 - by Application)
From this list, they can then click on the name of an application which then drills down into a subreport that will open 2 more line charts for the 2 severities showing how many incidents were reported in a year for the application on which they clicked. (Group 1 Subreport - by severity)
In the first set of charts, chances of it returning a 0 are perhaps 1% for a severity 1 and 0% for a severity 2 so I am not worried, but in the second set of charts, the chances of it being a 0 is around 33% so on any given report, you risk having gaps in the data. I've checked some applications and it gets ridiculous as a few applications might have 1 incident that came up in the year (such as a misreported/misdiagnosed incident) meaning my chart is nothing but a marker.
----------------------------
In terms of possible solutions given in other threads, the running totals do not seem to work, a subreport for details is out as I am already in a subreport, I cannot manually enter 0s as this will be run monthly, hard coding conditions is not feasible as I've hundreds of applications.
3 possibilities which might work that came from K. Hamady's newsletter/other posts:
-Could I possibly include another severity such as 4 where chances of it being null are next to nothing? But wouldn't my saying 'if severity = 4, then 0' be the same as a month having no severity 1 incidents for an application? Also, the report already takes 45 minutes to run, adding severity 4 would mean pulling a lot more data (I tested an application and came up with 27000+ records instead of 92)... would this make the report run for hours/days?
-Joining a primary table. I could join an application table with an outer join if I can find it, but in addition to adding months with 0's, wouldn't it add every application for which there were no severity 1 and 2 incidents reported? If I suppressed every application with 0, would it show me the 0's on the line chart properly? It would probably double or triple the time its taking to run at this point, but I can live with that.
Creating another table containing all possible dates- is this plausible on a report that runs monthly and pulls data from the previous year?
Are there any other ideas someone might be able to give me. The report works great except for this aspect of it.