Tuesday, March 21, 2017

Add Lookup Method for Dimension fields for UI Builder class in Axapta SSRS

To Add Lookup Method for Dimension fields like division ,branch etc using UI Builder class in Axapta SSRS Report you can refer below code.

  #define.DimensionName("Branch")  
   Query          query;  
   QueryBuildDataSource  qbds,qbds1;  
   SysTableLookup     sysTableLookup;  
   DimensionAttribute   dimAttr;  
   ;  
   dimAttr = DimensionAttribute::findByName(#DimensionName);  
   sysTableLookup = SysTableLookup::newParameters(tablenum(OMOperatingUnit),branchCodeLookup);  
   sysTableLookup.addLookupfield(fieldnum(OMOperatingUnit, OmoperatingunitNumber));  
   sysTableLookup.addLookupfield(fieldNum(OMOperatingUnit,Name));  
   query = new Query();  
   qbds = query.addDataSource(tableNum(OMOperatingUnit));  
   qbds.addRange(fieldNum(OMOperatingUnit, OMOperatingUnitType)).value(queryvalue(OMOperatingUnitType::OMBusinessUnit));  
   sysTableLookup.parmQuery(query);  
   sysTableLookup.parmUseLookupValue(False);  
   sysTableLookup.performFormLookup();  

Division dimension lookup method is as below.

 private void divisionCodeLookup(FormStringControl divisionCodeLookup)  
 {  
   #define.DimensionName("Division")  
   Query          query;  
   QueryBuildDataSource  qbds,qbds1;  
   SysTableLookup     sysTableLookup;  
   DimensionAttribute   dimAttr;  
   ;  
   dimAttr = DimensionAttribute::findByName(#DimensionName);  
   sysTableLookup = SysTableLookup::newParameters(tablenum(DimensionFinancialTag),divisionCodeLookup);  
   sysTableLookup.addLookupfield(fieldnum(DimensionFinancialTag, Value));  
   sysTableLookup.addLookupfield(fieldNum(DimensionFinancialTag,Description));  
   query = new Query();  
   qbds = query.addDataSource(tableNum(DimensionFinancialTag));  
   qbds1 = qbds.addDataSource(tableNum(DimensionAttributeDirCategory));  
   qbds1.addLink(fieldNum(DimensionFinancialTag,FinancialTagCategory),fieldnum(DimensionAttributeDirCategory,RecId));  
   qbds1.addRange(fieldNum(DimensionAttributeDirCategory, DimensionAttribute)).value(queryvalue(dimAttr.recid));  
   sysTableLookup.parmQuery(query);  
   sysTableLookup.parmUseLookupValue(False);  
   sysTableLookup.performFormLookup();  
 }  

You can call lookup method on post build method in UI Builder class.

  dialogregion.registerOverrideMethod(methodStr(FormStringControl, lookup), methodStr(GOD_CustomerOutstandingUIBuilder,regionCodeLookup), this);  
   dialogbranch.registerOverrideMethod(methodStr(FormStringControl, lookup), methodStr(GOD_CustomerOutstandingUIBuilder,branchCodeLookup), this);  

You need to call contract object in following method.

 public void getFromDialog()  
 {  
   contract = this.dataContractObject();  
   super();  
 }  


Sunday, March 12, 2017

Form development from Basic level Microsoft dynamics ax 2012 R3

This post include Form Design and development using primary key and foreign key table relation in Microsoft Dynamics Axapta. 2012 r3 Module.

How to Add primary key in table first you need to create unique key field let id is key field name for your table.

Add index with allow duplicate no property to make it unique key .

then add relation in tables(foreign key and primary key) as shown in below video clip.

Create another table for foreign key relation then add normal relation in second table.

To show data in form Add table to form datasource and set required properties in data source as shown in clip.

You seen how its works table data on form .





Thanks for viewing and watching if you like it please subscribe to get next video update and learning.

Tuesday, March 7, 2017

Basic technical fundamental in Ax 2012 online training clip

Basic technical  Demo for Ax form development and table creation
1. How to create project
Go to AOT CTR+D->Project->Shared project->create project then rename it using properties.
2. How to create table
Go to table node and create table as shown in below clip.
3. How to create form In Ax
Go to form node and create formas shown in below clip.
4. Add form to menu item as below clip
Thanks for viewing this if you like then please subscribe on YouTube .
On next post will show form with related tables.





How to pass default value to parameter using SSRS Class in axapta

To pass default value to parameter using SSRS Class in axapta 2012 you can override method prePromptModifyContract in controller class then initialize contract class variable then you can pass value using contract class method calling.

Below is example sample for syntax is mentioned.

 protected void prePromptModifyContract()  
 {  
   Contract=this.parmReportContract().parmRdpContract() ;  
   Contract.parmDetails(DiscCurrency::Currency);  
   super();  
 }  

Wednesday, February 15, 2017

How to Deploy SSRS Report without Admin right From Command prompt

You may face below error if you don't have admin right from ax report  deployment.

An error occurred : The network path was not found.

1.If User Account Control (UAC) is enabled on the machine, close the application, right-click the application, and then click Run as administrator.

2.The deployment was aborted. You do not have privileges to deploy to server: abcd. For deployment, you must have administrative rights to the SQL Server Reporting Services (SSRS) server. Contact your administrator to deploy.


To Deploy SSRS Report without Admin right . You can follow below steps.

For single report deployment.

Open Dynamics Management shell and write deployment command like below.

Publish-axreport -reportname vend –SkipReportServerAdminCheck

To Deploy all report  Try below code

Publish-AXReport –ReportName * -SkipReportServerAdminCheck

Same you can see practical on below youtube video clip.