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
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
1 comment:
Thanks great info.
I will modify CSS as short term measure before implementing to sharepoint.
In the path, "c:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager"
Replace MSRS10.MSSQLSERVER with the actual instance name. In my case it was default and ended up as MSSQL.4
Post a Comment