Customizing the Reporting Services UI

I want to make custom changes to the Report Manager and ReportViewer (i.e.
background color, adding the customers logo, etc.). Where are the UI for
these reporting UI located.
If its not advisible to change them, I want to clone them and make my own
customized UI.On Aug 1, 1:56 pm, Mike Johnson <Mike
John...@.discussions.microsoft.com> wrote:
> I want to make custom changes to the Report Manager and ReportViewer (i.e.
> background color, adding the customers logo, etc.). Where are the UI for
> these reporting UI located.
> If its not advisible to change them, I want to clone them and make my own
> customized UI.
For the Report Manager, this link may be of assistance.
http://msdn2.microsoft.com/en-us/library/ms345247.aspx
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Customizing Font Colors

I thought I read somewhere here that SP1 would allow us to customize the
font color to any RGB combination. I downloaded SP1, but still don't see
how I would be able to do that? Is it something I have to do through an
expression? I tried using =RGB(x,y,z), but the editor returns "The color
expression used in textbox, textbox1 returned a datatype that is not valid."
Anyone have any idea?
Thanks,
LisaThis has nothing to do with SP1. You could always specify a color as hex
HTML color string in the form #HHHHHH. See
http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml/reference/colors/colors.asp.
The SP1 feature is specifically about colors of series in charts.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lisa" <Lisa.Lambert@._nospam_etalk.com> wrote in message
news:uukWaEIWEHA.3236@.tk2msftngp13.phx.gbl...
>I thought I read somewhere here that SP1 would allow us to customize the
> font color to any RGB combination. I downloaded SP1, but still don't see
> how I would be able to do that? Is it something I have to do through an
> expression? I tried using =RGB(x,y,z), but the editor returns "The color
> expression used in textbox, textbox1 returned a datatype that is not
> valid."
> Anyone have any idea?
> Thanks,
> Lisa
>|||Nevermind, I just figured it out!
Lisa
"Lisa" <Lisa.Lambert@._nospam_etalk.com> wrote in message
news:uukWaEIWEHA.3236@.tk2msftngp13.phx.gbl...
> I thought I read somewhere here that SP1 would allow us to customize the
> font color to any RGB combination. I downloaded SP1, but still don't see
> how I would be able to do that? Is it something I have to do through an
> expression? I tried using =RGB(x,y,z), but the editor returns "The color
> expression used in textbox, textbox1 returned a datatype that is not
valid."
> Anyone have any idea?
> Thanks,
> Lisa
>

Customizing colors in Reporting Services

Hello. I have a textbox in which I want to customize the color of the
text. When you go to Properties->Color, the pull-down lets you choose
from a pre-defined list of colors by name (Black, DimGray, Gray, etc.)
You can also enter an expression. What I want to do is customize a
color that is different than the predefined colors. For example: I want
a color that is red 81, blue 81, green 123. The pseudocode for the
Expression would be:
= ColorType(81, 81, 123)
Is there a way to do this in Reporting Services? Thanks in advance.
JustinI did some research for you...
="#ff0000" works, put in the hex RGB values.
="#" & IIF(Fields!Mycolumn.Value < 100, "FF","00") & "00" works
="#" & IIF(Fields!Mycolumn.Value < 100,
Right(CStr(Hex(Fields!Mycolumn.Value))),"00") & "00" Does NOT work
What I didnt try is putting this in a function which returns the string ,
and uses the Field value..
Hope this helpss
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"jdyer521@.hotmail.com" wrote:
> Hello. I have a textbox in which I want to customize the color of the
> text. When you go to Properties->Color, the pull-down lets you choose
> from a pre-defined list of colors by name (Black, DimGray, Gray, etc.)
> You can also enter an expression. What I want to do is customize a
> color that is different than the predefined colors. For example: I want
> a color that is red 81, blue 81, green 123. The pseudocode for the
> Expression would be:
> = ColorType(81, 81, 123)
> Is there a way to do this in Reporting Services? Thanks in advance.
> Justin
>|||The last item posted that did not work had some syntax errors, but that is
not why it didn't work ( I was trying to type it in from memory..)
Here is what it should have been... but still doesn't work
="#" & IIF(Fields!EmployeeID.Value < 100,Right("0"
&CStr(Hex(Fields!EmployeeID.Value)),2),"00") & "0000"
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"jdyer521@.hotmail.com" wrote:
> Hello. I have a textbox in which I want to customize the color of the
> text. When you go to Properties->Color, the pull-down lets you choose
> from a pre-defined list of colors by name (Black, DimGray, Gray, etc.)
> You can also enter an expression. What I want to do is customize a
> color that is different than the predefined colors. For example: I want
> a color that is red 81, blue 81, green 123. The pseudocode for the
> Expression would be:
> = ColorType(81, 81, 123)
> Is there a way to do this in Reporting Services? Thanks in advance.
> Justin
>|||I hate it when something gets under my skin, as this problem has... I spent
my whole day's support allotment to this one thing... However this code
segment works, even using the input value in the color expression.. add it to
the code place... and refer to it in the color expression...
Function GetColor(Val as Integer) as String
Dim a as String
a = "#"
If (Val < 256) Then
a=a & Right("0"& CStr(Hex(Val)),2) & "0000"
Else
a = a & "00FF00"
End If
RETURN a
End Function
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"jdyer521@.hotmail.com" wrote:
> Hello. I have a textbox in which I want to customize the color of the
> text. When you go to Properties->Color, the pull-down lets you choose
> from a pre-defined list of colors by name (Black, DimGray, Gray, etc.)
> You can also enter an expression. What I want to do is customize a
> color that is different than the predefined colors. For example: I want
> a color that is red 81, blue 81, green 123. The pseudocode for the
> Expression would be:
> = ColorType(81, 81, 123)
> Is there a way to do this in Reporting Services? Thanks in advance.
> Justin
>|||Thanks for much for your time, Wayne. That is exactly what I needed.
Justin