My requirement is something like this:

when I input a month (say 8-August), the result should be like this

Order Date : 1/8/2005
Order No.: 1
Customer Name : John Anee
Address : ------
City : -------
Product Id : 2432
Qty : 2
Details : -------------------------

Order No: 2
Customer Name : Fox Anthony
Address : ------
City : -------
Product Id : 2432
Qty : 2
Details : -------------------------
========================================
Order Date : 2/8/2005
Order No.: 1
Customer Name : Luis
Address : ------
City : -------
Product Id : 2432
Qty : 2
Details : -------------------------

thanks is advance

R Saini

See if this helps.

DEFINE FILE EMPLOYEE
DATE_ATTEND1/DMY = DATE_ATTEND;
END
TABLE FILE EMPLOYEE
PRINT DATE_ATTEND1 AS 'Date Attended:' OVER
EMP_ID AS 'Emp ID:' OVER
LAST_NAME AS 'Last Name:' OVER
FIRST_NAME AS 'First Name:' OVER
DEPARTMENT AS 'Department:' OVER
CURR_SAL AS 'Current Salary:'
BY DATE_ATTEND1 NOPRINT
ON DATE_ATTEND1 UNDER-LINE
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='SCREEN',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
$
END