Print Page | Close Window

Equipment Cost

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21670
Printed Date: 28 Apr 2024 at 9:40am


Topic: Equipment Cost
Posted By: EHammer
Subject: Equipment Cost
Date Posted: 03 Sep 2015 at 8:30am
I have been asked to generate a report showing the costs for a piece of equipment based on the mileage range and I'm not sure where to start. One data file has the cost history by equipment # & date, and the meter reading & reading date are stored in another file. I'm looking to get the costs that occurred during the mileage ranges of 0-50,000, 50,001 - 100,000, 100,001 - 150,000, 150,001 - 200,000, and 200,000+.

Any suggestions on how to get the costs totaled based on the groupings by the dates of the various mileage ranges?

Thanks for any direction you can give me!



Print Page | Close Window