preloader-matrix

Alfasith

How to add company logo into query based report

Hi, 
Please follow following steps.
There are many ways to bring the Company logo in SSRS report.
1. Adding Bidmap EDT  to the tempTable and in passing below code in DP class
Companyimage::findByRecord(CompanyInfo::find()).Image;
2. In the query based reports there are 2 ways.
A. Adding CompanyImage table to the parent query and add dataAreaID as range to that query make relation by DataAreaId
1.  Create new query with CompanyImage alone and add dataAreaID as range to that query 
In either cases add that dataset in Report by selecting particular query in the property DataSourceType  :Query.
2. Make dynamic query : false
3. You will find the parameter added 
4. Change the property of paramters CompnayName_dataAreaId : Default Value
5. Select Non-queried
6. Select the expression as parameter and AX_CompnayName (double click) then OK.
7. Add the image in header or anywhere in design
Use this filed property : =First(Fields!Image.Value, “CompanyImage”).
Select the format of image you have and run the report.

One Response

Leave a Reply

Your email address will not be published.