How to Change the default font in Word.
File/Open
Navigate to the c:\documents and settings\user name\application settings\microsoft\templates
Open the normal.dot
Change the style: Format/Styles and formatting
Right click on the Normal setting and change the font.
Save the document and exit.
Thursday, September 22, 2005
Phone Format Sql Reporting Services
Here is how to format a phone number in Sql Reporting Services:
call the function below with this in an expression box: =code.CustomFormat( Fields!ContactNumber.Value)
Put this in the Custom Code dialog box:
Public Function CustomFormat(ByVal Value As String) As String
Dim FormatPhone As String
FormatPhone = Trim(Value)
IF FormatPhone <> VBNullString Then
Select Case FormatPhone.Length
Case 7
FormatPhone = FormatPhone.Insert(3, "-" )
Case 10
FormatPhone = FormatPhone.Insert(3, "-" )
FormatPhone = FormatPhone.Insert(7, "-" )
Case 12
FormatPhone = FormatPhone.Insert(3, "-" )
FormatPhone = FormatPhone.Insert(7, "-" )
Case Else
FormatPhone = ""
End Select
End If
Return FormatPhone
End Function
Thanks to the post here: http://www.sqlreportingservices.net/Ask/3647.aspx
call the function below with this in an expression box: =code.CustomFormat( Fields!ContactNumber.Value)
Put this in the Custom Code dialog box:
Public Function CustomFormat(ByVal Value As String) As String
Dim FormatPhone As String
FormatPhone = Trim(Value)
IF FormatPhone <> VBNullString Then
Select Case FormatPhone.Length
Case 7
FormatPhone = FormatPhone.Insert(3, "-" )
Case 10
FormatPhone = FormatPhone.Insert(3, "-" )
FormatPhone = FormatPhone.Insert(7, "-" )
Case 12
FormatPhone = FormatPhone.Insert(3, "-" )
FormatPhone = FormatPhone.Insert(7, "-" )
Case Else
FormatPhone = ""
End Select
End If
Return FormatPhone
End Function
Thanks to the post here: http://www.sqlreportingservices.net/Ask/3647.aspx
Friday, September 02, 2005
SQL Reporting Services Service Pack 2 - Failure modifying security permissions on file C:\Program Files\...\RSTempFiles
There is nothing out there for this error, except this Italian link:
Errore durante l'installazione di Reporting Services SP2 (ma vale anche per l'SP1): "Failure modifying security permissions on file C:\Program Files\...\RSTempFiles"
Thanks to this guy's link, I figured out you need to change the ReportingService logon to a System account.
Errore durante l'installazione di Reporting Services SP2 (ma vale anche per l'SP1): "Failure modifying security permissions on file C:\Program Files\...\RSTempFiles"
Thanks to this guy's link, I figured out you need to change the ReportingService logon to a System account.
Subscribe to:
Posts (Atom)