Problem making an Subject in the header based on the found set (date range).

[tomislaw]

I wish to make a report from a date range. I make an search by date. In the search field is entered "(_some _start_date_)...(_some_ending_date)", for example say "1/1/2006...1/3/2006" (from 1 january to 1 march). All records in this date range are found. An script will generate the report.

 

So far, no problem. But now come the tricky part. I wish to put the date range in the header for the subject. Also, something like that: "This is the report for the date range from 1/1/2006 to 1/3/2006".

 

How to put the date range in some field in the header without do any manual entering the date or anything else. Just based on the date values that I entered in the search field?

 

P.S.

Sorry for my bad english.

[blevey]

Here's one way...

 

Use a global field (gDate_Range) in the header and in your script include:

 

Enter Find Mode[]

Show Custom Dialog ["Find"; "Enter Date Range";yourTable::date)

Set Field [yourTable::gDate_Range; "This ..... from " & Substitute(yourTable::date;"..."; " to ")]

Perform Find[]

 

Regards

Blevey

[tomislaw]

Thanks for the hint.