Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. blueboyz

    Excel 2010 - finding SSN matches in two columns and then compare amounts

    I need to find the matching SSN/TINS (that appear on two different worksheets) and then compare the 1099 amounts for that SSN/TIN. If the amounts match, do nothing. If the amounts are different, highlight the amounts or put the SSN/TIN and the two different amounts in new columns. Is this...
  2. blueboyz

    Error: The specified module could not be found

    Using CR v2012 and Sage 50 2015. We used to be able to run reports through a crystal reports viewer within Peachtree (Sage 50). Now, with Sage 50, we must run reports outside of Sage 50 and just connect to the database. We use the OLE DB connection. After we updated the Database Location, we...
  3. blueboyz

    Join two Databases

    Thank you, I'll take a look at that post.
  4. blueboyz

    Join two Databases

    Hi: I'm using Crystal Reports 2008 for Peachtree. Sage 50 Premium 2013 and database engine is Pervasive SQL. I created an annual sales report in Crystal Reports. The customer created a new company in Sage 50 Premium 2013 and they want to combine the transactions for both the old and new...
  5. blueboyz

    Last YTD + This YTD

    I am using Quantum 2014 and Crystal Reports 2008. Pervasive SQL is the database engine. I created a report to display Available Inventory as of today's date. The user is required to enter the inventory item id's in a parameter and the year in another parameter. My record selection is: If...
  6. blueboyz

    select records that start with a specific character and end with a specific character

    Thank you, that last code was the ticket!: {Customers.CustomerID} startswith "GC" and ( and right({Customers.CustomerID},2) <> 'EX' and right({Customers.CustomerID},6) <> 'EXEMPT' ) The report now picks out customers with IDs that startwith GC, but don't end in "EX" or "EXEMPT".
  7. blueboyz

    select records that start with a specific character and end with a specific character

    I tried the code above: {Customers.CustomerID} startswith "GC" and ( not({Customers.CustomerID} like "*ex") or not({Customers.CustomerID} like "*exempt") ) and I also tried: {Customers.CustomerID} startswith "GC" and ( not({Customers.CustomerID} like "*ex") or not({Customers.CustomerID}...
  8. blueboyz

    select records that start with a specific character and end with a specific character

    I am using Quantum 2013 and Crystal Reports 2008. The database engine is Pervasive SQL. I created a report to display the sales for customers for a specific date range. I need my selection criteria to include all customers whose ID startswith "GC", but doesn't end with "EX" or "EXEMPT". For...
  9. blueboyz

    create a group based on the text in the item description

    Awesome! Creating a group on split({ItemDescription},"/")[1] did the trick. Thank you so much!
  10. blueboyz

    create a group based on the text in the item description

    Will the split function create the different groups for the like Item Descriptions?
  11. blueboyz

    create a group based on the text in the item description

    I am using Quantum 2013 by Sage. Pervasive SQL is the database engine and using Crystal 2008. I need to group items on the report by the Item Description. The Item Description has text then a slash "/" and then more text. I want to group on the Item Description for all the text before the...
  12. blueboyz

    Check the first 6 characters or the first 3 characters of an ID

    Andymc: Thank you again for your help. I tried the 2nd formula you provided in your last post: //@GroupName stringvar gn := {LineItem.ItemID}; if instr(gn,"-") = 4 then left(gn,6) else left(gn,3) and it worked perfectly! I am grateful for your help.
  13. blueboyz

    Check the first 6 characters or the first 3 characters of an ID

    If the dash has to be in the 4 position, would the formula be: //@GroupName stringvar gn := {LineItem.ItemID}; if Left(gn,4) = "-" then left(gn,6) else left(gn,3) There are some item id's like: M75505 M75920 M75920-CAD M75920-EU and they create one group (which is correct) using the...
  14. blueboyz

    Check the first 6 characters or the first 3 characters of an ID

    Amazing! Your formula worked like a charm! Thank you so much. -GR
  15. blueboyz

    Check the first 6 characters or the first 3 characters of an ID

    I am using Sage 50 (Peachmtree) Quantum 2013 with pervasive sql as the database engine with Crystal 2008. I need help with creating a formula to group item id's. If the item id contains a dash "-" then the formula should extract the first 6 characters and create a group when the first 6...
  16. blueboyz

    Non-numeric string error for formula

    Thank you, CoSpringsGuy! I think the two formulas in your last post did the trick.
  17. blueboyz

    Non-numeric string error for formula

    {LineItem.CustomField1} is either blank (null), has the word "can" or has a numeric value. {LineItem.CustomField2} is either blank (null) or has a numeric value. I changed the formula to the best of my ability to: If isnull({LineItem.CustomField1}) then 0 else if...
  18. blueboyz

    Non-numeric string error for formula

    I tried the formula that CoSpringsGuy suggested: If isnull({LineItem.CustomField1}) or isnull({LineItem.CustomField2}) then 0 else If isnumeric({LineItem.CustomField1}) then ToNumber({LineItem.CustomField1}) * ToNumber({LineItem.CustomField2}) else 1 * [highlight...
  19. blueboyz

    Non-numeric string error for formula

    I am using Sage 50 (formerly Peachtree) Quantum 2013, Crystal Reports 2008 and a pervasive database. I created a report to convert the number of units sold to ounces. One field in the inventory item record stores the number of ounces and another field stores the number of units in a case. My...
  20. blueboyz

    Shipping Label-Print according to quantity ordered

    Here is the query: SELECT "Customers"."Customer_Bill_Name", "JrnlHdr"."Reference", "LineItem"."ItemID", "JrnlHdr"."JrnlKey_Journal" FROM {oj (("JrnlRow" "JrnlRow" LEFT OUTER JOIN "Customers" "Customers" ON "JrnlRow"."CustomerRecordNumber"="Customers"."CustomerRecordNumber") LEFT OUTER JOIN...

Part and Inventory Search

Back
Top