Sunday, May 27, 2012

The report parameter is read only and cannot be modified

Hi All,

We have a main report which has 5 subreports in it. We are passing the parameter value from main report to sub report. All subreports works fine but when we try to run the main report, we got the following error:
                           
"The report parameter is read only and cannot be modified."


Resolution:

To resolve the above error, just follow the below steps:
a. Open the Sub Report in Design View
b. Click on Report Properties tab under Reports as shown





c. Select the parameter which is throwing the error. In my case, the parameter "language" was causing the
    problem.
d. Under properties for the parameter, select the "Multi-value" option for the parameter as shown below



















e. Once this is done, just run the main report and was able to render the report without any problem in BIDS.
f. Now, upload the reports in Reports Library
g. Click on the report and select "Manage Parameters"

























h.This will display all the parameters available for a particular report as shown below






i. Make sure that the Language parameter is set to Hidden. The problem was that if the parameter is set to internal, we get the exception that the parameter is read-only and cannot be modified.
j. Once this is done, we are able to render the reports in SharePoint without any problem.

Thanks. 

1 comment: