Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: CR4Reid
  • Content: Threads
  • Order by date
  1. CR4Reid

    Records not showing for preset range

    Hello, Using CR2008 and I can't figure out why my records are acting the way they are. I need to show invoice references to a job. Each invoice book has invoice numbers which are their respective references. Each job will then be associated to a reference. Some invoices are voided or lost...
  2. CR4Reid

    Select statement

    Hello all, Using Crystal XI and Oracle ODBC. I'm trying to extract the first 4 or 5 digits from a field and declare it as the field "OBJECT" in the SELECT statement. The contents of "FIELD_A" is as followed: S510#CCBB S1313#BTCC 14444#SQQQ 7980#TUVV The result that I'm looking for: S510...
  3. CR4Reid

    Help with Crosstab calculation

    Hello, I'm using Crystal 11.0.0.1282 and I'm having trouble with Crosstabs. I have 2 fields in the crosstab: count of occurrences and sum of dollar values of these occurrences. The report is grouped by date (monthly) and it's spread across 8 branches. When I put the crosstab into GH1, it...
  4. CR4Reid

    Operational days

    Hi there, I've got a unique problem calculating data based on an operational day. I've got buses that comes in at 4 am and required to be fueled starting at 6 am. The operational day is from 4 am today til tomorrow 3:59:59. For example: today is Thursday and the time is 7:00 am. Bus 3359 is...
  5. CR4Reid

    Fueling vehicles with certain time range

    Hello, I need to count distinct vehicle numbers within a 2 week time frame of how much fueling was done. Fueling is done at 8 am and continues through the night until 7:59 am the next morning. This counts as the same day. So if on Feb 11 8:30 am, car 1234 was fueled, that counts as one...
  6. CR4Reid

    Insert running total value into a formula

    Hello all, Been at this for a while and can't seem to get it to work. I have a report with 3 groups: By technician, by job, then by invoice. 1 technician can have multiple jobs, and each job can have multiple invoices. Each job will have hours posted to it by the technician as well as an...
  7. CR4Reid

    Single job#, multiple invoices, duplicated expenses

    I have a report that details each invoice and cost for each job. The problem is that 1 job may have more than 1 invoice or credit memo. No problem, I group by JobID, then list all invoices for that job. The problem I'm having is when there are multiple invoices or credit memo for 1 job. It...

Part and Inventory Search

Back
Top