Step By Step Guide to Change Report Server Look and feel

CHANGE THE CONFIGURATION ENTRY IN REPORT SERVER FOLDER

·        Navigate to the report server folder which “C:\Program Files\Microsoft SQL Server \ MSRS_vv.MSSQLSERVER\Reporting Services\ReportServer”
·        Open the rsreportserver.config file and add the below entry below <Configuration>
·        <HTMLViewerStyleSheet>Pink</HTMLViewerStyleSheet> remember that Pink is will be your CSS file name which we will create in next step.
·        Save and close the file.

ADD Pink.css file in the Style folder

·        Open the Styles folder in \ReportServer and create a file named Pink.css
·        Copy the content of HTMLViewer.css to file name Pink.css.
·        Now you can modify the content of Pink.css according to your ease.
·        Suppose if you want to change the Parameter Frame color the navigate to .ParameterFrame section and modify.
e.g.

.ParametersFrame
{
/* make background ! */
background-color:burlywood;
border1px solid maroon;
width100%;
}

Accessing your newly created CSS in ReportServer

Try using the below command to access your new CSS in Report Server

http://localhost/reportserver?rc:Stylesheet=Pink


T-SQL LEAD LAG and SUM function based query

  Query on T-SQL window clause Below is the sales table Order_Date Name Product SubCategory ...