Report catalog for Microsoft Dynamics AX [AX 2012]

Nice link from TechNet about Report catalog for Microsoft Dynamics AX 201, that tells you complete details about all reports available and helps you finding your actual reporting needs.

http://technet.microsoft.com/en-US/library/hh334471.aspx

Thanks, Happy Daxing.

 

“Parameter is missing a value” error running a report in AX 2012

Recently I came across an issue, I need to make a contract parameter to non mandatory, obviously the solution is to modify the allow Null, and Allow blank property to Yes through visual studio but it was not working for me even after couple of deploy. After investigation I found that changes are not reflecting on reporting server, not sure but may be because of Cache.

after Google I came across this strange but valid work around

Method I.

Force the update of the properties by renaming the parameter

1. Open the report for editing in Visual Studio.

2. Expand the Parameters node and rename the affected parameter to ParameterName1.

3. Set Allow Blank and Nullable to True if not already set.

4. Deploy the report.

5. Rename the parameter back to ParameterName.

6. Deploy the report.

 

Method II.

Recreate the parameter in Visual Studio and set the properties as required before deploying the report

1. In AOT, expand the SSRS Reports node, expand the Reports node and locate the report.

2. Right click on the report and select Delete. This will remove all customizations to the report from the current model/layer so make sure you create a backup if you think you might want to return to them.

3. Right click on the report and select Deploy element. You should now be at the point where you did not receive this error.

4. Open the report for editing in Visual Studio and refresh the dataset. The parameter will be created under the Parameters node. Do not deploy the report at this point.

5. Set Allow Blank and Nullable to True.

6. Deploy the report.

 

Method III.

Modify the properties of the parameter editing the report in the Reporting Services Report Manager

 

1. Open the report for editing in Visual Studio.

2. Expand the Parameters node and locate the affected parameter.

3. Set Allow Blank and Nullable to True if not already set.

4. Deploy the report.

5. Open Reporting Services Report Manager, in the Parameters properties page of the report, verify that Has default and Null check boxes are selected for the affected parameter.

6. Press Apply to save any changes.

 

AX Users using Powershell command

The following steps need to be performed within the Microsoft Dynamics AX 2012
Management Shell, which is the PowerShell with the AX PowerShell commands preloaded:

1. Open the Management shell.
‰‰ For Windows 8 or Windows Server 2012: Search for Management shell
and click on the result, Microsoft AX 2012 Management Shell
‰‰
For Windows 7 or Windows Server 2008: Open Administration Tools from
the Windows Start menu and open Microsoft AX 2012 Management Shell

2. Create an AD user for Binary\Josh by using the following command:

New-AXUser -AccountType WindowsUser -AXUserId Josh -UserDomain
“Binary.local” -PartitionKey initial Enabled -UserName Josh
-Company HHF

3. Disable user Josh by using the following command:
Disable-AXUser –AXUserId Josh

4. Enable user Josh by using the following command:
Enable-AXUser –AXUserId Josh –Server Zeus

5. Make Josh the system administrator by using the following command:
Add-AXSecurityRoleMember –AxUserId Josh –AOTName SysAdmin

%d bloggers like this: