September 3, 2003 at 11:10 am
Hello
We need to store Image data in our database to be pulled up and displayed on crystal reports. But by doing this there is a lot of oevrhead when we run the reports. Is there a better way to do this with crystal reports and image data ?
Thanks
Aruna
September 3, 2003 at 12:48 pm
Pesonally I like storing them in the filesystem and then retrieving them with the path from the db. Not sure if Crystal can do this. Another alternative is to store in a separate db and then link to the first db. Could speed things up especially if you can separate the IO out.
Steve Jones
September 4, 2003 at 1:01 am
quote:
Another alternative is to store in a separate db and then link to the first db. Could speed things up especially if you can separate the IO out.
that's what I do here.
LOB's in one DB, the rest in another. Work good for me.
I assume you want to show some kind of company logo or that kind on your report, right?
And you what to keep it flexible, so you don't need to change this for each installation, right?
So if the images hopefully will not be very large in size and overhead shouldn't be too big.
Not sure, if you can assign via source code the path to your images, which could be retrieve from the db, to a picture box, or what is equivalent in Crystal Reports.
I know this technique works on VB forms, but I have no experience with Crystal Reports.
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply