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!

Recent content by tellamugali

  1. tellamugali

    associate rpt with runtime version "open with"

    Thanks dgillz, But crw32.exe is not part of the runtime version
  2. tellamugali

    If table.field contains Array1 then display Array1 and Array2

    Thanks Madawc and lbass, I went with lbass's solution as it was a given (no thought required). I have read the FAQ and understand the logic behind this solution. Many Thanks tellamugali "Buy a man a fish and you feed him for the day. Teach him to fish and you feed him for life.
  3. tellamugali

    associate rpt with runtime version "open with"

    Thanks MarsianStar, I know how to associate a file type with an application I need to know what file to select to associate an rpt with Crystal Reports runtime version 9
  4. tellamugali

    associate rpt with runtime version "open with"

    G'day I have installed the CR9 runtime files on all the fat client pc's at work and 99% of them have been successful however 1 pc has a developer version of oracle or business objects, not sure which application is causing it, but it is blocking the runtime version and advising me that this...
  5. tellamugali

    If table.field contains Array1 then display Array1 and Array2

    G'day All, I am using Crystal Reports 9 to query a Laboratory Information system. Database is Intersytems Cache' connection is via an ODBC System DSN Data Source using Intesystems ODBC 4.00.836.00 driver as the LIS uses FDBMS. I need to filter my report to only display a specific result so I...
  6. tellamugali

    Error with memo field and (substr( table.field,1,254))

    Problem was solved with instr({Table.Field}, "search string") > 0
  7. tellamugali

    Error with memo field and (substr( table.field,1,254))

    I am searching the memo field for a Doctors name. The report consists of 2 fields {EP_VisitNumber.EPVIS_VisitNumber} {EP_VisitTestSetData.VISTD_Comments} I have hardcoded the Visit Number because I know the memo field for this visit has the string I am looking for...
  8. tellamugali

    Error with memo field and (substr( table.field,1,254))

    Database is Intersytems Cache database Connection is via an ODBC System DSN Data Source using Intesystems ODBC 4.00.836.00 driver as we are still running Cache 3.0 FDBMS database. I am using CRXI in an attempt to search a memo field when I create an SQL expression (substr( table.field,1,254))...
  9. tellamugali

    Results display on seaparate rows and parameter search problems

    Yeah Database is Intersytems Cache database and I have no control over field lengths etc: it is managed by a 3rd party vendor. It took about 6 months to get 1 field length changed and I had to troubleshoot the problem with Intersystems not the vendor. Connection is via an ODBC System DSN Data...
  10. tellamugali

    Results display on seaparate rows and parameter search problems

    Hi Synapsevampire thanks for the response and apologies for the slow feedback. The concatenation has fixed the basic fields that are straight out of a table but I have not managed to get the date and time fields reporting on the same line, I suspect this may be a lost cause due to the “blob...
  11. tellamugali

    Results display on seaparate rows and parameter search problems

    I am using Crystal Reports 8.5 to query a Pathology Information system written in cache, I am a newbie to Crystal reports and any knowlege I have is either from trial and error or thanks to Tek-Tips. I am using the below formulae extract data my client wants from a patient episode. I am...
See more

Part and Inventory Search

Back
Top