Applying Colors To Reports
Sep 25, 2006Is there a way to apply .css or Skin files to all reports. Changing colors in each and every page is a little cumbersome.
Thanks in advance
ADVERTISEMENT
Using Colors In HTML Heading And Also Printing Colors To Failure / DBCC CHECKDB Error?
Apr 14, 2015I need to print in RED if there's atleast 1 or more consistency error and need a heading color of the table (Caption) how to do it.
DECLARE @tableHTML NVARCHAR(MAX) ;
SET @tableHTML =
N'<H1>DB Corruption Report:</H1>' +
N'<table border="1">' +
N'<tr><th>DBName</th><th>MessageText</th>' +
[code]....
Chart - Bar Colors
May 4, 2005Hi All,
I like RS for SQL server.
However, I am surprised (and frustrated) how limited the chart capabilities are; perhaps we have been spoiled by Excel...
Anyway, is there any way to change the color of the chart bars programatically.
I can select different schemas (excel, pastel, grayscale, etc) but I need to go a little bit further, is that much to ask?
Oh, by the way, we can't mix chart styles, can't we?
Need to show a chart and a line in the same report...
I appreciate your help on this, hopefully any answers to my questions might also help with other RS users with the same needs,
Thanks,
L
Does The Colors Count? :D
Apr 27, 2007Hi,
I know the title is not really that specific but I have a question about the use of templates.
When you copy a package (template) you allways have to generate a new id for it to be unique. But when you copy the package the tasks (etc.) will not get an new id and you can't even change it because it is readonly. So two different packages can have tasks which has the exact same id!!
When you debug in VS if you run two packages in parrallel the one that first exits will become green and VS will automatically make all tasks that has this exact id green - making it seem like the task in another package has finished while it may not have started yet at all.
So the question is: beside the strange behavour with the color can this identical id problem be a real problem causing other strange behavours that is more serious than just a change in color?
Has others experienced this behavour?
Chart Colors In Reporting Services
May 21, 2007Hi all,
Hopefully someone can clarify for me. I'd like to use custom colors for a chart that I have created. I've seen some code examples but I'm not really sure what to do with them. I've been using reporting services for like 2 days and I don't know xml or vb script, so I apologize for the probably stupid question. Thank you in advance.
-Keith
Alternating List Table Row Colors
May 6, 2008Hi All,
As the thread title state, I was wondering if it is possible to alternate the list table row colors between 2 colors. Just wanted to make it more presentable when viewing.
Regards,
Fadzli
Maintaining Custom Colors When Exporting To Excel
May 28, 2007I am using RGB HEX #s in my report for some colors. It shows up fine when rendering to a browser, however when exporting to Excel my custom colors don't come over. I've tried creating a report.xlt file with my custom colors in it, but when I export to Excel it uses the standard Excel palette instead of the custom palette in my report.xlt.
Any ideas on how to retain my custom colors when exporting to Excel?
Reporting Services :: Bar Charts With Different Colors For Different Categories
Jun 24, 2015I have been asked to derive a bar charts in SSRS. Each bar would represents a different category and each bar should come with different colors. No. of categories might vary every time, it is not fixed. How to achieve this dynamically?
View 2 Replies View RelatedNeed Help Regarding Custom Colors For Charts In Reporting Services
May 30, 2007I need some help regarding Custom Colors implementation for Charts in the Reporting Services.
What we are trying to do is to make every color for every Series(see example below) to be a customized Corporate color.
For example each of the series on the Chart should be in specific Custom Color:
Series 1 - "LightBlue"
Series 2 - "LightYellow"
Series 3 - "DarkBrown"
All I found from MSDN is how to do it in the Chart Properties in a Code section (right click on the report outside the chart -> Properties -> Code tab -> paste the Custom Code ).
And then to use it in the Chart color definition as:
Code Snippet=Code.GetColor( Series# )
But we are trying to do it in a separate C# class that would be updated only in one place, instead of changing 30 reports each time something is changed. So that it could be generic.
The C# class:
Code Snippet
namespace CustomColorPalette
{
public class CustomPalette
{
public CustomPalette()
{
}
public static string GetColor(string GroupingValue)
{
int groupingValue = int.Parse(GroupingValue);
string[] colorPalette = {"Green", "Blue", "Red"};
if (groupingValue < colorPalette.Length)
{
return colorPalette.GetValue(groupingValue).ToString();
}
else
{
return "Black"; // if # of Series is more than defined - all undefined will be = Black color
}
}
}
}
I tried 2 different ways:
1.
Then I put a code into a Custom Code section of a report:
Code Snippet
Public Function GetColor(SeriesNumber as String)
Return CustomColorPalette.CustomPalette.GetColor(SeriesNumber)
End Function
And in the Chart Custom Color settings I put:
Code Snippet=Code.GetColor( Fields!SeriesNumber.Value )
And after compilation I get an error:
Error 303 [rsCompilerErrorInCode] There is an error on line 2 of custom code: [BC30451] Name 'CustomColorPalette' is not declared. c:developmentvoyagerreportsvoyager convert reports.rootvoyager convert reportsReport_007D.rdl 0 0
2.
Second way I tried:
Then I put a code into a Custom Code section of a report:
Code Snippet
Dim X As CustomColorPalette.CustomPalette
Protected Overrides Sub OnInit()
X = new CustomColorPalette.CustomPalette()
End Sub
And in the Chart Custom Color I put:
Code Snippet=Code.X.GetColor( Fields!SeriesNumber.Value )
And after compilation I am getting an error like this:
Error 302 [rsCompilerErrorInExpression] The BackgroundColor expression for the chart €˜chart2€™ contains an error: [BC30456] 'X' is not a member of 'ReportExprHostImpl.CustomCodeProxy'. c:developmentvoyagerreportsvoyager convert reports.rootvoyager convert reportsReport_007D.rdl 0 0
Is there any workaround? Or all I can do is to make the Custom Colors manually in each report, and if something need to be changed - I will need to change it in each report separately
Thanks,
Alex
Dynamic Chart Labels (changing The Colors On The Fly)
Sep 11, 2007I have a chart that presently has two groupings on the x-axis: Year & Qtr. I'd like the Year labels to be one color, and the Qtr labels to be a different color. (All year labels should be Black, all Qtr labels should be Blue). I can see that an expression can be written to handle this dynamically, but I'm banging my head trying to figure it out...
Any help?
Thanks in advance,
Pete
Reporting Services :: Alternate Column Colors In 2008 Matrix?
Jan 20, 2011I have a Matrix with dynamic columns. I am grouping Matrix on one column group. I am trying to have a different color for every group. I hvae so far, three groups. How can I do that? A note, there is no data for every column group in every row.
View 7 Replies View RelatedHelp Needed !!!! The Colors Used By A Bar Chart In SQL Server 2005 Reporting Services.
May 3, 2007I have created a linked report in which I have two screen:
First Screen: Clicking on the bar of particular country the details of that particular country should be visible (the second screen)
Second Screen: When I clicked on a bar. All the count values are very well correct. In first chart Count of values under one bar "Pending decision"(yellow) was 337 for a country and in second screen its 337 again(shown in light green bar).
<!--[if !vml]--><!--[endif]-->
Problem: My problem is to make it sure that the colors that the first screen is having for particular status (as shown in the legend) should remain same in second screen also. For example for a status say "pending decision" the chart is using yellow color, so in screen two as well it must be shown with yellow color and not with lany other color. Can anyone help me in this context. Is there any way to customize colors used by bar chart. Please note that the question is not about using appropriate color scheme(palette) the question is how to "capture/ Re-use/ customize/ pass as a parameter" the colors used by a bar chart in SQL Server 2005 Reporting Services.
Reporting Services :: How To Color Format Column Bar Chart With 4 Different Colors
Sep 8, 2015I have a column bar chart which displays values for each month. As per the requirement, January column must be blue, February must be orange, March must be green, April must be pink. These 4 colors would repeat for the remaining months.
View 5 Replies View RelatedGetting The Foreground,Background Colors In The Report Item Dynamically Using Custom Code
Oct 25, 2007
Hi All,
I want to get the Font,Background colors of the report item(Textbox) changed in Runtime,According to the value in the Textbox. The idea is to get this done by using the Same Custom code for getting both the Foreground,Background colors, I thought to implement this with flag, But I dont know how to do this..
Reporting experts ..please help me with this issue.Thanks in Advance
-Mahendra
Reporting Services :: Colors Get Swapped On Stacked Column Chart (SSRS R2 2008)
May 7, 2015I have a report in which I have assigned custom colors with a function to one of my stacked column charts. When I run it in the report builder, the colors are correctly placed, but as soon as I upload the report to the server and view the report from there, the colors get swapped. I have these custom colors applied to other stacked column charts in the report and they work perfectly fine. The only difference between this chart and my other charts is that it contains two category groups.
EDIT: Alright, I have gotten it to display the correct colors by using a function with the colors I wanted in reverse. I have two values, "Upcoming" which is displayed in red, and "Outstanding" which is displayed in blue. If the chart has only upcoming values, it will display in blue rather than red, whereas if I have upcoming and outstanding values, they will display in their correct colors. why this is occurring?
Reporting Services :: SSRS 2012 Report Colors Do Not Export To Excel Correctly
Jul 21, 2015I am facing some issue in rendering my SSRS report(2012 version) to excel sheet with color codes. i am using conditional formatting to display the colors. So what is happening is ,take the below expression as an example, for the id  = 0, we are not getting white back ground, we are getting some other colors. But the same thing is working fine in SSRS 2008R2.Â
=IIF(MAX(Fields!id.Value=0,
= 0, "WHITE","BLUE")
Reporting Services :: SSRS 2012 Matrix Report Colors Do Not Export To Excel Correctly
Feb 12, 2013We mark cells in  a report using color names like red, pink, and transparent in the fill expression. In the browser it works correctly. When exported to Excel the colors go to the wrong cells. This worked correctly in SSRS 2008.Â
View 9 Replies View RelatedReporting Services :: SSRS 2014 Report Manager - Customize Standard Title And Change Background Colors?
Jul 30, 2015I have 3 SSRS 2014 (Dev, UAT and Prod). I would like to change background colors of each environment and customize the title 'SQL Server Reporting Services' to ' SSRS Development'.
I prefer to implement both, a background color change and a title change. The reason for this is to clarify to end users which environment they are working with.
Where can I make those minimal changes in SSRS 2014.
Applying SP3
Sep 15, 2004Hi
I am basically a sybase guy but unfortunately I need to patch a SQL server with SP3. This is the first time I will be doing that. So I am not sure that after applying SP3, if I would need to rebuild all databases again.
Could anybody tell me what and where is the impact when we install SP3..??
I would appreciate any kinda help.
Rgds
Wilson
Apply SP2 After Applying CTP?
Feb 20, 2007Should I apply SP2 even though I have already installed the community preview?
View 1 Replies View RelatedApplying Rules
Apr 18, 2008In my package i have column called "optinout" coming from source file which has the value "start" and "stop", now in my destination table i have a column called "contact permission code" to which i need to apply a business rule based on the value in column "optinout" the rule is as stated "Contact Permission Code" is OptOut if "OptInOut" value is "STOP" else OptIn.
View 4 Replies View RelatedComparison Of SQL Server Reporting Services To Access Reports, Crystal Reports, Cognos Or Other Options
Nov 5, 2007Hello SQL Server Experts, Data Analysts, and Report Writers et al:
re: Reporting Options with SQL Server
I wanted to propose an offshoot to the pryor thread:
Would anyone take a stab at comparing Access Reports, Crystal Reports,
Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?
I guess this is a far as capabilites, ease of use, limitations, and especially formatting
or presentation of the end report product?
Thank you to all, and I hope this is a beneficial discussion to others.
Hal1490
Hal9000
Reports Usage Frequency For All The Existing Reports On SSRS 2000
Mar 18, 2008I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?
I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.
Any help is appreciated
Reports Usage Frequency For All The Existing Reports On SSRS 2000
Mar 18, 2008I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?
I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.
Any help is appreciated
-UseInprocLoader When Applying The SNAPSHOT
Oct 19, 2003Hi guys,
ive search high and low for info regarding the "-UseInprocLoader" (in-process BULK INSERT command ) though to no avail. Their are only brief overviews on this property.
does anyone know or have detailed info on the "-UseInprocLoader" Property
1M thanks
Replication And Applying Patches
Oct 25, 2003Hi all
I just want to make sure I have the proper understanding of how to apply MS security patches in a replicated SQL2k environment.
1) Upgrade Distributor
2) Upgrade Publisher
3) Upgrade Subcriber(s)
Any comment or suggestion would be highly appreciated :-)
Applying Service Pack 3a
Feb 20, 2004Hi,
I am trying to install the eval version of Reporting Services. One of the requirements for installing this is to have SQL Server 2000 with service pack 3a. I've downloaded the service pack and followed the instructions documented by Microsoft (applying SQL2KSP3.exe, then SQL2KASP3.exe).
It appears that the application of the service packs did nothing. No errors where returned after the executable was run. But, after having applied these service packs, the version has not changed. I have restarted the service, and the server with no success. The version that is returned is
'Microsoft SQL Server 2000 - 8.00.194'.
I am running MSSQL server Developer Edition, running on Windows 2000 Professional (service pack 4).
Any suggestions. I have even uninstalled the SQL server and re-applied the service packs, so I really am having trouble trying to figure out what to do next.
Thanks,
Jim
Applying Service Pack 5a
May 26, 1999When I try to run SQL Server 6.5 Service Pack 5a, I consistently receive the error message
"Setup initialization could not be successfully completed.
cfgchar.exe could not be executed. Please check the relevant
out file."
I am currently at Service Pack 3.
1) I have insured that the PATH environment variable does not contain quotes.
2) I have no other applications running at the same time as the service pack is running.
The contents of the cfgchar.out file appear as follows:
C:MSSQLcharsets - created
C:MSSQLcharsetscp1250 - created
C:MSSQLcharsetscp1250DICTION.250 - copied
C:MSSQLcharsetscp1250NOCASE.250 - copied
C:MSSQLcharsetscp1250CSYDIC.250 - copied
C:MSSQLcharsetscp1250CSYNC.250 - copied
C:MSSQLcharsetscp1250HUNDIC.250 - copied
C:MSSQLcharsetscp1250HUNNC.250 - copied
C:MSSQLcharsetscp1250PLKDIC.250 - copied
C:MSSQLcharsetscp1250PLKNC.250 - copied
C:MSSQLcharsetscp1250ROMDIC.250 - copied
C:MSSQLcharsetscp1250ROMNC.250 - copied
C:MSSQLcharsetscp1250SHLDIC.250 - copied
C:MSSQLcharsetscp1250SHLNC.250 - copied
C:MSSQLcharsetscp1250SKYDIC.250 - copied
C:MSSQLcharsetscp1250SKYNC.250 - copied
C:MSSQLcharsetscp1250SLVDIC.250 - copied
C:MSSQLcharsetscp1250SLVNC.250 - copied
C:MSSQLcharsetscp1251 - created
C:MSSQLcharsetscp1251DICTION.251 - copied
C:MSSQLcharsetscp1251NOCASE.251 - copied
C:MSSQLcharsetscp1251UKRDIC.251 - copied
C:MSSQLcharsetscp1251UKRNC.251 - copied
C:MSSQLcharsetscp1253 - created
C:MSSQLcharsetscp1253DICTION.253 - copied
C:MSSQLcharsetscp1253NOCASE.253 - copied
C:MSSQLcharsetscp1253GRALTDCT.253 - copied
C:MSSQLcharsetscp1253GRMXTDCT.253 - copied
C:MSSQLcharsetscp1253GRNOACCE.253 - copied
C:MSSQLcharsetscp1254 - created
C:MSSQLcharsetscp1254DICTION.254 - copied
C:MSSQLcharsetscp1254NOCASE.254 - copied
C:MSSQLcharsetscp1255 - created
C:MSSQLcharsetscp1255DICTION.255 - copied
C:MSSQLcharsetscp1255NOCASE.255 - copied
C:MSSQLcharsetscp1257 - created
C:MSSQLcharsetscp1257DICTION.257 - copied
C:MSSQLcharsetscp1257NOCASE.257 - copied
C:MSSQLcharsetscp1257ETIDIC.257 - copied
C:MSSQLcharsetscp1257ETINC.257 - copied
C:MSSQLcharsetscp1257LTHDIC.257 - copied
C:MSSQLcharsetscp1257LTHNC.257 - copied
C:MSSQLcharsetscp1257LVIDIC.257 - copied
C:MSSQLcharsetscp1257LVINC.257 - copied
isql failed - Exit Code: 1
Any ideas?
Peter Townsend
Litens Automotive Group
Applying Service Packs
Sep 27, 2007Are there any guidelines or best practices for deploying or testing Service Packs? What types of tests should be performed prior to upgrading or do I just trust Microsoft?
View 4 Replies View RelatedApplying And/or In Stored Procedure
Mar 28, 2008Hi,
I need to modify an already existing stored procedure, which takes three parameters. Currently it uses exclusively "or" logic to apply the parameters to a select statement. e.g.
and (adid = @adID or (editorID = @editorID and aa.editorTypeID = 1))
What I need it to do is to apply a different "and/or" logic depending on what is supplied. If two or three parameters are supplied then it needs to use "and" logic to join them. Howver, if just one parameter is supplied then it should search on that parameter alone - which it won't do if I just join them all together using "and" by default.
The work has to be done inside the T-SQL, not in the calling code. I only know two ways of doing this. Firstly to create different stored procedures and use the calling code to pick one or the other depending on supplied parameters. The other is to do if/or login inside the SP itself on the values of the parameters. Either way presents something of a maintenance nightmare. Is there any other way to do this?
Cheers,
Matt
Applying SSIS In Application
Dec 13, 2006Is there anyway I can integrate the ssis in Web applications or Windows applications?
Thanks
Error When Applying Snapshot
Jun 27, 2006Hello, I have setup web sync from wm 5.0 and it seems to crash when applying the snapshot. Looking at the column definitions it seems fine. Am I missing something? Thanks in advance.
John
The identity column must be either an integer or big integer data type and cannot be NULL.
HRESULT 0x80004005 (25551)
The SQL statement failed to execute. [ SQL statement = CREATE TABLE "macros" ( "peopleid" numeric ( 18 , 0 ) NOT NULL , "macroid" numeric ( 18 , 0 ) IDENTITY ( 1 , 1 ) NOT NULL , "description" nvarchar ( 255 ) NULL , "rowguid" uniqueidentifier ROWGUIDCOL NOT NULL CONSTRAINT "MSmerge_df_rowguid_8E4B26C6706844BC984B039BA07845B5" DEFAULT ( NEWID ( ) ) ) ]
HRESULT 0x80004005 (28560)
The operation could not be completed.
Applying SP4. Do You Have To Provide Sa Password?
May 14, 2007I have never applied a service pack to sql server 2000. Someone tells me that you have an option of supplying the SA password but do not have to and the service pack is applied just as if you did supply the SA password. This sounds odd to me. So, is it true? I am asking because our server instance shows "SP4" but a fix that was supposed to be included in SP4 was apparently not as the problem persists (link from sql server 2005 to 2000 fails when referenced in sql2005). I was thinking that whoever ran the service pack may not have provided the SA password so some of the SP4 was not applied???
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI" for linked server "s-1". The provider supports the interface, but returns a failure code when it is used.
Thanks.