troubleshooting Question

Capture a value in Crystal Reports

Avatar of GStoner
GStoner asked on
Crystal ReportsDB Reporting Tools
7 Comments1 Solution456 ViewsLast Modified:
I have a report that displays warranty item count totals based on month.  The totals change daily as new items are added (open) and existing items are completed (closed).  I would like to capture those values at the end of each month, so that I can see a trend.  Example:  
As of 11:59 PM, January 31st, 2014. the total open warranty items was 58.
As of 11:59 PM, February 28th, 2014. the total open warranty items was 52.
As of 11:59 PM, March 31st, 2014. the total open warranty items was 46.
As of 11:59 PM, April 30th, 2014. the total open warranty items was 38.
etc.

The formula must capture the count of open items and then save that number as a value that I can reference as a static number.  

Thanks in advance for any suggestions.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros