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.

Some date time query

Some date time questions
1. You have Week no stored in your database and you wanna convert the week no to the corresponding month name

Here is sol
declare @weekno int, @year int
select datename(month,(dateadd(d,((@weekno-1)*7) - (datepart(dw,convert(varchar,@year)+'/1/1')-1),convert(varchar,@year)+'/1/1')))



2. You have Let say month as int in you database and you want to convert it to month name
declare @hello int
set @hello = 4
select datename(month,cast('2008' + '/' + CAST(@hello AS VARCHAR(2)) + '/01' AS DATETIME))


3. You Want to calculate the no of days for a particular year of a particular month
Declare @NoOfDays1 int
Declare @ month1 datetime
set @NoOfDay1 = datepart(dd,dateadd(dd,-1,dateadd(mm,1,cast(cast(year(@month1) as varchar)+'-'+cast(month(@month1) as varchar)+'-01' as datetime))))



4. You have date time stored in database as date and you want to change it to int
Declare @startday as datetime
select CONVERT(INT, Convert(varchar(10),convert(datetime,@Startday),112))



Will add more to the list later...

Installing Reporting server 2005 Installation on home premium VISTA??

hi,

Does Anybody Tried Installing Reporting server 2005 Installation on home premium VISTA??

I tried it.

I used Developer Edition Of sql server 2005. As U cant Install Enterprise version, as it does not support it.

Here is What i found...



1. You need Sql server 2005 Sp2 Installed.

2. To install Reporting server U need IIS.
IIS is not Present/installed by default.
U can enable IIS by going to Control Panel\Programs and Features , Click Turn windows On / off.
Then check the box of IIS.

But this doesn't Solve the problem...

Coz for Sql server 2005 to be installed U need Windows Authentication check box.

And This Windows Authentication Box Is not Available in scaled Down version of IIS 7.0... The IIS version which is shipped with the Home Premium is scaled down version of IIS 7.0

So The Conclusion is U cant Install Sql server 2005 reporting services on Vista Home Premium...


Hope I am correct...
If not Correct me...