Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by PriyaDutta

335

Hi,

I am getting the below error while deploying the report.

I have checked the parameters in design level as well as in xml editor. Both have same number of parameters.

I have also tried to remove ReportParameterLayout Tag from xml, but still error persists.

Please help.

Thanks in advance.

I have the same question (0)

All responses (8)

Answers (0)

GirishS 27,827 Moderator on at

Like (0)

Report

Hi Priya Dutta,

Try to increase the number of rows and number of columns in report design xml file.

Thanks,

Girish S.

Was this reply helpful? Yes No
PriyaDutta 335 on at

Like (0)

Report

Hi Girish,

I am able to increase number of rows but getting a new error on build

“The sequence has no elements”. On increasing number of columns is giving error that it should be less than or equal to 8.

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

Are you duplicating the standard report?

Was this reply helpful? Yes No
PriyaDutta 335 on at

Like (0)

Report

Yes

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

This will be the problem when you are directly duplicating the report. It will be solved by increasing and decreasing the number of rows and columns in the report design xml.

If that doesn't work then you follow the below suggestions.

Instead of duplicating - Create new ssrs report - manually add the report dataset. Create a new report design - now open the standard report - copy all the designs(ctrl+a) and paste in your new design.

Also keep in mind when you delete the duplicated report, for the newly created report name don't use the same name where you have deleted.

Thanks,

Girish S.

Was this reply helpful? Yes No
PriyaDutta 335 on at

Like (0)

Report

Hi Girish ,

I will try to create new report and copy all the designs.

What about the parameters ? Will they get created or manually I have to create and how ?

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

Parameters will be automatically added once you add the datasets.

Parameters are nothing but the parm methods that are created in report contract class.

Thanks,

Girish S.

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Hi Priya,

Can you please tell me the exact requirement? Why are you duplicating standard?

Thanks

Bharani

Was this reply helpful? Yes No

Join the conversation

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

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

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates