Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to apply customized css to SSRS report

I am new to SSRS. I have created a report and was able to deploy it on the server. I am calling the report from ASP.NET application. How can I change the CSS of the report? I want to change the styles for individual data cells of the table deing displayed also. How is it possible? Thanks in advance.

like image 895
biluriuday Avatar asked Oct 27 '10 12:10

biluriuday


2 Answers

Magier:

There is a relatively simple way to do this (report by report) when using SSRS URL access to display the reports.

You create custom stylesheets on the report server for whatever different options you want to show or hide (or anything else in the Report Toolbar that you want to customize) and save them to: :\Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\ReportServer\Styles

Then, you simply add an &rc:Stylesheet= parameter to the URL you use to display the report, and spec whichever stylesheet you want. Your code can determine what the value of the rc:Stylesheet is:

ie:

http://localhost/reportserver?/AdventureWorksSampleReports/Product+Line+Sales&rs:Command=Render&rc:Stylesheet=NameOfYourStlesheetSansExtension

So as you can see, it can be dynamic, and (as far as I can tell), is the only straightforward way of controlling the ReportViewer styles in SSRS.

Source (same as the above answers, I just wanted to explain how to style on report by report basis): https://msdn.microsoft.com/en-us/library/ms345247.aspx

like image 95
datadevelopr Avatar answered Oct 07 '22 22:10

datadevelopr


You can customize the CSS at <drive>:\Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\ReportServer\Stylesor you can specify your own Stylesheet.

See this MSDN article for complete reference: Customizing Style Sheets for HTML Viewer and Report Manager

like image 45
Dennis G Avatar answered Oct 07 '22 21:10

Dennis G