Search results for query: *

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...

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...

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

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...

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...

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".

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}...

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...

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

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

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...

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.

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...

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

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...

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

{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...

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...

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...

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...