Search results for query: *

Sorry...I did group them just like I wanted. But it still is showing contracts that are beyond the 90 days. I don't want them to show on the report. Thanks again!!

Yes, this works, but it still shows contracts that will expire after 90 days. I need to not show those. Any way I can write this so these are distinct groups? That way I can filter within the group by Agent or by Vendor. Thanks,

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...

Sample data fron data base. ID Bus Date Gallons Mileage 1 1 4/7/2009 56 10330 2 2 4/6/2009 50 22675 3 1 4/3/2009 66 10110 4 2 4/3/2009 55 22225 5 1 4/4/2009 45 10220 6 2 4/4/2009 52 22445 I need Bus 1 to look at the fueling from 4/7/09 - mileage 10330 - look at the last time it fueled...

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...

YES, that worked perfectly, thanks much.

My report looks like this: [group 1] Department number and name [group 2] vehicle number and description I have placed my fuel supreport into GH2 and it is reporting correctly. In my subreport in report footer I have placed the shared number variable--@shared number variable (number) I...

I've been working on this for a week now and I can't get the last formulas to work. If in the //{@previous}; I put numbervar cnt:= 1; if cnt = 1 then reading else previous ({table.meteratfillup}) I get the last odometer from the previous month to print fine but it just repeats. It is NOT...

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...

Congratulate me, you walked me through my first sub-report outside of the class I took last year. However, I need to know how to get that previous odometer reading to be picked up and read by my Previous ({FTK_Main.meter.1}) formula which is my Previous Meter Column. I need my report to show...

I do have groups in my formula. My first group is Department ie: parks dept, engineering, etc. My second group is Vehicle number which is how we track them. In my Details I am pulling Fuel ticket date, fuel tank number, pump price, quantity pumped, odometer reading. It is at this point I...

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%...