[Solved] Parameter issue with SSRS report

If you are reading this post, my humbly empathy with you, you are one of the victims of the SSRS report. :)

I am not diving on exact error messgae you may getting while build/deploying report. 

Lets understand the root casue of this first, 

..

.

.

.

.

.

.

.

.

.

.

.

.

.

There is no root cause. Its just SSRS, 

Well, if you open SSRS report in XML editor (by right click on report and Open with), you will total two place where parameters are defined. (In case there is one datasource in report, there be more place if there are more than one datasource)

Take a close look on all three and makre sure all of them having same number of paramters , plus same name of each paramater.

1. Under node: Report dataset parameter

2.  Under node : ReportParametersLayout, 

well, this one is reall yintesting as you also needs to make sure of changing the ColumnIndex or RowIndex.

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

QuickFix: Company doesn't exit error on report

In my case it was an issue with the wrong extends of the contract class (of course this happened because of poor copy-paste skills :) ) Check the contract class if you have extended with the SrsReportRdlDataContract class, instead of this you need to add DataContractAttribute on top, that it.

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

Supercharging Dynamics 365 F&O implementation with Azure DevOps

Hi Folks, 

Here is the recording of the session delivered on 31st August, it primarily targeted below topics, 

and of course an interactive demo around those topics, 

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

QuickFix: Error while build SSRS report

Error Message:

Severity Code Description Project File Line Suppression State

Error Path: [AxReport/<ReportName>]:"An unhandled exception was thrown while validating <ReportName>with callstack System.InvalidOperationException: Sequence contains no matching element

   at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate)

   at Microsoft.Dynamics.AX.Metadata.Extensions.Reports.AxReportDataSetParameterExtensions.GetAssociatedReportParameter(AxReportDataSetParameter datasetParameter, AxReport report)

   at Microsoft.Dynamics.AX.Metadata.Validation.DataSetParameterConstraint.Validate(ModelValidationContext context, AxReportDataSetParameter element)

   at Microsoft.Dynamics.AX.Metadata.Validation.AxReportValidator.ValidateDataSets(AxReport report, ModelValidationContext validationContext)

   at Microsoft.Dynamics.AX.Metadata.Validation.AxReportValidator.DoValidate(AxReport report, Uri uri, IMetadataProvider metadataProvider, IDiagnosticSink diagnostics)

   at Microsoft.Dynamics.AX.Metadata.Validation.ValidatorBase`1.StartValidation(T objectToValidate, Uri uri, IMetadataProvider metadataProvider, IDiagnosticSink diagnostics)."

Fix: Sorry to say in this way, but simply create a completely new report and copy the design from the current to the new report, this should work.

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta