Hi there:

1) Yes, I did everything in GridView. The report/view was supposed to get us the sales history for a range of items within a specified period. GridView would prompt for an item# range and then tell us how many of these items were sold during a particular month. For testing purposes, I wanted it to report the numbers for the month of February (2008). Our fiscal year started on July 1, 2007 - so February 2008 would be fiscal period 8. (As I had mentioned before, I had changed the beginning of the fiscal year to July 1.)

I selected the following table in GridView:

I/C Items (1)

I selected the following fields from that table:

Item #
Base Price
Units Sold Period 8
Amt Sold Period 8
Units Sold Period 2
Amt Sold Period 2

When I run this report, all the numbers in the 'Units/Amt Sold Period 8' columns are for August of 2007 - indicating that GridView still thinks the year started on January 1. The numbers for Period 2 are the ones for February 2008.

I saw two workarounds for this: One was to simply go by calendar year and select 'Units/Amt Sold Period 2' instead of '... Period 8' for February.
The other one was to prompt the person running the report to enter a start and end date. I chose the latter. Here is the filter I created:

and(
{Item #} >= QUERYSTRING("Start Item:"),
{Item #} <= QUERYSTRING("End Item:"),
{Last Shipment Date} >= QUERYDATE("Start Date:",TODAY()),
{Last Shipment Date} <= QUERYDATE("End Date:",TODAY())
)

One idea I had was to create another report that shows a range of item numbers and how many were sold for every month of the fiscal year. I would want to list the item number in the first column, followed by the units sold in July 2007 (Period 1), then August 2007 (Period 2), then September 2007 (Period 3)... and, finally, February 2008 (Period 8). How would I do that if GridView continues to 'think' the year started on January 1 of 2008?

2) Yep. I did enable that checkbox.;-) The problem here is not the TODAY() date used within the report. The problem was/is that even with the Run Date set as, for example, March 1 2008 - the printed report will still say " ... (as of Fri, Mar 07,15:38)". (Please see attached screenshot.)