Recent content by rmttbone

Thanks everyone. I found the solution: p_addlinkedserver @server = 'Name of Linked Server' , @srvproduct = 'Your System DSN Name' , @provider = 'MSDASQL' , @datasrc = 'Your System DSN Name' , @location = 'Your server' , @provstr = '' ...

I am having trouble creating a linked server that links SQL Server 2000 with Informix. I am using IBM Informix Client SDK 281. I have created a System DSN using the IBM Informix 3.82 32 bit driver (ICLITO9B.DLL) I checked my registery, and the DSN is registered. I have used both separate...

Hello, I also deal with a similar situation as you describe, and I like to use a suppress formula in the section expert. I am assuming the you are using Crystal 10? >Open the Field Explorer. >Right-click Running Total Fields, select new >Highlight your Client ID# or Primary Key field...

I am using Crystal Report 10 and an Informix and SQL Server DB. I need to obtain records that are active between 7-1-05 and 12-31-05. I have a field for the start date and one for the end date. I attempted to use this select statement: {start_date}>= Date (2005,7,1) and {end_date}<= Date...

SQL Server 2000 and OLE DB (ADO)

LB, I tried it, and I got an "unknown query engine error

I am using crystal 10, and I am having trouble grouping the results of a formula. I need to count the number of occasions that an event takes place, and I need to group it in the following groups: 1,2,3,or 4 I used this select case statement to create a value: numbervar tests; select...

I am using crystal 10, and I am having trouble grouping the results of a formula. I need to count the number of occasions that an event takes place, and I need to group it in the following groups: 1,2,3,or 4 I used this select case statement to create a value: numbervar tests; select...

They are persons that use alias DOB's, SSN's, etc.

Yes, here is a sample of what I am trying to complete: Data (located in three different rows in the table): ID DOB 1 01-01-1959 2 02-02-1959 3 03-03-1959 data needed returned in one row in my report: client_id Name dob1 dob2 dob3 1...

I tried that, but how do you get it to select the next value, nthlargest, etc.?

I have to write a report that wants three ssn's, dob's, etc. for each person on one row. The returned values are to be inserted intoo columns named DOB1, DOB2, etc. The individual values are contained in their own row, in a table. Each has a unique ID and a foriegn key to link them to the...