Search results for query: *

Using Crystal Reports 10 and SQL2008 DB (Dynamics GP backend accounting software). I am trying to recreate customer statements that are produced within Dynamics GP. I want it to look similar to this: Document # Code Date Debit Credit Balance 517020 Sale 12/12/08...

Using SQL2008 I have two pricing tables that have the exact same columns. I need to find the records in 1 table that do not exist in the other table. If TABLE A has a Price Level and Unit of Measure combination = CATPRICE EX I need to know which of those item numbers do not have a Price Level...

Using SQL2005 against Dynamics GP. I have a table that contains inventory items. We have inventory items that end with a +C and +O with the same preceeding characters. I need to generate a query that will give me a list of all +C items without correspoding +O items. How should I go about...

Using SQL 2005 I have a contact name field where the first and last names are stored together. Some of the last names start with Mc. I need a script that will capitalize the letter after the Mc. Here are examples of data in the table. Bill Mcconnell Jim Mccall Joe Smith Tim Lansing Dan...

Using Crystal 10, SQL 2005, GP Dynamics backend database I have a memo field that I need to split into separate fields for the purpose of formatting. For example, my field reads: "Repair Only - 90 Day Warranty (hard return) Specify Tilt & Lighting Volts" I need the words Specify Tilt &...

Using Crystal 10 with Microsoft SQL Server and the ERP package of Microsoft Dynamics GP. All information in the item database is stored in uppercase. For this particular crystal report we do not want all uppercase so I am using the propercase function first. When I use the propercase some...

Using Crystal 10 with Microsoft SQL Server 2000 backend and a Microsoft Dynamics ERP solution. I have a report that is generating labels based on ship to addresses for customers. Customer Number is GH1 and Address Code is GH2. The label contains the customer name and all contacts associated...

Crystal 10 - SQL database. Trying to find vendors that do not have a % sign in their payment terms. I have tried a couple formulas that generally work for me, but are not working in this instance - see below. not ({PM00200.PYMTRMID} like "*%*") {PM00200.PYMTRMID} <> "*%*" Examples of raw...