Search results for query: *

That did the trick. Thanks so much for teaching me this method.

Thanks for your help synapsevampire, I still have one issue that is dragging this down. I have placed the 3 formulas in the appropriate areas (group header, details section, and group footer) although the string does not reset itself after each group. What I am seeing is this Group 1...

Thank you for the quick help. I am having some problems. I am not the best at this so I am not able to figure it out. I am getting the following errors when I try to save the formulas. I have tried the formulas from both posts and am getting errors. When I try: @Recommendation Declare...

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

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

When I read the information for this fix on the Business Objects website it says this is specifically for those using Visual Studio 2005. It states that "if you are not using Visual Studio 2005 you don't need Crystal Reports XI Release 2". Will this still help me? I am using Crystal Reports...

Thanks for the response. Unfortunately manually updated lists will not work for my situation. I also need some sort of list for the user to choose from. I am pretty close to coming up with what I need using a command statement. I just need to solve the issue of the parameter showing up...

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

Thanks for the help, it worked great! Jen

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

This helps get me to a presentable format. Thanks so much!

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

Thank you for your reply. I tried what you advised and get the error "An array's dimension must be an integer between 1 and 1000" Any other suggestions? Jennifer

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