AnsweredAssumed Answered

Reporting Scipt Problem...

Question asked by heath on Oct 22, 2012
Latest reply on Oct 24, 2012 by heath

Title

Reporting Scipt Problem...

Post

     Hello,

     The following is a script I use to generate a report of test that are do on todays date.  Everything works great, it finds all records with matching dates. 

         
  •           Show/Hide Toolbars [Show]
  •      
  •           Enter Find Mode [Restore]
  •      
  •           Set Field (Cyllinders:C_Date; Get (CurrentDate)]
  •      
  •           New Record/Request
  •      
  •           Set Error Capture [On]
  •      
  •           Perform Find []
  •      
  •           Enter Preview Mode []

     However, I also need it to find dates that are past due.  So I have added some other parameters to tell it to find not only records =< todays date, but that have a blank results field "CYCLINDERS::Crush Result".  This is to avoid all dates previous to today from being found, rather all fields less than or equal to today that have no data in the afformentioned field.  My script looks as follows

      

         
  •           Show/Hide Toolbars [Show]
  •      
  •           Enter Find Mode [Restore]
  •      
  •           Set Field (Cyllinders:C_Date; Get (CurrentDate) and CYCLINDERS 3::Crush Result = ""]
  •      
  •           New Record/Request
  •      
  •           Set Error Capture [On]
  •      
  •           Perform Find []
  •      
  •           Enter Preview Mode []

     This script does no work.  I have tried every combo I know and can't seem to make it work.  Any suggestions,

     Greg

      

Outcomes