Printing site logo on forms

[hkeric.wci (Haso Keric)]

Viable option for MC is also:

Printing site logo on forms

At this time the best method I have successfully used in several Multi-Company Environments is. Create Company_UD.LogoPath_c and since its on the Company table it will easily exist in RDDs. You can also then use it in BarTender, BAQ Reports etc… Add it to Company Config and give the Epicor Service Accounts or All Users Readonly access to the Logo UNC Path. [image] In SSRS / BarTender its then just about referencing the external image. [image] However the Key is that you put a fixed dime…

[Adam_Jones]

Haso don’t forget we also added a backup image for a default logo on the report. This was in case the one specified in the UD field in Epicor did not exist. A function was also added to the report’s code section to detect if the file part + file name existed. If this came back false then we would set the hidden properties on the backup image to FALSE.

[Michael_Ramsey]

The systems “Calling” Data Sets can give you calling user specific data to make decisions against without joining to other tables and can be used readily in the header and footer sections with First.

[PPEREZ (Pedro Isaí Pérez Cupul)]

I have a question, how do I add the Content field to the report builder? How calculated field or query field? If is a calculated field what would be the expression? I don’t quite understand this

Pd. English is not my native language

[teeraphongw]

I followed your method but the image doesn’t appear.

[fredmeissner]

We could never get this to work, so we just added all the images in SSRS and then used conditional logic to display the appropriate company logo.

[Moreno.Mauricio (Mauricio Moreno)]

This is what I did and is working perfectly for us:

• Under Report Data Definition, we added 2 new datasets (tables) and included fields as follows:
  • Image
    • Company
    • FileType
    • ImageFieldName
    • ImageID
  • FileStore
    • Company
    • Content
    • FileName
    • FileType
• Created the next Relationships:
  • JobHead to Image
    • Company = Company
    • PartNum = ImageID
  • Image to FileStore
    • Company = Company
    • ImageID = FileName
• Added the Part images to the Image Maintenance and named them the same as the main part for the Job Traveler.
• On the SSRS report I modified the JobHead dataset expression as follows (simplified the expression to show only related info):

="SELECT…
T10.ImageID, CASE WHEN T10.FileType = ‘.jpg’ THEN ‘image/jpeg’
WHEN T10.FileType = ‘.png’ THEN ‘image/png’
ELSE T10.FileType END as FileType , T11.Content

FROM JobHead_" + Parameters!TableGuid.Value + " T1
LEFT OUTer JOIN Image_" + Parameters!TableGuid.Value + " T10 ON T1.Company = T10.Company AND T1.PartNum = T10.ImageID
LEFT OUTER JOIN FileStore_" + Parameters!TableGuid.Value + " T11 ON T10.Company = T11.Company AND T10.ImageID = T11.FileName "

• Added the next fields to the dataset:
  • ImageID
  • FileType
  • Content
• Added Image to the report as follows:
  • Image source: Database
  • Use this field: [Content] – “=Fields!Content.Value”
  • Use This MIME Type: [FileType] – “=Fields!FileType.Value”

Is working perfectly for us. Try this and let me know if worked for you.