Automatic Graph Creation
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20976
Printed Date: 06 May 2024 at 3:17am
Topic: Automatic Graph Creation
Posted By: Dr4ke
Subject: Automatic Graph Creation
Date Posted: 14 Aug 2014 at 4:49am
Good afternoon,
I post this time with a open question; as I am not sure if it's possible and, if it is, not sure of the best way to do it!
I've created a report with the following fields:
Computer Name, Date Of First Instance, Date Of Last Instance, Maximum CPU %, Count of CPU over 95%.
I have used the Select Expert to report only the CPU occurrences over 95%, a Group on the Computer Name so that only 1 record shows per Computer, and summary fields (in the group field) to show the calculations.
Here comes the difficult bit... I am now looking at ten servers on my report (indicating that they have all breached 95% at some time in the reporting period) which is great. What I now want to do is to create Graphs (1 computer per graph) based on the results of this report - so only computers that have exceeded the threshold get graphs, not every single computer.
I've considered a running total that resets after every Computer Name and then trying to generate graphs based on the numbers but then I don't know how to automatically generate graphs.
Does anybody have any ideas?
|
|