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: reportdr
  • Content: Threads
  • Order by date
  1. reportdr

    Linking Table in SQL and Access

    Hello I am using Crystal 8.5. My data is a SQL database connected via ODBC and an Access 2003 database. I have fields in both that can be connected. For all the SQL tables in the report they are connected as left outer join. For the Access table it won't allow me to connect via left outer...
  2. reportdr

    Arrays.....I think

    Hello I am working with Crystal 8.5 accessing data from an SQL database. I am working with a patient data database. I require data from the diagnoses table as well as the procedures table so I am using subreports. The main reports is the demographic data and then a subreport each for...
  3. reportdr

    Array....I think

    Hi I am using Crystal 8.5 on a Windows XP/SP3 computer accessing an ODBC database. I have a report where I'm splitting a year's worth of data into quarters. For instance, cases 1 formula indicates: If DatePart ("m",{ABSTRACT.DISDATE} ) in [4,5,6] then +1 else 0 However, sometimes this...
  4. reportdr

    Fixed Width Report - Problem First Field

    Hello I have created a report for a 3rd party vendor who reuqires a certain format for importing into their system. I export as tab separated values though set up as fixed width. Everything is working perfectly except the first field imports with a bar at the start and a quotation mark at the...
  5. reportdr

    Date Time to Time Text - 24 hr format

    Hello I am working with Crystal 8.0 on a Windows XP/SP2 computer accessing an ODBC database. I am creating a report for a 3rd party vendor that must be in fixed length fields. I have the fixed length part figured out for most of the report but I'm having difficulties in getting a date/time...

Part and Inventory Search

Back
Top