Results 1 to 22 of 22

Thread: [RESOLVED] Loading picture dynamically to the crystal report

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Location
    India, Kerala, Calicut
    Posts
    242

    Resolved [RESOLVED] Loading picture dynamically to the crystal report

    Am saving picture file as picture itself in a folder and saving its path to a feild in a table. Now i want to load the picture to my crystal report.

    Pleaseeeee help me

  2. #2
    Hyperactive Member
    Join Date
    Jul 2010
    Location
    UK
    Posts
    288

    Re: Loading picture dynamically to the crystal report

    Select a Picture and put it on your report. Does not matter what the picture is.

    Once you have that on your report
    Right Click and Select the Format Object
    Select the Picture Tab
    Click on X2 next to Graphic Location and here select the field that holds the details of the photo you need to load.


    Refresh your report.
    One day I found VB.
    Now I live in the state of Confusion.

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Location
    India, Kerala, Calicut
    Posts
    242

    Re: Loading picture dynamically to the crystal report

    I did that..but it showing the picture which is loaded at the first time

  4. #4
    Hyperactive Member
    Join Date
    Jul 2010
    Location
    UK
    Posts
    288

    Re: Loading picture dynamically to the crystal report

    How many records are there in the table you are selecting the path from and are you only selecting one record. What is that field showiing and is there a picture in that location.
    Also check that the report has been refreshed.
    One day I found VB.
    Now I live in the state of Confusion.

  5. #5

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Location
    India, Kerala, Calicut
    Posts
    242

    Re: Loading picture dynamically to the crystal report

    Am trying to load 3 diffrnt pictures to 3 diffrnt picture boxes. There is pictures on the path. I tried it with many times after refreshing and all but still the same problem

  6. #6

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Location
    India, Kerala, Calicut
    Posts
    242

    Re: Loading picture dynamically to the crystal report

    in formula feild am simply puting
    Code:
    {FOOT_TMP.IMG_SIGN1}
    is here any problem the way am giving the formula?

  7. #7
    Hyperactive Member
    Join Date
    Jul 2010
    Location
    UK
    Posts
    288

    Re: Loading picture dynamically to the crystal report

    That looks fine what you need to check is what record is being displayed from that field. How many records are there in that table and if there is more than one how does it know which record to choose from.
    One day I found VB.
    Now I live in the state of Confusion.

  8. #8

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Location
    India, Kerala, Calicut
    Posts
    242

    Re: Loading picture dynamically to the crystal report

    There are one row in the table and from three different feilds the data will be called by. Three formula will be like this
    Code:
    {FOOT_TMP.IMG_SIGN1}
    {FOOT_TMP.IMG_SIGN2} 
    {FOOT_TMP.IMG_SIGN3}
    I will tell u exactly how am doing.
    Am inserting one picture to the page footer
    right clicking on it and selecting format graphic
    going to the Hyperlink tab
    and clicking on the option "From file"
    the text box below to that will be enabled and am clicking on the X+ button and adding the above feilds.
    But after doing all these when am re-opening format graphic. In hyperlibk tab it still enabled the option "A web site on the internet" instead of "A file"..
    i dnt knw what to do next...:-(

  9. #9

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Location
    India, Kerala, Calicut
    Posts
    242

    Re: Loading picture dynamically to the crystal report

    The record in the table (on that particular field) is the following
    Code:
    J:\sap\2\Sign.jpg

  10. #10

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Location
    India, Kerala, Calicut
    Posts
    242

    Re: Loading picture dynamically to the crystal report

    Even after am directly copying the same link to the formula field (with and without double quotes)..its not displaying the picture

  11. #11

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Location
    India, Kerala, Calicut
    Posts
    242

    Re: Loading picture dynamically to the crystal report

    am using crystal report 8.5.

  12. #12
    Hyperactive Member
    Join Date
    Jul 2010
    Location
    UK
    Posts
    288

    Re: Loading picture dynamically to the crystal report

    No you are trying to insert filepath into a Hyperlink that will not work.

    Go back one step.

    And do as I said before as copied below:

    Once you have that on your report
    Right Click and Select the Format Object
    Select the Picture Tab
    Click on X2 next to Graphic Location and here select the field that holds the details of the photo you need to load.


    Refresh your report.

    You should find that will work.
    __________________
    One day I found VB.
    Now I live in the state of Confusion.

  13. #13

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Location
    India, Kerala, Calicut
    Posts
    242

    Re: Loading picture dynamically to the crystal report

    Am right clicking in picture box and its coming "Format Graphic"
    and when am going to "PIcture" tab, there is only one reset buttoon. No X2 or Graphic location. There is only the Left.Right,Top,Bottom and scaling options.

  14. #14
    Hyperactive Member
    Join Date
    Jul 2010
    Location
    UK
    Posts
    288

    Re: Loading picture dynamically to the crystal report

    Sorry Sanju,

    I no longer have Crystal 8.5 installed and I can't remember how it worked on that. It must be 10 years since I used Crystal 8.5. Is it possible to use a later version as Crystal themselves no longer support 8.5.
    One day I found VB.
    Now I live in the state of Confusion.

  15. #15

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Location
    India, Kerala, Calicut
    Posts
    242

    Re: Loading picture dynamically to the crystal report

    I checked it with version 10 also. there also 4 tabs.(common,picture,border,hyperlink). There also in picture only reset button

  16. #16

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Location
    India, Kerala, Calicut
    Posts
    242

    Re: Loading picture dynamically to the crystal report

    am checking the screen shots of format graphic in google. I can see the windows with Graphic location there. But here in my 8.5 and 10 version doesnt have that option. is there any way to disable/enable it?

  17. #17

    Thread Starter
    Addicted Member
    Join Date
    Oct 2008
    Location
    India, Kerala, Calicut
    Posts
    242

    Re: Loading picture dynamically to the crystal report

    The solution is here..
    Attached Files Attached Files

  18. #18
    Lively Member nilesh16782's Avatar
    Join Date
    Feb 2007
    Location
    India
    Posts
    104

    Unhappy Re: [RESOLVED] Loading picture dynamically to the crystal report

    plz help me ..
    i m using crystal report 9 and insert picture object -> select format graphic -> then select picture tab.. here 'graphic location ' option not showing..
    here Name:  ArticleImage.jpg
Views: 30797
Size:  45.3 KB is screeshot of graphic location.. this option is not showing in my crystal report 9..

    why..? plz help me

  19. #19
    New Member
    Join Date
    Mar 2013
    Posts
    8

    Re: Loading picture dynamically to the crystal report

    It is not working
    Quote Originally Posted by ConfusedAgain View Post
    Select a Picture and put it on your report. Does not matter what the picture is.

    Once you have that on your report
    Right Click and Select the Format Object
    Select the Picture Tab
    Click on X2 next to Graphic Location and here select the field that holds the details of the photo you need to load.


    Refresh your report.

  20. #20
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: [RESOLVED] Loading picture dynamically to the crystal report

    Post your Crystal Reports version
    @ConfusedAgain solution is for CR version 11 or later
    If your CR version is 10 or lower, did you try solution posted in post #17 ?
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...

  21. #21
    New Member
    Join Date
    Aug 2022
    Posts
    1

    Re: [RESOLVED] Loading picture dynamically to the crystal report

    Quote Originally Posted by jggtz View Post
    Post your Crystal Reports version
    @ConfusedAgain solution is for CR version 11 or later
    If your CR version is 10 or lower, did you try solution posted in post #17 ?
    Buenas, yo tambien tengo ese mismo problema, me he descargado tu archivo en el post #17 pero me pide una contraseña. Cual seria?
    muchas gracias, te agradezco si me puedes ayudar, llevo semanas buscando solución a poner imagenes dinamicas con crystal 8 o 8.5

  22. #22
    Super Moderator Shaggy Hiker's Avatar
    Join Date
    Aug 2002
    Location
    Idaho
    Posts
    37,578

    Re: [RESOLVED] Loading picture dynamically to the crystal report

    This is an English language forum. Google Translate turns that into:

    Hello, I also have the same problem, I have downloaded your file in post #17 but it asks me for a password. What would?
    Thank you very much, I appreciate if you can help me, I've been weeks...
    However, this thread is also nearly 10 years old, so you would likely be better off starting a new thread.
    My usual boring signature: Nothing

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width