Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Error while deploying ...
Finance | Project Operations, Human Resources, ...
Suggested answer

Error while deploying SSRS report: panel layout for this report contains more parameters than total cells available

(0) ShareShare
ReportReport
Posted on by rabbit1986 335

Hello,

I am having an error while deploying a D365F&O SSRS report in my Visual Studio.

This is my dataprovider class:

[
SRSReportQueryAttribute(queryStr(WHSPickListShippingReport))
]
class TST_WHSPickListShippingDP extends SRSReportDataProviderBase
{

    TST_WHSPickListShippingTmp        wHSPickListShippingTmp;

    [SRSReportDataSetAttribute(tableStr(TST_WHSPickListShippingTmp))]
    public TST_WHSPickListShippingTmp getWHSPickListShippingTmp()
    {

        select * from wHSPickListShippingTmp;
        
        return wHSPickListShippingTmp;
    }

    /// 
    /// Processes the report business logic. Calls helper methods and inserts data to temporary table.
    /// 
    /// 
    /// Provides the ability to write the report business logic. This method will be called by
    /// SSRS at runtime. The method should compute data and populate the data tables that will be
    /// returned to SSRS.
    /// 
    public void processReport()
    {
        QueryRun            qr = new QueryRun(this.parmQuery());
        WHSWorkLine         workLine;
        WHSWorkTable        workTable;

        while (qr.next())
        {
            workLine = qr.get(tableNum(WHSWorkLine));
            workTable = qr.get(tableNum(WHSWorkTable));

            whsPickListShippingTmp.initFromWHSWorkLine(workLine);
            whsPickListShippingTmp.initFromWHSWorkTable(workTable);

            whsPickListShippingTmp.insert();
            
        }
    }

}

In my report I have the following where the dataset is connected to the dataprovider class

pastedimage1622273442666v1.png

When I try to deploy it says:

An error occurred while deploying the report TST_WHSPickListShipping.Report, TSTImplementation.
This might be because the SQL Server Reporting Services has not been installed, or is not configured correctly.
System.Web.Services.Protocols.SoapException: The parameter panel layout for this report contains more parameters than total cells available.
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)

Can anyone tell me how to fix this?

  • Deepak Agarwal Profile Picture
    Deepak Agarwal 8,566 on at
    Error while deploying SSRS report: panel layout for this report contains more parameters than total cells available
    This is a very old post, can this have a verified answer. 
  • Suggested answer
    Community member Profile Picture
    Community member 2 on at
    Error while deploying SSRS report: panel layout for this report contains more parameters than total cells available
    While deploying the report we usually get this error. This error occurs often while we are customizing out of the box reports like packing slip, purchase order confirmation etc.
     
    In order to fix this error I have the following things.
    1. After modifying the temp table. I restored the report datasets. Now, try to match the parameters of each dataset with the report parameters. If you find any extra report parameters and you think those are not necessary. Then delete the report parameters.
    2. If you are modifying the out of the box report. Try to duplicate the report and copy the design into new report design.  Now build and deploy the report.
  • imran_balti115 Profile Picture
    imran_balti115 105 on at
    RE: Error while deploying SSRS report: panel layout for this report contains more parameters than total cells available

    pastedimage1662386398615v1.png

    After adding cells i have this error showing

    [quote user="rabbit1986"]

    Hello,

    I am having an error while deploying a D365F&O SSRS report in my Visual Studio.

    This is my dataprovider class:

    Fullscreen
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    /// </remarks>
    public void processReport()
    {
    QueryRun qr = new QueryRun(this.parmQuery());
    WHSWorkLine workLine;
    WHSWorkTable workTable;
    while (qr.next())
    {
    workLine = qr.get(tableNum(WHSWorkLine));
    workTable = qr.get(tableNum(WHSWorkTable));
    whsPickListShippingTmp.initFromWHSWorkLine(workLine);
    whsPickListShippingTmp.initFromWHSWorkTable(workTable);
    whsPickListShippingTmp.insert();
    }
    }
    }
    XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

    In my report I have the following where the dataset is connected to the dataprovider class

    Image

    When I try to deploy it says:

    An error occurred while deploying the report TST_WHSPickListShipping.Report, TSTImplementation.
    This might be because the SQL Server Reporting Services has not been installed, or is not configured correctly.
    System.Web.Services.Protocols.SoapException: The parameter panel layout for this report contains more parameters than total cells available.
    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)

    Can anyone tell me how to fix this?

    [/quote]
  • Shared Assets Library Profile Picture
    Shared Assets Library 10 on at
    RE: Error while deploying SSRS report: panel layout for this report contains more parameters than total cells available

    I also faced a similar issue for which I removed the report layout tag manually. I have documented the step in the below blog.

    https://vikasaxaptandd365fno.blogspot.com/2022/06/ssrs-report-error-parameter-panel.html

  • huijij Profile Picture
    huijij 19,811 on at
    RE: Error while deploying SSRS report: panel layout for this report contains more parameters than total cells available

    Hi rabbit,

    Maybe you can search for the parameter 'WHSPickListShippingDS_DynamicParameter' from the error within Visual Studio

    to find any reference to it in the report and then update\delete that reference.

    regards

  • rabbit1986 Profile Picture
    rabbit1986 335 on at
    RE: Error while deploying SSRS report: panel layout for this report contains more parameters than total cells available

    I managed to get another error.

    Adding a parameter through visual studio did not quite help, because all needed parameters are there.
    But in the XML of the report a celldefinition was missing.

    So I added a cell definition and agumented the numberofCols tag:

    pastedimage1622817942559v1.png

    Now I am getting a new error:

    Publish-AXReport : System.Web.Services.Protocols.SoapException: The parameter 'WHSPickListShippingDS_DynamicParameter'
    is hidden or internal and is contained in a cell definition.

    Any got idea what this is about. I already tried to unhide the parameter.

    I never had so many errors while creating an SSRS report 

  • huijij Profile Picture
    huijij 19,811 on at
    RE: Error while deploying SSRS report: panel layout for this report contains more parameters than total cells available

    Hi rabbit,

    How about by adding cells?

    regards

  • rabbit1986 Profile Picture
    rabbit1986 335 on at
    RE: Error while deploying SSRS report: panel layout for this report contains more parameters than total cells available

    Hello, Thanks for the response.

    Sorry for my late answer ( was quite busy the past days :-) )

    How do I do this the best way? By editing the XML and adding cells ?

  • huijij Profile Picture
    huijij 19,811 on at
    RE: Error while deploying SSRS report: panel layout for this report contains more parameters than total cells available

    Hi rabbit,

    For the error message, you might have to add more cells in Design manually.

    regards

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,758 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans