Hi,
Anyone have a link to any instructions on how to customize the RS Home page?
I'd like the change the bolded 'Home' text with our company's name.
Thanks
JerryAccording to the Hitchhiker's Guide to SQL Server 2000 Reporting
Services, you should be able to do that by accessing and editing the
ReportingServices.css file on the box where ReportServer resides. They
list the path as C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\Report Manager\Styles. They warn several times to back up the
original CSS file and try your changes on your test server. I don't
have access to our report server box so I've never tried this. Good
luck!!
Showing posts with label customize. Show all posts
Showing posts with label customize. Show all posts
Tuesday, February 14, 2012
customizing reporting services error
Is there any way to customize reporting services error and provide a user friendly message? We use Reporting Services 2000 and the error message is:
Reporting Services Error
An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Query execution failed for data set 'dsasSource'. (rsErrorExecutingCommand) Get Online Help
Jens K. Suessmeyer.
http://www.sqlserver2005.de
Customizing Report Model AutoGeneration
Is there any way to customize the expressions that are generated when using the AutoGenerate wizard to produce a model in Visual/BI Studio? There are certain expressions that my team always has to generate for nearly every datetime attribute. Adding the expressions manually is very tedious since the expression window does not allow simple copy & paste.
There is no supported way to customize the fields created by the model generation wizard. However, if you poke around a little on your file system (for instance, under C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ReportModelProjects), you might find an undocumented file that, when modified, seems to influence the output of the model generation wizard. Remember, though, you're on your own. :)
Customizing Report Model AutoGeneration
Is there any way to customize the expressions that are generated when using the AutoGenerate wizard to produce a model in Visual/BI Studio? There are certain expressions that my team always has to generate for nearly every datetime attribute. Adding the expressions manually is very tedious since the expression window does not allow simple copy & paste.
There is no supported way to customize the fields created by the model generation wizard. However, if you poke around a little on your file system (for instance, under C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ReportModelProjects), you might find an undocumented file that, when modified, seems to influence the output of the model generation wizard. Remember, though, you're on your own. :)
Customizing Report Manager Pages
Hello All,
I was wondering if it's possible to customize the Report Manager pages
within Reporting Services. I'd like the Report Manager to reflect the
layout of our company web site. If so, is there thorough documentation on
how to do it?
Thanks in advance,
FrankSorry the report manager is not customizable. There is a style sheet that
will allow some changes but because this was not a design goal it can't be
guaranteed to be easy to understand and not everything was exposed.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Frank" <fdeluccia@.nospam.com> wrote in message
news:#MLvArkeEHA.140@.TK2MSFTNGP12.phx.gbl...
> Hello All,
> I was wondering if it's possible to customize the Report Manager pages
> within Reporting Services. I'd like the Report Manager to reflect the
> layout of our company web site. If so, is there thorough documentation on
> how to do it?
> Thanks in advance,
> Frank
>
I was wondering if it's possible to customize the Report Manager pages
within Reporting Services. I'd like the Report Manager to reflect the
layout of our company web site. If so, is there thorough documentation on
how to do it?
Thanks in advance,
FrankSorry the report manager is not customizable. There is a style sheet that
will allow some changes but because this was not a design goal it can't be
guaranteed to be easy to understand and not everything was exposed.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Frank" <fdeluccia@.nospam.com> wrote in message
news:#MLvArkeEHA.140@.TK2MSFTNGP12.phx.gbl...
> Hello All,
> I was wondering if it's possible to customize the Report Manager pages
> within Reporting Services. I'd like the Report Manager to reflect the
> layout of our company web site. If so, is there thorough documentation on
> how to do it?
> Thanks in advance,
> Frank
>
Customizing Report Manager Interface
Is it possible to customize the Reporting Services Report Manager interface?
What I am wanting to do is display the reports in a tree view.On Tue, 17 Aug 2004 23:43:02 -0700, Mick B <Mick
B@.discussions.microsoft.com> wrote:
>Is it possible to customize the Reporting Services Report Manager interface?
>What I am wanting to do is display the reports in a tree view.
Hi Mick:
I have an article showing how to do this with the web service API:
SQL Reporting Services Tree Navigation Sample
http://odetocode.com/Articles/95.aspx
--
Scott
http://www.OdeToCode.com
What I am wanting to do is display the reports in a tree view.On Tue, 17 Aug 2004 23:43:02 -0700, Mick B <Mick
B@.discussions.microsoft.com> wrote:
>Is it possible to customize the Reporting Services Report Manager interface?
>What I am wanting to do is display the reports in a tree view.
Hi Mick:
I have an article showing how to do this with the web service API:
SQL Reporting Services Tree Navigation Sample
http://odetocode.com/Articles/95.aspx
--
Scott
http://www.OdeToCode.com
Customizing Report Manager
As I recall, in RS2000 there was no way to customize the appearance of Report Manager.
I see that RS2005 has stylesheets which permit some customization of the appearance (maybe these were available in RS2000 also, but I never looked for them), but it appears that the source code for the web pages is still not provided. Is that the case, or is it possible to obtain the source code for Report Manager so that more extensive page customizations can be made?
Thanks!
-- Chris
Report Manager can only be customized in two ways:
* style sheets (as you have already discovered)
* UI strings (e.g. "View Report", "Export") of the ReportViewer component of report manager (for viewing reports) can be customized by implementing a certain interface and registering for the report server.
-- Robert
|||Robert,
Could you please clarify what you mean by:
>>* UI strings (e.g. "View Report", "Export") of the ReportViewer component of report manager (for viewing reports) can be customized by implementing a certain interface and registering for the report server.
Do you mean that text strings (like for text for buttons, links, etc.) in the Report Manager can be modified?
But is it true that the ASP .NET code for Report Manager is not available? Having that source code would provide the most flexibility.
-- Chris
|||Only strings of the ReportViewer embedded within report manager can be customized (similar to the ReportViewer Webforms control: http://msdn2.microsoft.com/en-us/library/ms254250.aspx). Report manager strings (such as all the administration pages, etc.) cannot be customized.
The source code for report manager is not available.
-- Robert
|||Robert,
Thank you for the information. It is not what I was hoping to hear 
, but now I know more about my options.
>>The source code for report manager is not available.
Are there any plans to make it available in a future release of Reporting Services?
-- Chris
|||Robert,
Does your reply apply to RS2000 as well? If it does, where can I find that stylesheet?
Thanks!
|||I don't find the link for RS 2000 report manager right now, but the following for RS 2005 should similarly apply to RS 2000: http://msdn2.microsoft.com/en-us/library/ms345247.aspx
-- Robert
|||Robert,
Can you answer my question from earlier in this thread:
"Are there any plans to make it [Report Manager source code] available in a future release of Reporting Services?"
Thanks!
-- Chris
|||No, we don't have plans to make the source code available.
-- Robert
|||Robert,
Thank you for your quick reply. Can you shed some light on why that is the case? I would think if nothing else Report Manager source code would provide a good reference implementation for developers to follow when developing their own custom reporting interface.
Is there something proprietary about Report Manager that is factored into that existing policy not to release the source code? Doesn't Report Manager use the same web services API that a developer would use to build a custom interface?
Thanks!
-- Chris
|||You are right, Report Manager uses the documented web services API only.
What is available right now as sample with source code is the RS Explorer sample (http://msdn2.microsoft.com/en-us/library/ms160845.aspx).
There are also samples of how to integrate the ReportViewer control into your application - see e.g. http://gotreportviewer.com
-- Robert
Customizing Report Manager
As I recall, in RS2000 there was no way to customize the appearance of Report Manager.
I see that RS2005 has stylesheets which permit some customization of the appearance (maybe these were available in RS2000 also, but I never looked for them), but it appears that the source code for the web pages is still not provided. Is that the case, or is it possible to obtain the source code for Report Manager so that more extensive page customizations can be made?
Thanks!
-- Chris
Report Manager can only be customized in two ways:
* style sheets (as you have already discovered)
* UI strings (e.g. "View Report", "Export") of the ReportViewer component of report manager (for viewing reports) can be customized by implementing a certain interface and registering for the report server.
-- Robert
|||Robert,
Could you please clarify what you mean by:
>>* UI strings (e.g. "View Report", "Export") of the ReportViewer component of report manager (for viewing reports) can be customized by implementing a certain interface and registering for the report server.
Do you mean that text strings (like for text for buttons, links, etc.) in the Report Manager can be modified?
But is it true that the ASP .NET code for Report Manager is not available? Having that source code would provide the most flexibility.
-- Chris
|||Only strings of the ReportViewer embedded within report manager can be customized (similar to the ReportViewer Webforms control: http://msdn2.microsoft.com/en-us/library/ms254250.aspx). Report manager strings (such as all the administration pages, etc.) cannot be customized.
The source code for report manager is not available.
-- Robert
|||Robert,
Thank you for the information. It is not what I was hoping to hear , but now I know more about my options.
>>The source code for report manager is not available.
Are there any plans to make it available in a future release of Reporting Services?
-- Chris
|||Robert,
Does your reply apply to RS2000 as well? If it does, where can I find that stylesheet?
Thanks!
|||I don't find the link for RS 2000 report manager right now, but the following for RS 2005 should similarly apply to RS 2000: http://msdn2.microsoft.com/en-us/library/ms345247.aspx
-- Robert
|||Robert,
Can you answer my question from earlier in this thread:
"Are there any plans to make it [Report Manager source code] available in a future release of Reporting Services?"
Thanks!
-- Chris
|||No, we don't have plans to make the source code available.
-- Robert
|||Robert,
Thank you for your quick reply. Can you shed some light on why that is the case? I would think if nothing else Report Manager source code would provide a good reference implementation for developers to follow when developing their own custom reporting interface.
Is there something proprietary about Report Manager that is factored into that existing policy not to release the source code? Doesn't Report Manager use the same web services API that a developer would use to build a custom interface?
Thanks!
-- Chris
|||You are right, Report Manager uses the documented web services API only.
What is available right now as sample with source code is the RS Explorer sample (http://msdn2.microsoft.com/en-us/library/ms160845.aspx).
There are also samples of how to integrate the ReportViewer control into your application - see e.g. http://gotreportviewer.com
-- Robert
Customizing NoRows Rpt Svs 2003
How can I customize the NoRows String message in a subreport? The text
it displays is black and in Times New Roman. I need to change the font
and color.
Thanks in advance,
RobertNevermind, I'm an idiot. Thanks. Didn't realize the font property on
the actual subreport controlled that.
it displays is black and in Times New Roman. I need to change the font
and color.
Thanks in advance,
RobertNevermind, I'm an idiot. Thanks. Didn't realize the font property on
the actual subreport controlled that.
Customizing Infosoft.dll Indexing behavior
Hi everybody,
Does any body know how we can customize the behavior of Microsoft
Indexing Service (i.e. Infosoft.dll).
I have the following case:
I am currently in the process of adding full linguistic support to a an
unsupported MS-Search language.
I need to index certain characters in a neutralized manner.
Example: I need to index the letters A,B, and C always as the letter A
so that when the user wants to search for the word ABZ for example, I
will neutralize B->A before passing it to the word to MS-Search
(Therefore teh word AAZ will be passed instead to MS-Search). This way I
gurantee that MS-Search will fetch all occurences of: ABZ, BBZ, CCZ, ACZ
... etc because this is how they are actually stored in the database.
In other words, I need a way to hook or manipulate teh Infosoft.dll word
breaker and stemmer for my own needs or replace it with my own.
I hope you got the idea.
I tried to search the MSDN site for hints or samples on how to do that
but found nothing.
THanks in advance.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Its not infosoft.dll which does the word breaking per se
Did you review the links here?
http://msdn.microsoft.com/library/de...nario_4ckl.asp
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Luai Rifai" <luairifai@.hotmail.com> wrote in message
news:OCXVqSzvEHA.2012@.TK2MSFTNGP15.phx.gbl...
> Hi everybody,
> Does any body know how we can customize the behavior of Microsoft
> Indexing Service (i.e. Infosoft.dll).
> I have the following case:
> I am currently in the process of adding full linguistic support to a an
> unsupported MS-Search language.
> I need to index certain characters in a neutralized manner.
> Example: I need to index the letters A,B, and C always as the letter A
> so that when the user wants to search for the word ABZ for example, I
> will neutralize B->A before passing it to the word to MS-Search
> (Therefore teh word AAZ will be passed instead to MS-Search). This way I
> gurantee that MS-Search will fetch all occurences of: ABZ, BBZ, CCZ, ACZ
> .. etc because this is how they are actually stored in the database.
> In other words, I need a way to hook or manipulate teh Infosoft.dll word
> breaker and stemmer for my own needs or replace it with my own.
> I hope you got the idea.
> I tried to search the MSDN site for hints or samples on how to do that
> but found nothing.
> THanks in advance.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Luai,
Actually, infosoft.dll is the "Wordbreaker and stemmer dll" taken from the
file description of the actual dll file and the "Indexing Service"
executable is cisvc.exe. Furthermore, it does seem that your question is
more about the Indexing Service, so a better place to post question on it
would be microsoft.public.inetserver.indexserver.
Furthermore, since you want to add full linguistic support for an
unsupported MSSearch language, you might want to review the following white
paper: "How to Write a Filter for Use by SharePoint Portal Server 2003 and
Other Microsoft Search-Based Products" at
http://msdn.microsoft.com/library/de...iteaFilter.asp
as it also includes "...Microsoft Indexing Service use filters to extract
the content and properties of files for inclusion in a full-text index".
Regards,
John
"Luai Rifai" <luairifai@.hotmail.com> wrote in message
news:OCXVqSzvEHA.2012@.TK2MSFTNGP15.phx.gbl...
> Hi everybody,
> Does any body know how we can customize the behavior of Microsoft
> Indexing Service (i.e. Infosoft.dll).
> I have the following case:
> I am currently in the process of adding full linguistic support to a an
> unsupported MS-Search language.
> I need to index certain characters in a neutralized manner.
> Example: I need to index the letters A,B, and C always as the letter A
> so that when the user wants to search for the word ABZ for example, I
> will neutralize B->A before passing it to the word to MS-Search
> (Therefore teh word AAZ will be passed instead to MS-Search). This way I
> gurantee that MS-Search will fetch all occurences of: ABZ, BBZ, CCZ, ACZ
> .. etc because this is how they are actually stored in the database.
> In other words, I need a way to hook or manipulate teh Infosoft.dll word
> breaker and stemmer for my own needs or replace it with my own.
> I hope you got the idea.
> I tried to search the MSDN site for hints or samples on how to do that
> but found nothing.
> THanks in advance.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Thanks a lot Hilary & John,
I really appreciate your feedback.
The problem with these references is that they talk about code that has
to customized or written in C++. My background is native C and VB,VB.Net
I wonder if there is a way to customize these filter libraries by adding
them as .Net references in a VB.Net project. Then I can work with them
easily using their .Net class model?!
Thanks any way.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||You're welcome, Luai,
Unfortunately, the API's for writing word breakers and stemmers for a new &
unsupported MS-Search language (a non-trivial effort) must be done in C/C++
as these API's were developed well before managed .NET languages were
available. Below are a few links that demonstrate how to interop with the
wordbreakers & stemmers via C# that might be of some help for you:
Part 1: Testing Full-Text Wordbreakers
http://sqljunkies.com/WebLog/acencini/articles/595.aspx
Part 2: Testing Full-Text Stemmers
http://sqljunkies.com/WebLog/acencini/articles/616.aspx
Part 3: Testing Full-Text IFilters
http://sqljunkies.com/WebLog/acencini/articles/716.aspx
Note, the above are less about writing a new wordbreaker, and more about how
to test the existing Wordbreakers, Stemmers and IFilters.
Regards,
John
"Luai" <luai_nospam@.devdex.com> wrote in message
news:uF2H3R$vEHA.3580@.TK2MSFTNGP10.phx.gbl...
> Thanks a lot Hilary & John,
> I really appreciate your feedback.
> The problem with these references is that they talk about code that has
> to customized or written in C++. My background is native C and VB,VB.Net
> I wonder if there is a way to customize these filter libraries by adding
> them as .Net references in a VB.Net project. Then I can work with them
> easily using their .Net class model?!
> Thanks any way.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Thanks John,
I think I will recommend to my manager that one of the C++ programmers
in my company should do this job instead of me
Thanks
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Does any body know how we can customize the behavior of Microsoft
Indexing Service (i.e. Infosoft.dll).
I have the following case:
I am currently in the process of adding full linguistic support to a an
unsupported MS-Search language.
I need to index certain characters in a neutralized manner.
Example: I need to index the letters A,B, and C always as the letter A
so that when the user wants to search for the word ABZ for example, I
will neutralize B->A before passing it to the word to MS-Search
(Therefore teh word AAZ will be passed instead to MS-Search). This way I
gurantee that MS-Search will fetch all occurences of: ABZ, BBZ, CCZ, ACZ
... etc because this is how they are actually stored in the database.
In other words, I need a way to hook or manipulate teh Infosoft.dll word
breaker and stemmer for my own needs or replace it with my own.
I hope you got the idea.
I tried to search the MSDN site for hints or samples on how to do that
but found nothing.
THanks in advance.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Its not infosoft.dll which does the word breaking per se
Did you review the links here?
http://msdn.microsoft.com/library/de...nario_4ckl.asp
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Luai Rifai" <luairifai@.hotmail.com> wrote in message
news:OCXVqSzvEHA.2012@.TK2MSFTNGP15.phx.gbl...
> Hi everybody,
> Does any body know how we can customize the behavior of Microsoft
> Indexing Service (i.e. Infosoft.dll).
> I have the following case:
> I am currently in the process of adding full linguistic support to a an
> unsupported MS-Search language.
> I need to index certain characters in a neutralized manner.
> Example: I need to index the letters A,B, and C always as the letter A
> so that when the user wants to search for the word ABZ for example, I
> will neutralize B->A before passing it to the word to MS-Search
> (Therefore teh word AAZ will be passed instead to MS-Search). This way I
> gurantee that MS-Search will fetch all occurences of: ABZ, BBZ, CCZ, ACZ
> .. etc because this is how they are actually stored in the database.
> In other words, I need a way to hook or manipulate teh Infosoft.dll word
> breaker and stemmer for my own needs or replace it with my own.
> I hope you got the idea.
> I tried to search the MSDN site for hints or samples on how to do that
> but found nothing.
> THanks in advance.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Luai,
Actually, infosoft.dll is the "Wordbreaker and stemmer dll" taken from the
file description of the actual dll file and the "Indexing Service"
executable is cisvc.exe. Furthermore, it does seem that your question is
more about the Indexing Service, so a better place to post question on it
would be microsoft.public.inetserver.indexserver.
Furthermore, since you want to add full linguistic support for an
unsupported MSSearch language, you might want to review the following white
paper: "How to Write a Filter for Use by SharePoint Portal Server 2003 and
Other Microsoft Search-Based Products" at
http://msdn.microsoft.com/library/de...iteaFilter.asp
as it also includes "...Microsoft Indexing Service use filters to extract
the content and properties of files for inclusion in a full-text index".
Regards,
John
"Luai Rifai" <luairifai@.hotmail.com> wrote in message
news:OCXVqSzvEHA.2012@.TK2MSFTNGP15.phx.gbl...
> Hi everybody,
> Does any body know how we can customize the behavior of Microsoft
> Indexing Service (i.e. Infosoft.dll).
> I have the following case:
> I am currently in the process of adding full linguistic support to a an
> unsupported MS-Search language.
> I need to index certain characters in a neutralized manner.
> Example: I need to index the letters A,B, and C always as the letter A
> so that when the user wants to search for the word ABZ for example, I
> will neutralize B->A before passing it to the word to MS-Search
> (Therefore teh word AAZ will be passed instead to MS-Search). This way I
> gurantee that MS-Search will fetch all occurences of: ABZ, BBZ, CCZ, ACZ
> .. etc because this is how they are actually stored in the database.
> In other words, I need a way to hook or manipulate teh Infosoft.dll word
> breaker and stemmer for my own needs or replace it with my own.
> I hope you got the idea.
> I tried to search the MSDN site for hints or samples on how to do that
> but found nothing.
> THanks in advance.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Thanks a lot Hilary & John,
I really appreciate your feedback.
The problem with these references is that they talk about code that has
to customized or written in C++. My background is native C and VB,VB.Net
I wonder if there is a way to customize these filter libraries by adding
them as .Net references in a VB.Net project. Then I can work with them
easily using their .Net class model?!
Thanks any way.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||You're welcome, Luai,
Unfortunately, the API's for writing word breakers and stemmers for a new &
unsupported MS-Search language (a non-trivial effort) must be done in C/C++
as these API's were developed well before managed .NET languages were
available. Below are a few links that demonstrate how to interop with the
wordbreakers & stemmers via C# that might be of some help for you:
Part 1: Testing Full-Text Wordbreakers
http://sqljunkies.com/WebLog/acencini/articles/595.aspx
Part 2: Testing Full-Text Stemmers
http://sqljunkies.com/WebLog/acencini/articles/616.aspx
Part 3: Testing Full-Text IFilters
http://sqljunkies.com/WebLog/acencini/articles/716.aspx
Note, the above are less about writing a new wordbreaker, and more about how
to test the existing Wordbreakers, Stemmers and IFilters.
Regards,
John
"Luai" <luai_nospam@.devdex.com> wrote in message
news:uF2H3R$vEHA.3580@.TK2MSFTNGP10.phx.gbl...
> Thanks a lot Hilary & John,
> I really appreciate your feedback.
> The problem with these references is that they talk about code that has
> to customized or written in C++. My background is native C and VB,VB.Net
> I wonder if there is a way to customize these filter libraries by adding
> them as .Net references in a VB.Net project. Then I can work with them
> easily using their .Net class model?!
> Thanks any way.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Thanks John,
I think I will recommend to my manager that one of the C++ programmers
in my company should do this job instead of me
Thanks
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
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
>
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
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
Subscribe to:
Posts (Atom)