Friday, July 16, 2021

D365FSCM : SSRS Report Deployment error

  Error statement:

"The number of defined parameters is not equal to the number of cell definitions in the parameter panel.
   at Microsoft.ReportingServices.Library.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Guid batchId, Warning[]& Warnings)
   at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)"


Reason:

As I have requirement to create same design like salesInvoice Design in SalesPackingSlip,So I copy the design element and paste in SalesPackingSlip report > Design > Report_custom.

It will copy not only the design ,it will copy the parameters field which will be present in backend in rdl file.

But that parameter is absent in current report parameter node.

Solution: Never copy Design node from other report design,better open the original design and copy header,body and then footer ,one by one and paste it to destination  & check the .rdl file in the backend to identify unwanted parameter lists.

No comments:

Post a Comment

Deploying all SSRS reports or single report in D365FSCM Using PowerShell.

  All reports can be deployed using following commands . 1. Open PowerShell run as administrator  2.Copy and paste below command and enter....