Hello All!
I've been trying to figure this one out and not having much luck I have a report that queries the user for a start date and an end date. Various totals are calculated and that part works fine. What I am trying to do is then show the user what dates in that range were missing data.
Quick synopsis of report: within date range show sales this year, sales last year, and variances by dollar and %, grouped by store.
The problem is some of our stores are not good about getting their numbers into the database and so at any given moment they may be more or less accurate. I would like to have something displayed that would show that store 1 is missing days 11/2/2002 and 11/8/2002. while store 2 is missing 11/20/2002, 11/21/2002, 11/22/2002 etc.
The Database has data for days that have been received, but nothing for days that have not been received. I would like to avoid using a stored procedure or creating a "Calendar" table. (Rights problems)
Is there a formula that I could use in a report to compare the contents of the date field in the table and print lines for instances where the date is not found between the start date and the end date, grouped by store?
Thanks in advance!
Douglas Genne
dgenne@thepalm.com
I've been trying to figure this one out and not having much luck I have a report that queries the user for a start date and an end date. Various totals are calculated and that part works fine. What I am trying to do is then show the user what dates in that range were missing data.
Quick synopsis of report: within date range show sales this year, sales last year, and variances by dollar and %, grouped by store.
The problem is some of our stores are not good about getting their numbers into the database and so at any given moment they may be more or less accurate. I would like to have something displayed that would show that store 1 is missing days 11/2/2002 and 11/8/2002. while store 2 is missing 11/20/2002, 11/21/2002, 11/22/2002 etc.
The Database has data for days that have been received, but nothing for days that have not been received. I would like to avoid using a stored procedure or creating a "Calendar" table. (Rights problems)
Is there a formula that I could use in a report to compare the contents of the date field in the table and print lines for instances where the date is not found between the start date and the end date, grouped by store?
Thanks in advance!
Douglas Genne
dgenne@thepalm.com