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. 

Sunday, May 20, 2012

Limiting the Export Options for SQL Server Reports

Hi All,

We had a requirement to have only few formats (MHTML, PDF and EXCEL) available for exporting the report data. By default, we have many options available for exporting the report data like MHTML, PDF, EXCEL,CSV, XML, TIFF, Word as shown below:












To limit these options, we need to edit the RSReportServer.config file. To find the location of this file, just search for RSReportServer.config in "%ProgramFiles%\Microsoft SQL Server".

Once this file is found, edit the file and search for <Render> tag. This is a XML structure which has various rendering formats as shown below:









Add the attribute Visible="false" for the format to be hidden. That's it !!! Now, we see only limited format options for report as shown below:








Thanks.

No report servers were found on the specified machine - SharePoint 2007

Hi All,

We got the below error in "Grant Database Access" step when trying to configure reporting services in SharePoint 2007 server.

Error:
"No report servers were found on the specified machine"











Background:
SharePoint 2007 and Database are on seperate machines. Hence, to install reporting services, we have first installed Microsoft SQL Server 2008 R2 Developer Edition with Reporting services database configured in SharePoint Integrated Mode.

We also installed Microsoft SQL Server 2005 Reporting Services Add-in for SharePoint on SharePoint 2007 server. Then, when trying to grant database access in Central Administration, we got the above error.

Resolution:
To resolve this error, we have installed latest version of "Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies" from here.

Once this was done, we were able to render the SSRS reports properly.

Cheers !

Friday, May 11, 2012

Mozilla and Chrome Specific CSS

Hi All,

To add Mozilla specific CSS, just include the CSS inside @-moz-document url-prefix() as shown below:

/* Mozilla Specific CSS */
 @-moz-document url-prefix()  {
    #imgHeaderTD
    {
        display:none;
    }
}

The above code hides the element with ID imgHeaderTD in Mozilla only.

To add Chrome specific CSS, just include the CSS inside  @media screen and (-webkit-min-device-pixel-ratio:0):

/* Chrome Specific CSS */
@media screen and (-webkit-min-device-pixel-ratio:0) {
    #imgHeaderTD
    {
    display:none;
    }
}

Thanks.