Home Page link  

Report date filter problem

  
Groups | Search | About
User Password
Register Now! Lost Password?

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Report date filter problem TV hardware 08-18-2005
Posted by TV hardware on August 18, 2005, 4:49 am
Please log in for more thread options
 Since using RMs during the past 2 years, I have created several memorized
sales reports. These reports include date and 1 to several item categories.
When I run the report for month-to-date or year-to-date or anyother date
parameter, the finished report includes 2 years of sales data, not what was
requested.. Any suggestions?


Posted by Robert on August 18, 2005, 10:10 am
Please log in for more thread options
 TV hardware,

I imagine your filter looks something like this:
Date Sold between 01/01/05 and 08/18/05
AND Department = SomeDepartment
OR Department = SomeOtherDepartment

If it does that is the problem. The logic here is I would like to see all
items that were sold this year to date and all items that are in Department
SomeDepartment or ANY item that was sold any time in SomeOtherDepartment.

What you want to do is run the report for this year to date with no
departments and then minimize the departments you don't want to see and
leave the others expanded or just one department at a time with this year to
date.

Rob

> Since using RMs during the past 2 years, I have created several memorized
> sales reports. These reports include date and 1 to several item
> categories.
> When I run the report for month-to-date or year-to-date or anyother date
> parameter, the finished report includes 2 years of sales data, not what
> was
> requested.. Any suggestions?




Posted by Natt on August 19, 2005, 3:21 pm
Please log in for more thread options
This is how you need to do your report:

Date Rage
AND Category
OR Date Range
AND Category
etc.

If you did
Date Rage
AND Category
Or Category

It means that you want a date range report of the first category and all
date range report of the next category.

"TV hardware" wrote:

> Since using RMs during the past 2 years, I have created several memorized
> sales reports. These reports include date and 1 to several item categories.
> When I run the report for month-to-date or year-to-date or anyother date
> parameter, the finished report includes 2 years of sales data, not what was
> requested.. Any suggestions?


Similar ThreadsPosted
Date Not Changing on Report Filter May 4, 2007, 5:32 pm
Date sold filter value July 21, 2007, 9:41 pm
Statement filter date July 8, 2008, 9:31 pm
Purchase order and transfers date filter October 2, 2007, 12:04 am
Add sale price Sale Start Date & Sale End Date -Item Wiz filter July 2, 2007, 4:54 pm
Filter a report August 10, 2007, 7:10 am
Modifying Report Filter June 23, 2005, 7:20 pm
Modifying Report Filter June 27, 2005, 8:19 am
Report with Negate Filter September 5, 2006, 3:51 pm
Report Filter focus March 6, 2008, 11:44 am

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap