Skip to Content
author's profile photo Former Member
Former Member

OLE WORD

Hi,

I have a problem with Crystal Report 2008.

I have add an OLE Object I select the existr file and I check LINK, when I change the file I don't see a change in a Crystal Report.

I have anothe problem with the OLE object, I post the path in picture Tab but the I see the same object, not is different??

Why??

What is my error, please help me and sorry for my English.

Serena

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 10, 2008 at 02:23 PM

    Do you get any error message when you run the report?

    How did you link and what did you link to the OLE object. Does your OLE object sets within the page range? i.e. width/length?

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 10, 2008 at 02:25 PM

    change the file, do you mean you set the location for the dataset on the report?

    are you modifying the stored procedure.

    when you do that you need to verify the database within crystal for it to recognize the changes. you will be prompted that the procedure has changed, this should bring in your updates

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      No I don't have a message error.

      I discover that If I post a path ina Picture tab to an immage es "c:\Temp\a.jpg", i see a change, if I path a doc es "c.\Temp\doc.docx" I don't see a change.

      Is it a my problem or a crystal problem??

      Serena

      P.S. I solved delete and copy file for refresh the information.

      Thanks

  • author's profile photo Former Member
    Former Member
    Posted on Nov 10, 2008 at 02:49 PM

    Hi Serena,

    Following are the steps to create a report, which is called as Dynamic Image Location.

    1. First Create a Parameter named "Image" and link a particular database field to the Image. (There should be one database field which will have the path of the Image stored in it.)

    1. Go to Insert Menu > OLE Object, click the "Create from File" radio button.

    2. Browse the image path where it is stored. (Eg., C:\Program Files\Business Objects\Crystal Reports 11.5\Samples\Images\Competition.jpg). Then click OK.

    3. Right Click on the OLE object, Go to Format Graphic, Picture Tab. In the Graphic Location X+2, Formula Workshop Editor, write the formula,

    if {tablename.fieldname} = {?Image} then

    "C:\Program Files\" + {tablename.GraphicImageLocation}

    where {?Image} - is the parmeter created and used in the formula.

    {tablename.GraphicImageLocation} - is the database field which has he path of the Image.

    {tablename.fieldname} - is the field from the database to which the Image is linked

    4. When the report is refreshed, it prompts for the parmeter value, (which is linked to the image). and after selecting the value, the image corresponding to the value is displayed in the report.

    Regards,

    Abhijeet Taskar.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.