Search results for query: *

I have two tables with customer order information: Orders and LineItem. I also have a table of employees who help place the orders. I am trying to create a view that shows the Orders.OrderID and Orders.CreateDate of the FIRST order placed for each Orders.EmpID (so, the first time an employee...

Using CRv9. One of my subreports calls a stored procedure that returns three values for a given customer ID (only one of which I'm actually using). If the customer did not participate in a promotion that month, the values are returned as NULL. I've spoken with the SQL programmer and she...

I'm mail-merging an address list from an Excel spreadsheet into a letter in Crystal. In the spreadsheet, the Zip Code is formatted with the special Postal Code formatting that displays leading zeros (eg: 04512 instead of 4512). When I view the field in the Crystal letter, the zip code displays...

We are running Goldmine 6.0 with GM+Views. I would like to set the View up to display Mapquest directions to the address in the contact record. I am able to display a Mapquest page in the View that will allow the Sales Rep to enter the address and get directions, but I want the contact...

Crystal Reports 9.0. I am writing a month end summary report for accounts with activity during the month of February. My database is SQL ODBC. The base report includes an account ID with the account's physical information (address, contact, phone, etc). The month end summary figures have...

I am running Crystal 9 on my PC and connecting to a SQL Server for my data. There is a form that has been created in Illustrator for a new promotion. The form is stored on my network currently, but I can move it if need be. I want to Link or Embed this form (call it "form.ai") into...