Our hospital has contracted with a projection company that studies our patients' demographics and compares them to the medical problems and outcomes for each case. I've had to write a rather large report that uses four subreports which distribute into formula driven fields in order to layout the data as requested. Roughly half of the fields are generated from the subreports In the end, the file contains around 110 fields for each patient. They request the file be generated for a years worth of data at a time, however I cannot get a file to be generated and exported for over a few days time. We're a small hospital, so the successful export only contains less than 100 records. Myself and our senior analyst have reviewed the file multiple times to ensure it's as streamlined as possible, but we still cannot get the file to export. The records generate in the status box, but we MAY gain 1% a day.
Is there anything we can do within crystal or in the link to the SQL database which would get us the data movable quicker? Does this behavior reflect on Crystal or perhaps the condition of the server (which we've had problems with before, but running crystal reports off of it has not been one).