Alpha Video Training
Results 1 to 8 of 8

Thread: Report skills

  1. #1
    Mano B
    Guest

    Default Report skills

    I am creating a delivery report that shows all of the deliveries :
    Early
    On Time
    Late

    I am using the fields : date_required & ivoice_date
    i have managed to do a count of all the on time deliveries
    using a calculated field 'del_made'

    The other two fields : 'early' and 'late'

    i have tried and tried to write an expression that will do a count of all deliveries where the invoice_date is before the 'date_required'(early) and vice versa

    please could someone advise me?

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Report skills

    You are probably having difficulty with records where there is not yet an invoice date (={}) trying to compare this to date_required. If this is the case then something like:

    early = if((isnotblank("invoice_date").and.invoice_date

  3. #3
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Report skills

    Sorry should be

    early = if((isnotblank("invoice_date").and.invoice_date ),1,0)

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Report skills

    I'll get it right soon, forgot to "code" the @#lt;:

    early = if((isnotblank("invoice_date").and.invoice_date @#lt;date_required),1,0)

  5. #5
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Report skills

    D##n


    early = if((isnotblank("invoice_date").and.invoice_date &#lt;date_required),1,0)

  6. #6
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Report skills

    I can play with this all day!

    early = if((isnotblank("invoice_date").and.invoice_date &#lt;date_required),1,0)

  7. #7
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Report skills

    early = if((isnotblank("invoice_date").and.invoice_date "date_required),1,0)

  8. #8
    Mano B
    Guest

    Default RE: Report skills

    Thank you Stanley, that was very helpful.

Similar Threads

  1. Web report similar to filtered desktop report
    By Robert Rough in forum Web Application Server v6
    Replies: 2
    Last Post: 06-08-2005, 11:14 AM
  2. Report Detail into Report String
    By Carey Sovereign in forum Alpha Five Version 4
    Replies: 1
    Last Post: 04-01-2003, 09:25 PM
  3. Report Footer and "Internal Report Error"
    By GregOnline in forum Alpha Five Version 4
    Replies: 3
    Last Post: 04-23-2002, 09:30 AM
  4. set report summary report non zero balances
    By vasant panjabi in forum Alpha Five Version 4
    Replies: 2
    Last Post: 11-15-2001, 05:45 AM
  5. Report skills
    By Mano B in forum Alpha Five Version 4
    Replies: 1
    Last Post: 08-14-2000, 04:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •