Search Again: Re: Sales tax report From: Shawn Hogan Date: Friday, December 4, 1998 Time: 2:38:51 pm Melissa Starnes wrote: >so i guess that means 'NO' :) Is there anyway we can get someething like >that added. Well, theoretically it's possible, but you would be looking at an ungodly amount of time to run such a report. It would not only have to search on the primary table (product line items), but also an unidexed table through a realtionship (the customer table to make sure the customer is/isn't a taxable customer). Not only that it would have to do a 2-level unidexed search, because it would have to first search back to the invoice that the line items are on in order to first see who the customer IS. And THEN search on that data to see if they are taxable. Hmmm... I made it sound really difficult, but it's not. It would be pretty easy to add, I'm more concerned about the time it would take to run such a report. - Shawn ------------------------------- Shawn D. Hogan President, Data Point Solutions http://www.data-point.com (619) 452-3696 ICQ: 8319647

Messages In This Thread: Sales tax report by Melissa Starnes on Dec 4, 1998 at 1:53:06 pm Re: Sales tax report by Shawn Hogan on Dec 4, 1998 at 1:58:49 pm Re: Sales tax report by Melissa Starnes on Dec 4, 1998 at 2:28:06 pm Re: Sales tax report by Shawn Hogan on Dec 4, 1998 at 2:38:51 pm Sales Tax Report by Mike Breen on Mar 21, 2001 at 11:14:20 am Re: Sales Tax Report by Michael Reid on Mar 21, 2001 at 12:36:03 pm Sales Tax Report by Marian McCurdy on Jun 29, 2002 at 4:26:04 pm Re: Sales Tax Report by Shawn Hogan on Jul 1, 2002 at 2:58:45 pm Re: Sales Tax Report by Marian McCurdy on Jul 1, 2002 at 3:26:07 pm Re: Sales Tax Report by Shawn Hogan on Jul 1, 2002 at 3:31:40 pm Re: Sales Tax Report by Marian McCurdy on Jul 1, 2002 at 3:51:32 pm Re: Sales Tax Report by Butch Andrews on Jul 2, 2002 at 7:28:14 am Sales Tax report by Jeff Folk on Jan 23, 2003 at 10:58:27 am Re: Sales Tax report by Butch Andrews on Jan 23, 2003 at 12:13:39 pm Sales Tax Report by Tim on Oct 27, 2003 at 6:13:29 pm Re: Sales Tax Report by Shawn Hogan on Oct 28, 2003 at 10:59:37 am