>I have been asked to do something I know is doable here I go...
>
>I need to be able to design a report or form/report that has a date criteria ie Records from Date to Date where date is filled in by the end user to get totals for x reports.
>
>If anyone has any ideas or articles on a simple date interface type thing????
>
>Let me know
>
>Thanks,
>
>Fred W.
Fred,
You need to design a Report Selection criteria form which would run your report.
Create a form, put two textboxes on it txtFrom and txtTo and a command button cmdRunReport (and one more for Close, if needed).
In the Init of the form put
thisform.txtTo.value = date()
thisform.txtFrom.value = gomonth(date(),-1) && One month difference
The button will run form's method RunReport
In this method you select data for your report using SELECT-SQL statement and the values from your texboxes and then run the report using REPORT FORM command and the cursor with the data.
You can access local variables in your report, so you can add selection criteria to the header of your report.
Or simply buy Stonefield Query that can do all your reports for you.
If it's not broken, fix it until it is.
My Blog