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

QuickFix: [Solved] SSRS Report Deployment failed - The number of defined parameter is not equal to the number of cell definitions in the parameter panel

While duplicating an SSRS report for customization sometimes you may face this error at the time of report deployment. 

Error Message:

"SSRS Report Deployment failed - The number of the defined parameters is not equal to the number of cell definitions in the parameter panel."

Solution: 

The first thing you need to check for any extra parameter is this report, compare with the standard report. There are two places you need to compare

1. DataSet parameters

2. Report Parameter

There might be an extra parameter(s), try to remove this extra parameter from the report. In case you are unable to delete it from the front end you need to open the report in XML (Right-click on the report in solution and select open with > Open with XML Text editor).

In the XML file search for this parameter and carefully remove it from everywhere. If you are not familiar with XML better to take help. Save your changes and build the solution. This time your report should be deployed without any error. 

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