place on you Report Layout the delivery date field, formatted to show ONLY the month and the Year.
You could use even a merge field.
I hear what you are saying, and yes that could work but they want the option to select a month which will display as "May 2010" and the report then has to diplay all orders that are delivery date are within that month.
So that field must fire a script that finds all the orders within that month ?
Am I right to suppose that you'll chose the month by a value list ?
Yes if that is the easiest way of doing it.
Sorry im new to FM and still learning.
1) Create a custom value list of the month's names
2) Create a global text field ( gMonths ) formatted as a Drop-Down List showing the value of the list 1)
3) Create a script along this way:
Set error Capture [ On ]
Enter Find Mode [ ]
Set Field [ YourTable:: Delivery Date ; Ceiling ( Position("JanFebMarAprMayJunJulAugSepOctNovDec" ; Left ( gMonths; 3 ) ; 1 ; 1 ) / 3 ) ]
Perform Find [ ]
If [ Get ( LastError ) ]
Show Custom Dialog [ "No record Found" ]
Show All Records
4) Add an OnObjectExit trigger that fires this script to the field gMonths.