SSRS Report error "The parameter panel layout for this report contains more parameters than total cells available D365" Finance and Operation

 Hi Friends,

Today, we will discuss the resolution for one of the report deployment issues i.e.

"The parameter panel layout for this report contains more parameters than total cells available D365" 

SSRS Deployment Error

To fix this issue, please follow the below steps.

Step 1: Open notepad with the Administrator account.



Step 2: Open the RDL file located within the Module folder in the K drive

Step 3: Seach for the "ReportParametersLayout" tag and remove the entire tag.


Step 3: Save the File. Open Visual Studio and deploy the report. You can also run the below command in Power Shell(Run power shell as admin) to deploy the report. (Replace with your model name which is in italic)

"K:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeployAllReportsToSSRS.ps1 -Module your_model_name -PackageInstallLocation “K:\AosService\PackagesLocalDirectory”"

Please do comment and let me know if you were facing the same challenge and if this solution worked for you. 

Keep watching this space for more blogs.


Comments

  1. AnonymousNovember 10, 2022 at 9:22 PM

    Thanks for the information. I had the same issue and this fix worked for me.

    ReplyDelete
  2. AnonymousJanuary 22, 2024 at 7:35 PM

    Thankyou for this blog, it really helped me fix my issue.

    ReplyDelete
  3. safeerMay 1, 2024 at 12:09 PM

    This error happnes in LIVe and we need to deploy chnages from dev to live to coorect this. Any idea how on live suddenly happens wihtout any chnage as yesterday it was working fine

    ReplyDelete
    Replies
    1. Vikas VaishJune 18, 2024 at 3:44 PM

      Hi, Sorry for delay in response. Did you found the solution ?. Is there any change in parameters of the the report?. This issue occur once you change the parameter(add or remove existing parameter) from the report.

      Delete
  4. AnonymousJuly 30, 2024 at 4:47 PM

    Excellent. worked for me too.

    ReplyDelete
  5. FirNovember 20, 2024 at 8:09 AM

    i try to remove the block, but then when i deploy back the report, it will generate new rdl file then when i check the block is there. how do i remove then ?

    ReplyDelete
    Replies
    1. Vikas VaishDecember 14, 2024 at 2:10 PM

      Parament solution to this is to create a new Design of the report.

      Delete
    2. Vikas VaishDecember 14, 2024 at 2:12 PM

      Create new Precision design and then copy all the element from the old design to new design.

      Delete
    3. Vince PertaDecember 18, 2024 at 1:21 AM

      The contents of the rdl file are encoded in the corresponding xml file for the report (K:\AosService\PackagesLocalDirectory\yourpackagename\yourmodelname\AxReport\yourreportname.xml). You can use Vikas's methodology to delete the ReportParametersLayout section from that xml file, it's just a little uglier to work with due to the encoding of the < and > characters...

      Starts with:
      <ReportParametersLayout>

      Ends with:
      </ReportParametersLayout>

      Delete

Post a Comment

Popular posts from this blog

Simplifying the Connection of Your Dev VM to Tier 2 Environment in D365D

Image
 Hi All, Welcome to my latest blog post where I'll be discussing common challenges developers face when connecting their Dev VM to the Tier 2 Environment in D365. Typically, manually replacing specific tags in the web.config file can be a tedious and error-prone process. However, I have created a utility that automates this task, simplifying the process of connecting your Dev VM to the Tier 2 Environment. To get started, simply download the utility from the link provided in your Dev VM and follow the steps below. Click here to download the file Step-by-Step Instructions: Step 1: Generate database credentials from LCS, please don't hesitate to contact me through comments if you feel any difficulty to generate Database credentials. I'll be happy to address your concerns and may even create a separate blog post on the topic. It should be like the one below. Step 2: Download the utility executable file to your Development VM and double-click it to execute. Step 3: On the comman...
Read more

Increase Your Storage in Azure Dev VM to fix disk size issue while D365 F&O DB restore.

Image
Hi All, When attempting to transfer a Microsoft Dynamics 365 Finance and Operations (D365 F&O) Tier 2 or higher environment database to your development machine, you may encounter a common hurdle: insufficient disk space within your development Virtual Machine (VM) due to the significant growth in the size of D365 F&O databases over time. Typically, the bacpac file downloaded from Lifecycle Services (LCS) is highly compressed. This blog post outlines a step-by-step guide to effectively address this scenario and manage your disk space during the restoration of a Dynamics 365 F&O database from a Tier 2 or higher environment. Scenario: Imagine you've imported the bacpac file into your database, and as time progresses, you find yourself running low on disk space, requiring additional room to complete the database restoration. Solution: Follow these steps to expand the available space on your drive by swapping it from another drive where memory is free: Step 1: Begin by ope...
Read more