Finance | Project Operations, Human Resources, ...

Getting error The parameter panel layout for this report contains more parameters than total cells available.

(1) Share

Report

Posted on by Community Member

Hi Folks,

I'm working with the SSRS report and there I have added a new parameter which is hidden so initially I get some error after deploy, so through some reference I removed the ReportParametersLayout tags in the XML document. In that case it will resolved but when I'm trying to make changes in this report and after deploying the report I'm getting the below error.

"Severity Code Description Project File Line Suppression State
Error 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) 0"

pastedimage1644919559828v1.png_2D00_640x480.png

Please help me to resolve this issue.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

huijij 19,811 on at

Like (1)

Report

Hi Aimon,

You said "In that case it will resolved but when I'm trying to make changes in this report and after deploying the report", can you describe what changes you made? For the error message, suggest you still check the xml file to see if the <ReportParametersLayout> <CellDefinitions> node contains a node for each parameter, if not, you can try again to remove the ReportParametersLayout tag and let it generate automatically. If that doesn't work, suggest you create a new NewDesign, copy all the objects in OldDesign and paste them into NewDesign, delete OldDesign and publish.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Judy,

I tried the same way for removing the <ReportParametersLayout> tag, deployed it and then another error came as per below screenshot

But again I made some changes, then deploy it again and get the Parameter panel error occurs, then after removing <ReportParametersLayout> tag. It is resolved

but I don't understand why it's happening.

So to get out of this issue, if this error persist the solution is to create a new design under the same report. Right?

Was this reply helpful? Yes No
Ali AbdAlNasser 405 on at

Like (0)

Report

Hello huijij.

I faced the same problem and followed your solution method, and it worked.
As you can see, I deleted this code:

And the operation was successful.
I wanted to put my comment here so that everyone can benefit from the solution I provided.
Thank you very much.

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

This is quite possible even after removing the said tags. The report xml won't update or never update that faster on a certain change with the right cells. After every change we need to remove those tags and redeploy if any such issue happens once.

Was this reply helpful? Yes No