Hi All,

What do you do when you need to display different logos in reports for different customers without redesign it ?

One option is to save a different RPT for each customer and insert the customer LOGO. The problem is that you end up with many templates for the same report one for each customer.

A better option is to use dynamic links so you can have one RPT file that will display different pictures according to different paths.

Follow this steps to use a dynamic link in RPT reports:

First you need to insert a picture into the report and set it’s size.

/wp-content/uploads/2015/11/11_836248.gif

Use a query to get the file path. for example:

select BitmapPath as path, LogoFile as pictureName ,cast (BitmapPath as nvarchar )+LogoFile as FullPath from OADP

this query will take the file path from the “Pictures Folder”  in the general settings of SBO and the picture name from Print Preferences of SBO.

B3.jpg

  B4.gif

Add the query into command. The FullPath field represent the file location.

B6.gif

The next step will be to enter “Format graphic” (Select the picture and right click on the mouse)

Select the “picture” tab and open the “Graphic Location”

B7.jpg

select the FullPath field from the command and save

B8.gif

Now ,Every time the “Picture Folder” or the picture in “Print Preferences” in SBO is changed ,the report will display the correct LOGO automatically without any intervention.

B9.gif

Good Luck

Shachar

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply