SSRS - QA from the BI class

Q1: Where do i get help for the expression syntax in the report designer?
Q2: How can I create a report template, so that I don't have to start from a blank report each time?
Q3: Is it possible to skin the Report server Website? I can make an asp.net page, but I think the Report Server page is probably adequate. Probably the better option is to use report services in Sharepoint?

Q
Where do i get help for the expression syntax in the report designer?

A
The syntax is based on Visual Basic

Here is a huge list of expression examples
http://msdn.microsoft.com/en-us/library/ms157328.aspx

 

Q
How can I create a report template, so that I don't have to start from a blank report each time?

A
Create your own report template, with company logo, standardized footer, etc…
More here
http://ssrslearningcurve.wordpress.com/2008/05/29/ssrs-templates-create-your-own/

 

Q
Is it possible to skin the Report server Website? I can make an asp.net page, but I think the Report Server page is probably adequate. Probably the better option is to use report services in Sharepoint?

A
#1 Yes you can via CSS

The web application that is responsible for serving content under /Reports (e.g. http://gecko:81/Reports ) can be found in
"c:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager"

There is a file called \Styles\ReportingServices.css that you can mess around with

image
Figure: Report Manager new look - Make sure to backup your .CSS before you start playing around with it

#2 You should be able to apply ASP.NET Themes to this web application as well


I would not expose this "/Reports" web app to the public

Exposing reports form SharePoint is a better option

Latest Posts

Popular Posts