AnsweredAssumed Answered

wrong script output!! Finfing specific data within a month!

Question asked by penhaifai on Jan 13, 2010
Latest reply on Jan 14, 2010 by StellaLuna

Title

wrong script output!! Finfing specific data within a month!

Post

I have this script that a friend of mine did; i don't want to get credit for what i didn't do! it has a nice feature of searching within specific dates for data. but it is still doesn't matching the same results as i can get it when i run the regular "find" methode. In fact, it comes up with less of what the "find" can come up with!! what is missing in this script?!!

 

Show All Records
Go to Record/Request/Page
[ First ]
Loop
If [ (Client Databse V9::NineMO_Due_Month = Client Databse V9::NineMO_Report_Month_Select and Client Databse
V9::NineMO_Due_Year = Client Databse V9::NineMO_Report_Year_Select) ]
Omit Record
End If
Go to Record/Request/Page
[ Next; Exit after last ]
End Loop
Show Omitted Only
Go to Layout [ “Report-9mo_Reviews_Due” ]

 

 the layout is as following;

 

 

 the "find due" is a trigger to the script...

 

I tried to improve and correct the script and came up with this one but still same incorrect results!

 

Show All Records
Go to Record/Request/Page
[ First ]
Go to Layout [ “Report-9mo_Reviews_Due” ]
Loop
If [ Client Databse V9::Info_Active="Open" ]
If [ (Client Databse V9::NineMO_Report_Year_Select = Client Databse V9::NineMO_Due_Year) ]
If [ (Client Databse V9::NineMO_Due_Month = Client Databse V9::NineMO_Report_Month_Select) ]
Omit Record
End If
End If
End If
Go to Record/Request/Page
[ Next; Exit after last ]
End Loop
Show Omitted Only
Go to Layout [ “Report-9mo_Reviews_Due Copy” ]


 

 

Thank you in advance

 

 














Outcomes