Hi Lucas

Sorry for my question about the name of the report. It turns out that the Sales report only appears on the menu when you have checked off the "Analyze sales data" box in Company Profile, and I was looking at a set of data where it was unchecked.

That particular report uses a temporary data table (OESALES.xxx) that gets cleared after you print the report (and say yes to the question "Do you want to clear the sales file"). So the report actually is printing all details from the date it was last run, which has nothing to do with whether a month is open or closed.

To answer your question about selecting date ranges in Crystal reports, this is done by creating a pair of parameter fields, one called "Beginning Date" and the other called "Ending Date". Then in the Edit Selection Formula, you add a filter to test for the invoice date >= Beginning Date and invoice date <= Ending Date (the syntax is not correct but you should get the idea). When running the report, it will prompt for the two dates and select the transactions accordingly.

Steve