Hi Ed,

i create a view and how to call that?

TIA

>>Hi,
>>
>>first i design form that asking for a beginning date and the last date. (date range: bdate-->beginning date and edate --> ending date)
>>
>>It is possible to for this statement to print preview a report..
>>
>> report form "myreport" while i_master.dpetsa >= bdate and i_master <= edate preview
>>
>
>This will run from the current position in the file until thw WHILE condition is not satisfied; if the current record does not meet the WHILE condition, nothing will be included in the report. This is equivalent to locating the first desired record and then processing until the condition fails - records that logically precede the current record will not be included in the report. This will almost universally not do what you want if you preview and then decide to print; the initial record position won't be restored after the preview takes place.
>
>>.or.
>>
>> report form "myreport" for i_master.dpetsa >= bdate and i_master <= edate preview
>>
>
>This will include records in the report that meet the FOR condition, regardless of their position in the file. Records are scanned in the prescribed sort order for the main table fromt he logical 'top' to the end of the file. This is equivalent to setting a filter on the table. Doing a SQL Select to build a cursor and reporting against the cursor, using a view rather than the raw table, or setting a filter on the master table will allow previews and subsequent reporting.
>
>>which of this are much better to use?
>>TIA