Character Length Report

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

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date Character Length Report nt8378 08-17-2007  RE: Character Length Report Relentless 08-17-2007  RE: Character Length Report nt8378 08-22-2007
Posted by nt8378 on August 17, 2007, 5:53 pm Please log in for more thread options I am trying to create a report that shows me all Item Lookup Codes over 14 digits. I’m sure this has to be somewhere in the TablesQueried Field: Item.ID AND LEN(Item.ItemLookupCode) > 14 If someone has an easier way please let me know. Thank you, Neil Posted by Relentless on August 17, 2007, 5:53 pm Please log in for more thread options You need to use the 'SelCriteria' keyword to filter down the report instead of the 'TablesQueried'. TablesQueried section provide the FROM clause of the SQL query. To modify the WHERE clause of the SQL query you need to modify the 'SelCriteria'. The syntax you provided should work in there. I do not know any front-end method to do what you are trying to do. So modifying the report code is the easiest method I know. "nt8378" wrote: > I am trying to create a report that shows me all Item Lookup Codes over 14 > digits. I’m sure this has to be somewhere in the TablesQueried Field: > > Item.ID AND LEN(Item.ItemLookupCode) > 14 > > If someone has an easier way please let me know. > > Thank you, > Neil > Posted by nt8378 on August 22, 2007, 6:02 pm Please log in for more thread options Thank You Relentless, That worked. Just had to put 'LEN(Item.ItemLookupCode) > 14' in the 'SelCriteria. Thank you again, Neil "Relentless" wrote: > You need to use the 'SelCriteria' keyword to filter down the report instead > of the 'TablesQueried'. TablesQueried section provide the FROM clause of the > SQL query. To modify the WHERE clause of the SQL query you need to modify the > 'SelCriteria'. The syntax you provided should work in there. I do not know > any front-end method to do what you are trying to do. So modifying the report > code is the easiest method I know. > > "nt8378" wrote: > > > I am trying to create a report that shows me all Item Lookup Codes over 14 > > digits. I’m sure this has to be somewhere in the TablesQueried Field: > > > > Item.ID AND LEN(Item.ItemLookupCode) > 14 > > > > If someone has an easier way please let me know. > > > > Thank you, > > Neil > > Similar Threads Posted Restore ability to enter 20 character PO Numbers July 19, 2006, 10:02 pm Length of Cashier ID April 25, 2008, 1:27 pm Synchronize field length in RMS and GP July 17, 2007, 6:06 pm Can I Increase The Length Of The Serial Number? January 9, 2006, 4:52 am PO number field length should go back to 20 characters August 20, 2007, 1:26 pm Parent / Child Receiving Report or Gross Margin report May 16, 2007, 9:11 am Report on the item movement report should show qty on hand as we September 1, 2005, 10:37 am Sales Report vs. Tender Report - large difference March 5, 2007, 7:47 am Detailed Sales Report Tax-Inclusive is an inaccurate report February 28, 2008, 4:15 pm Customize report - Card transaction detail report October 27, 2009, 5:10 pm