Search results for query: *

I have contracts that have expired and will be expiring. I need to write a report that groups these contract into "Expires in the next 30 days", "Expires in the next 60 days", "Expires in the next 90 days". The expired contracts can date back several months (they are extended until the new...

I am using version Crystal Reports 14.1.1.1036. I need to create a formula for elapsed time - days, hours, minutes. I have an insert time - {X_datetime_insert} and a fulfilled time {datetime_acted}. For example: part requested 10/14/14 at 11:15 AM, part issued 10/16/14 at 1:00 PM for an...

I have a database where I collect vehicle number, date, number of gallons of fuel put in at fuel pump and odometer reading at time of fueling. I am writing a report and need to formulate miles driven and miles per gallon. Therefore I need 2 formulas - 1 that will look at (per vehicle) the fuel...

I am using Crystal Reports 10. I have a vehicle insurance report I am writing. Each year the insurance figure changes. I want to write the report so if the date is before Jan 1 2006 the insurance figure is 105.00. If it is after Jan 1 2006 it is the figure defined in the field. My field is...

I am writing a fuel report using Crystal Reports 10. I am grouping by vehicle and selecting fuel transactions by date. I am pulling a field called FTK_Main.meter_1 which is the odometer reading. I want to record the previous record (which is the odometer from the last time they fueled). The...

I am creating a report that will print vehicle odometer readings. My field is {Meter1}. I am defining it by date. I need to print only the first odometer reading and the last odometer reading. I then need to calculate and print the total mileage between the two.

My database supplies me with "department code" field, "vehicle number" field, "fuel ticket date" field, "quantity fuel" field, "fuel price" field and "value fuel" field. The "value fuel" field gives me the transaction total. This is made up of quantiy pumped x fuel cost (fuel cost has 10%...