Notifications
Announcements
No record found.
Dear All,
How to add company photo and Address to generated reports during analysis.
*This post is locked for comments
Check standard sales invoice layout.
Hi vishwas_mmmec,
1º - In your company info load a image.
2º - In the report create a global record of company information (table 79)
3º - In the trigger OnPreReport you need do a get and CALCFIELDS of the picture field of company Information
RecCompanyInfo.GET
RecCompanyInfo.CALCFIELD(picture);
4º - In the dataitem add the RecCompanyInfo.Picture to pass to the layout
In the layout create a control type image, select your image and set mimetype.
If you have doubts review standard report 206 has said Manish Sharma.
Regards!
Hi,
Please have a look at the following post:- community.dynamics.com/.../nav-2013-and-nav-2013-r2-add-image-in-report- dynamicsuser.net/.../adding-company-logo-to-reports- community.dynamics.com/.../180839
Hope you will find the answer from there, but if not let me know. Thanks
refer this
msdn.microsoft.com/.../hh165871(v=nav.70).aspx
yes I upload company logo to the company profile page, but still it not shows in reports.
this is from MSDN help
In Report Dataset Designer, select a DataItem. In the dialog box that states that the layout of the report is changed by another application, choose the Yes button.
In Report Dataset Designer, right-click the Cust. Ledger Entry DataItem, and then choose New to create a new row at the bottom of the Customer DataItem.
In the new row, in the Data Source field, choose the AssistEdit button to open the C/AL Symbol Menu window.
In the leftmost box, select CompanyInfo. In the middle box, select FieldName. In the rightmost box, select Picture. Choose the OK button.
In the Name field, enter Picture.
On the View menu, choose C/AL Code.
In the C/AL Editor, in the OnInitReport Trigger, enter the following code.
CompanyInfo.GET; CompanyInfo.CALCFIELDS(Picture);
Close the C/AL Editor, save the report, and then compile the report.
On the View menu, choose Layout.
In Visual Studio, on the View menu, choose Toolbox.
In the Toolbox pane, drag the Image control to the header section of the report. Put the control where you want the company logo to be displayed, and then choose the OK button in the Image Properties window. Resize the image to the desired size.
Select the image control, in the Properties pane, in General node, set the following properties.
MIMEType
Image/bmp
Value
=First(Fields!Picture.Value, "DataSet_Result")
Source
Database
Under Size, set the Sizing property to FitProportional
On the main menu, choose Build, and then choose Build Web Site to build the project. Review the Output pane, make sure that there are no build errors, and then close Visual Studio.
Thanks.
There are many standard Reports from where you can take in help from. Please check and come back to us if still unable.
I am positive you will do by yourself.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
HoangNam 7
