Click to See Complete Forum and Search --> : software developer
afsar Khan
May 27th, 2009, 07:11 AM
hi sir, y
i want to display picture in crystal report 8.5 i m using vb 6 as front end access as back end
i have stored picture name in my database field type is text not ole i have stored all jpg in folder and calling that picture in my vb form now i want to display the related picture of student in result please help its urgent
i'm not aware about crystal designer
i'm using .rpt method i have downloaded the zip related to picture display from your site
but in that you are using crystal designer. please how i will display picture in .rpt method.
Thanks a lot it's urgent sir.
jawadhashmi
May 28th, 2009, 01:12 AM
I think there was no control or direct way of placcing the images in CR8.
But there is a direct way in 10 or 11 to load the images from the file system by just passign the file path.
Any how now you have to use the BLOB filed and from application read and store the image as bites and put in the BLOB field and pass it to the report, on report side drag and drop that field on the report designer adjust it position and size.
afsar Khan
May 29th, 2009, 06:18 AM
I think there was no control or direct way of placcing the images in CR8.y
But there is a direct way in 10 or 11 to load the images from the file system by just passign the file path.
Any how now you have to use the BLOB filede and from application read and store the image as bites and put in the BLOB field and pass it to the report, on report side drag and drop that field on the report designer adjust it position and size.
Dear jawad first thanks for your kind reply
first help me about this that what is BLOB and will you provide example of above method
and how i will store the image in table as bite field because my picture name is in text format becasue the client has stored the picture name of student as a same to student name.
once again thanks
jawadhashmi
June 1st, 2009, 12:06 AM
Mr Khan,
I have no idea how you are generating the data for the report.
BLOB stands for Binary Large Object to store the binary data in Database.
My usual practise is to generate the data in XML format using C# code and then pass that data to the report to show. We design the report using xml schema. You can define the database schema in schema.
Get the image path from the database and read the image as binary and store it in the xml and pass it to report.
Making an example is little difficult.
Try your self if not possible then I will try to make one for you.
jggtz
June 1st, 2009, 11:54 AM
AFAIK, The only ways to put images in a CR's rpt are:
1.- Design time
2.- Running time, reading it directly from a file's field
3.- Running time, loading by code (only with CR Designer)
codeguru.com
Copyright WebMediaBrands Inc., All Rights Reserved.