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

351

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,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 351 on at

Like (0)

Report
Copy link

Link copied!

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,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

Are you duplicating the standard report?

Was this reply helpful? Yes No
PriyaDutta 351 on at

Like (0)

Report
Copy link

Link copied!

Yes

Was this reply helpful? Yes No
Suggested answer

GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 351 on at

Like (0)

Report
Copy link

Link copied!

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,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

Hi Priya,

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

Thanks

Bharani

Was this reply helpful? Yes No