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

    Array 0 Element Error

    I am having a problem handling an array error when I run a report with no data. I use CR XI connecting to a SQL Server database. The report populates an array with medical recommendations for a patient, in the report this data displays on individual lines in the details section, the array is...
  2. jenkoller

    Use VBScript to check if DTS package exists??

    I have a VBScript that copies a DTS file to the SQL Server when doing an installation. How do I write the line that would check if this package exists alread in the SQL Server and if it exists deletes it and copies the new one? Right now I have: ' VBScript source code Const...
  3. jenkoller

    Command Parameter Problems

    I have read previous posts on adding a parameter in a command statement. I am using Crystal XI Part 1) I got my report to work but have a problem in that I am prompted for the command parameter and then prompted again for this same parameter in the report parameters entry section. I do not...
  4. jenkoller

    Comparing Dates in Crystal IX

    I am trying to compare two dates. My overall question is to determine if the date of procedure Type TTE preceeded a TEE procedure type. Patient A TTE 12/8/2005 TEE 12/13/2005 TTE preceeded TEE: YES The fields are: Patient.ID USAllProcedures.TestType UDRStudy.StudyDateTime (The...
  5. jenkoller

    Extra /// from join(array, "/")

    I am trying to join a data element that is listed in the detail lines into one string array in the group footer. The problem is that I only need the distinct values which results in many characters used to separate the string at the end of the array. I need to trim the extra "///" before...
  6. jenkoller

    Trimming characters after displaying array by join function

    I have created an array. I have written a formula that displays the result of the array using the join function. Some of the results end with lastname, firstname///// . My question is: How do I get rid of the /// at the end of the name. Details follow: Declare Formula WhilePrintingRecords...

Part and Inventory Search

Back
Top