OLE WORD

[Former Member]

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

[Former Member]

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.

[Former Member]

I try to make with your istruction but I don't see a file word than I selected in a parameter...

Serena

[Former Member]

Hi Serena,

Do you have the Xtreme sample Database, that comes shipped with the Crystal Reports. If yes create the ODBC(RDO) connection and use the ' Product_Type ' table to to create this sample report.

Create a static parameter "Image" and use the database field "Product ID" to create this parameter.

Use this parameter in the formula that is created from the Picture Tab > Graphic Location X+2.

Please let me know if you have any queries.

Regards,

Abhijeet Taskar.

[Former Member]

Thanks for your interest.

Now I have resolve my problem

Thanks

Serena

[Former Member]

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

[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

[Former Member]

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