We have just installed Crystal XI and have changed some reports to use blob fields in a subreport(from a sql database) to insert images on a report vs. OLE Objects (directly on the main report). We use RDC and OLE DB Datasource to connect to a SQL database.
Upon testing exporting PDF files, we noticed that the PDF file size has increased dramatically and performance is poor. The file size pre-blob field is about 384kb and takes about 2 minutes to run. With the blob field, the file size is about 2600kb and takes about 17 minutes to run.
We also tried the Excel (full and data only) as well as Export as a RPT (Crystal Report) and the sizes and speeds are comparable using the OLE Object vs the blob field.
Has anyone else come across this? Were you able to resolve? Do we need to change a process somewhere?
Upon testing exporting PDF files, we noticed that the PDF file size has increased dramatically and performance is poor. The file size pre-blob field is about 384kb and takes about 2 minutes to run. With the blob field, the file size is about 2600kb and takes about 17 minutes to run.
We also tried the Excel (full and data only) as well as Export as a RPT (Crystal Report) and the sizes and speeds are comparable using the OLE Object vs the blob field.
Has anyone else come across this? Were you able to resolve? Do we need to change a process somewhere?