Saturday, July 12, 2008

Turn Off Document Map SSRS

Document Map is always on by default. How can i have it turned off by default.

Enter the following URL in the address bar:


http://localhost/ReportServer?/reportPath/&rc:DocMap=false

Means set the
&rc:DocMap=false
at the end of url manually to hide it.
Its the only solution possible

Using Style sheet SSRS

Using Style sheet SSRS

  • Add the <HTMLViewerStyleSheet> setting to the Reporting Services configuration file.
  • Specify the style sheet on a report URL.


...
MyStyleSheet
...


Be Carefull don't include .css in the end..
put the style sheet in
By default, the Styles folder is located at <drive>:\Program Files\Microsoft SQL Server\MSSQL.n\Reporting Services\ReportServer\Styles.

DateInterval Enumeration not working in SSRS

DateInterval Enumeration not working in SSRs

Try this

DATEADD(DateInterval.Month,-12,cdate(Parameters!StartDate.Value))

or alternative try this


DATEADD("m",-12,Parameters!StartDate.Value)

How to split the column in matrix

To split a column in the matrix do the following:-
1. Drag the rectangle to the matrix text box.
2. Then drag several text box to the rectangle.
3. These text box will split the matrix column

How to set currency as poound in Reporting services SSRS

How to set Currency as pound in SSRs.
1. Select the textbox and view properties.
2. In properties Set the numeral Language to the language to which you r currency belongs

Reporting services not displaying unicode characters

If the reporting services is not displaying the Unicode character in reports then do the following:-
You have to install the language pack on your system
1. Goto Control panel -> Regional
and Language option -> Language tab .
2. Click on Install files for complex scripts and right to left languages.
3. It will prompt a message box, You have to insert the operating system Cd to get it installed.