Search results for query: *

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

Hi Thanks very much - way easier than I was anticipating! My only problem now is that this is to be a download report and it seems that data elements from the subreports aren't exporting to the format I choose. I've tried Excel, TSV, and CSV. Can anyone indicate what the issue is? Is this...

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

Hi Thanks for the suggestions. The database is hospital abstracting software programmed in C++. Is there any way to minimize the creation of formulas using arrays/variables? For instance, right now I create 4 formulas for # of cases, 4 for number of days, etc. As per Madawc's suggestion I...

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

Hi Thanks for the suggestion but it still isn't working - same characters show up. Anyone else? S.

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

You are the absolute greatest!!! A big huge star to you! (as you can tell from my reaction it worked!!) I also want to thank you for your efforts on this site - you must visit thie site daily, ALWAYS answers questions and are very polite and positive while doing so. You never make people feel...

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

Hi Sorry but I still can't get this to work. For surname I create the field of LastName using: Split({ACABSTRACT.PATIENTNAME},",")[1] Then I create the fixed length field of LName: numbervar requiredlength:=25; numbervar currentlength:=length(trim({@LastName})); if...