Question about pulling data out using CR

[ernstmik]

If images and pdf files are stored in a database, can they be accessed by Crystal Reports?

 

[dgillz]

In regards to images, Yes. At least from version 7 and newer this is the case.

Also, starting with version XI, it is not necessary for the image itself to be in the database, all you need is the path to the image.

I cannot say for .pdfs.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[synapsevampire]

Depends on the Crystal version, database and how they are stored.

Your question is the equivalent of asking if computer files can contain things...

Post specifics, including your software version, database, data types used to store the images and PDFs, and how they are stored fields, etc.

-k

 

[ernstmik]

Most of the details are to be determined. It most likely will be an Oracle database but unfortunately, the team that wants to do this, is still in theoretical mode and hasn't made it that far along. Having said that, is there one data type that works best for images and PDFs that I could let them know about when they go about creating the database?

Thanks.

 

[synapsevampire]

Again, that depends upon the database and version of Crystal.

People tend to store such things in Oracle BLOB or Long Raw data types, and newer versions of Crystal can work with that.

As dg states, you can also just link to them.

Here's some reading material:

http://support.businessobjects.com/...f#search='image oracle field crystal reports'

-k

 

[FishyBC]

I am trying to access data for a report using stored procedures in MS SQL Server. I have a main report that provides job details and a linked subreport within it that provides the processes that were performed (general information). I want to get access to process detail information that is only available in a 2nd process detail stored procedure.

So far I have found out that Crystal does not support a subreport within a subreport, that you can only get at the first result set within a stored procedure and I also found out that you cannot join 2 stored procedures together based on a common key.

How can I get at this data if I need to access it from 2 different stored procedures at the same time ?

Thanks for any thoughts
FishyBC