Ali Raza Zaidi

A practitioner’s musings on Dynamics 365 Finance and Operations

Dynamics Ax 2012 development 2

Serial Number in Report Group SSRS Dynamics Ax 2012 R3.

by

Today I have small tip. Let me share a scenario. Suppose you have to display Customer group as report level group and customer at detail level who did purchased products from your organization in given period of time.

Serial number on detail level can be achieved by RowNumber(“Scope Name”)

But serial number shown on Group level is tricky because RowNumber not works there. For example in above mention scenario, Client wants serial number on Customer Group instead of Customer at detail level.

I used following single line SSRS expression helps me to achieve this.

=Runningvalue(Fields!FieldName.Value,countdistinct,”Dataset1″)

Dynamics Ax View :You are not authorized to access table. Contact your system administrator.

by

Yesterday, I got error when I run the view which created on “” table  in Dynamics Ax 2012

9-9-2014 12-20-34 AM

“You are not authorized to access table ‘VBankLCImport’ (VBankLCImport). Contact your system administrator”.

Error was misleading because in development environment User have full access rights. And this error is not appear while running any view.

I also reset the license key, but problem does not resolve.

Finally it revealed that this error appear due to no field is added inside the view. I select the one key and drag and drop on fields in view section. Then right click on view. It successfully show me the values.

9-9-2014 12-21-42 AM