Search results for query: *

No, just that I used ideas from both queries for my solution. My original post was a simplified version. The end result ended up using a left join, but was very similar to the second suggestion. Once I realized I could nest table queries in a view, I had everything I needed. Again, thanks so...

It never crossed my mind to next tables in a view (obviously). Both solutions were helpful, and the view is working. Thank you very much!

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

EDIT: It turns out that the stored proc is NOT returning null values. In fact, it is returning nothing for non-participants. Which explains why Crystal can't find the result set.

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 still don't know why it would have changed the number format in the report, but lbass' suggestion worked. Thanks so much for a sweet, simple solution :)

If it helps, we're using Crystal Reports Standard (Full) version 9.2.2.634.

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

Fantastic! Thank you very much.

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 think I've found the answer to my own question: http://dbforums.com/arch/130/2003/9/666279 http://support.microsoft.com/default.aspx?scid=kb;en-us;177587 It seems that either Illustrator 10 is not OLE-Automation enabled, or my file mapping is dropping the ball somewhere. Unfortunately...

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