Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rmttbone
  • Content: Threads
  • Order by date
  1. rmttbone

    Trouble with Linker Server for Informix

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

    Trouble with date ranges

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

    Cannot group a formula field

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

    Returning a values from the small column/field to the same row

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

Part and Inventory Search

Back
Top