I have image fields imbedded in a sql database. I thought it might be more effecient to instead imbed the file location (i.e. "c:\\pictures\image1.gif"). Then I want to in a CR formula change the dummy ole object file(on the report) location to the immbedded file location "c:\\pictures\image1.gif". Each record could have a different imbedded file location. I'm using CR 8.0, windowsXP, and SQL 2000.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
can you use "VBA" code with crystal?
- Thread starter duckyboyz
- Start date
hey duckyboyz,
It can't be done as far as I am aware - CR can only drag information from a datasource - actual files it cannot.
The way I have been successful in this is to store the pics in a db - and then place the image field on your report - which will dynamically change according to the records returned.
I do believe there is third party software that can do what you are requesting but I have no idea where or whom supplies it.
Perhaps another tipster could shed some light ?
I hope this helps
paulmarr
It can't be done as far as I am aware - CR can only drag information from a datasource - actual files it cannot.
The way I have been successful in this is to store the pics in a db - and then place the image field on your report - which will dynamically change according to the records returned.
I do believe there is third party software that can do what you are requesting but I have no idea where or whom supplies it.
Perhaps another tipster could shed some light ?
I hope this helps
paulmarr
- Thread starter
- #3
thanx paulmarr... I'm doing what you suggested now. The only problem is, is when the report returns a substantial number of records, each with at the most 2 signatures (which are jpegs). The report really bogs down. I was looking for a more effecient way of processing a substantial number of records.
duckyboyz,
Have you tried putting the signatures in a subreport - and place the subreport as a hyperlink (on demand subreport - right click on subreport - format subreport - subreport tab)
that way - the report will run quickly and the user can click on the link if they wish to see the signature?
It will run fast as it is not picking up the images unless the hyperlink is clicked.
Cheers,
paulmarr
Have you tried putting the signatures in a subreport - and place the subreport as a hyperlink (on demand subreport - right click on subreport - format subreport - subreport tab)
that way - the report will run quickly and the user can click on the link if they wish to see the signature?
It will run fast as it is not picking up the images unless the hyperlink is clicked.
Cheers,
paulmarr
- Status
Similar threads
- Locked
- Question
- Locked
- Question