Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Wednesday, October 24, 2018

Print HTML tags as run value in SSRS 2012 R3 / D365

Hi,

1. Select the text filed.
2. Click on the expression /  filed values (right click)
3. Select placeholder properties.
4. General tab  > Markup type > HTML as style.


Regards,

Tuesday, October 23, 2018

Deploy all the report in CMD for D365

Hi,

1. Run the powershell command prompt as administrator.
2. Paste the code for specific reports.
here my sample is PurchPurchaseOrder.Report

K:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeployAllReportsToSSRS.ps1 -Module ApplicationSuite -ReportName PurchPurchaeOrder.Report -PackageInstallLocation “K:\AosService\PackagesLocalDirectory”

3. To deploy all the reports.

K:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeployAllReportsToSSRS.ps1 -PackageInstallLocation “K:\AosService\PackagesLocalDirectory”


Regards,

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...