Microsoft Dynamics AX

Forums

Home » Microsoft Dynamics AX » Microsoft Dynamics AX Forum
Related Search Results

Dynamics AX 2012 Reporting: How to add company logo into query based report

by
on 6 Dec 2012
  • 0 comments

How do I embed images in a html mail template (Ax2009)

by
on 7 Oct 2010
  • Suggested Answer

Debug IL code from VS

by
on 2 Apr 2013
  • Suggested Answer
Troubleshooting an Issue?

Our support engineers have assembled the top recommended solutions for you.

Microsoft Dynamics AX 2012

CRM Connector in Microsoft Dynamics AX 2012

Financials Management in Microsoft Dynamics AX 2012

Upgrading to Microsoft Dynamics AX 2012


Microsoft Dynamics AX 2009

Application Object Server (AOS)

Enterprise Portal and Role Centers

Inventory Costing in Microsoft Dynamics AX 2009 

 Invoice Settlements/Discounts/Reversals

 SSRS and SSAS Integration

 Workflow

Add Company Logo Into Report Design

This question is answered
Hanny_Gaoxing
Posted by
on 27 Jun 2012 11:46 PM

Hello everybody,

i have a problem with my reports in dynamics ax 2012. i want to customize a standar reports by adding a company logo as header report. the report design by html code, ex class HcmSkillGapByJobSkillHTMLGenerate. i took company logo from companyImage table so i dont need to add image into resources. i already add html tag (img src = 'image name') but its not work. report not display company logo.

any body can help me to solve that problem?

thanks you

 

Hanny
Verified Answer
  • Fx
    Posted by
    on 29 Jun 2012 5:09 AM
    Verified Answer
    Verified by

    Hi,

    I will present you a solution that I've done to customize a report. I use a DataProvider class on the Dynamics AX Side with a TmpDB table.

    1. Add the Bitmap Extended Data Type to my table.

    2. In the ProccesReport method of my DataProvider class, I populate that field with the CompanyLogo but only on the first record (before going in the while/for/query statement.

    In the VisualStudio side:

    1. Add a Image

    2. set the source from your DateSet and use the method "=First(dataset.field)" to take only value from the first record.

    The advantage is to not duplicate le logo on each record of your TmpTable.

    If you don't use a DataProvider class, you can try to make some join table in yourQuery objet. (use dataAreaId field to join the CompanyInfoTable ).

    Best regards

    Fx
All Replies
  • Fx
    Posted by
    on 29 Jun 2012 5:09 AM
    Verified Answer
    Verified by

    Hi,

    I will present you a solution that I've done to customize a report. I use a DataProvider class on the Dynamics AX Side with a TmpDB table.

    1. Add the Bitmap Extended Data Type to my table.

    2. In the ProccesReport method of my DataProvider class, I populate that field with the CompanyLogo but only on the first record (before going in the while/for/query statement.

    In the VisualStudio side:

    1. Add a Image

    2. set the source from your DateSet and use the method "=First(dataset.field)" to take only value from the first record.

    The advantage is to not duplicate le logo on each record of your TmpTable.

    If you don't use a DataProvider class, you can try to make some join table in yourQuery objet. (use dataAreaId field to join the CompanyInfoTable ).

    Best regards

    Fx
  • AlexO85
    Posted by
    on 7 Jan 2013 5:16 AM

    Hi Fx,

    Your suggestion of using the DataProvider class was implemented when our system was deployed. I would now like to change the logo in the report. How can I change the bitmap/image in the temp table please? Thanks in advance.

    Alex
  • Fx
    Posted by
    on 7 Jan 2013 7:15 AM

    Hi,

    The TmpTable is fill each time you call your report. No data was store in it.

    When you call your report, the fields are fill in the ProccesReport method (Step 2 in my previous answer).

    So in your current version your Logo may come from the following table field CompanyInfoTable.CompanyLogo.

    For example you have some code like this:  myTmpTable.logoField = CompanyInfo.CompanyLogo;

    So if you want to change it, you can :

    • Change the companyLogo in your company parameters
    • Modify your ProcessReport to modify the source of the Bitmap to take it from another source.

    Happy New year !

    Fx
  • AlexO85
    Posted by
    on 8 Jan 2013 4:07 AM

    Thank you Fx. That worked great!!! Happy New year to you too :)