change the background color in table in report

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - Need to change Authentication type of my first DB in SQL05 * I was able to configure and install the DB * I accidentally selected Windows Authentication Now it won't let me login and keeps giving me an error. Question: how do i change the authentication type without getting into the db is there something I'm missing Tag: change the background color in table in report
  - 2
    - While creating a snapshot... Hi Greg, I solved the problem. It' s as i expected. There is a User Defined Data Type which is named "percent". While publication is being prepared, some stored procedures are prepared. And while system preparing the stored procedures, it assumes "percent" as a sql command (cause as you know it's a sql command) and expects some parameters next to it and can't find any parameters with it so raises that error. When I change the name of that User Defined Data Type as "percent_" then everything is ok. (Name of the mentioned UDDT is updated in the tables too) Publication is created successfully. So this proves my theory Ekrem Onsoy Tag: change the background color in table in report
  - 3
    - Adding linked measures without rebuilding? Is it possible to added a linked measure group without having to rebuild the base cube Or, is it possible to build a cube that exists of nothing but linked measures Tag: change the background color in table in report
  - 4
    - How to export to a fixed width flat text file with row delimiters? Sorry, didn't realize you were trying to do this through the wizard. You do need to use ragged right. I'm not sure if this will work (I don't spend much time in the wizard), but select Ragged Right as the format, and include your empty string in the select and see if that works. If it does not, you can do what I suggested above (which I am positive does work), by saving the package from the wizard, and then editing it in the Business Intelligence Design Studio (BIDS), which gives you a lot more options on what you can configure within the package. When you open the package in BIDS, the connection managers will appear in the lower portion of the window. Tag: change the background color in table in report
  - 5
    - error running ssis package You might also check the SQL Server to make sure the query governor is not enabled. The setting is located in the Server Properties, under the Connections page. Tag: change the background color in table in report
  - 6
    - Recursive Multi-Level Query using CTE. Attn: Experts! Thank you all for your prompt responses. I apologize if I was not clear yesterday. I have been reading and reading and reading about this the last 2 days and I am seeing OrgID's and UserID's in my sleep! I modified the above tables to contain more intuitive data. Basically, it works like so.... Each user can have a different role for each org. For Org 101, their role may be 1 (Public User). However, for Org 102, the role is 2. In this scenario, I am only concerned with Role 2 so only Role 2 will traverse down the tree to all children/grandchildren. I am also only concerned with User1. The result set would return 0 (or nothing) for org 101 since the user is not a role 2. However, all children/grandchildren of org 102 would return 2. I hope this clarifies. Also, I am attaching the table scripts. I apologize for not doing this earlier. I am new to this complex sql stuff and didn't even cross my mind. Finally, I am working on the sql provided in the last post. So far, not quite what I need. Hopefully this clarification will help. Thank you all so much for your help with this. I am very very grateful. GO CREATE TABLE [dbo].[Org]( [OrgID] [int] IDENTITY(100,1) NOT NULL, [ParentID] [int] NULL, [Description] [varchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [OrgLevelID] [int] NULL, PRIMARY KEY CLUSTERED ( [OrgID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO CREATE TABLE [dbo].[UserOrgRole]( [UserID] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [OrgID] [int] NOT NULL, [RoleID] [int] NOT NULL, PRIMARY KEY CLUSTERED ( [UserID] ASC, [OrgID] ASC, [RoleID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] Tag: change the background color in table in report
  - 7
    - Need urgent help on Aggregate Function Hi, I need to do something similar to Proclarity in SSAS 2005. In Proclarity i can create a named member by selecting a few members from a dimension. The underlying mdx looks like this Aggregate ({ [Channel].[Channel].[CON - Contractor], [Channel].[Channel].[DIS - Distributor], [Channel].[Channel].[END - End-User], [Channel].[Channel].[GRP - Group], [Channel].[Channel].[OEM - OEM], [Channel].[Channel].[PLA - Private Label], [Channel].[Channel].[SER - Service Provider], [Channel].[Channel].[SYS - System builder] }) Once i select the named member all the calculated measures reflect the result based on the members selected in the aggregate function. How can I do something similar in SSAS 2005. I dont want a named set and calculated member does not work if i use the plain mdx as above. But i also tried using Aggregate ({ [Channel].[Channel].[CON - Contractor], [Channel].[Channel].[DIS - Distributor], [Channel].[Channel].[END - End-User], [Channel].[Channel].[GRP - Group], [Channel].[Channel].[OEM - OEM], [Channel].[Channel].[PLA - Private Label], [Channel].[Channel].[SER - Service Provider], [Channel].[Channel].[SYS - System builder] }, [Measures].Orders Received Local) just to try to to see teh behaviour but to no avail. after processing the cube and selecting this meausre shows up empty cells. How can I solve this problem. thanks in adavance for helping Tag: change the background color in table in report
  - 8
    - Problem: Formatting The Sql Report Your problem is a very common issue related to the size of the document. Look in the report properties window (accesible from the report menu) and make sure the size of the report body fits within the margins of the page Tag: change the background color in table in report
  - 9
    - Guidelines for choosing collation If I am doing a fresh installation of SQL 2005 for a new application which will utilize database engine, report server and analysis services is my best choice Latin_General_BIN2 Thank you, Alex Ivanoff Tag: change the background color in table in report
  - 10
    - SQL Server 2005 Install fails on Vista Can you post the contents of two log files The ones we need are these: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_JAZZ_Core(Local).log C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0021_JAZZ_Support.log That will help us narrow down the problem. Tag: change the background color in table in report
  - 11
    - New features of Reporting Service in SQL 2008 Thanks. I'm going to try to find this information online first, since I don't want to install the 2008 edition on my machine just yet. Thanks for the help. Tag: change the background color in table in report
  - 12
    - roll back in for each container TomWhite_jr wrote: thanks jamie.. Is there anyway to roll back all the records inserted from the flat file. or can we trim all the inserted record from the delimited to avoid repeattion of the data in database while running the file again after correction Tom You could enable transactions on the dataflow, so that if if fails, all the records are rolled back. Or you redirect error rows to a new flat file, and then use that one when re-importing. Tag: change the background color in table in report
  - 13
    - SSRS 2005 probplem with mdx prameter passsing hi , i am trying generate a report using following query. but the parameter is nt properly passing. (OLEDB). i need to correct it. pls help me. ="WITH "+ "MEMBER [Measures].[Amount] AS 'IIF(ISEMPTY([Measures].[Amount Usd]),0,[Measures].[Amount Usd])'"+ "SET [FilteredBUList] AS 'descendants((STRTOSET ( '{" & Join(Parameters!BU.Value,",") & "}', CONSTRAINED),[Account—BillingCodeDsc].[Billing Code Description],leaves) ' "+ "SET [CustomTimeSet] AS Descendants([Date—Fiscal].[2006].[Quarter 1]:"+ "[Date—Fiscal].[2007].[Quarter 4],[Date—Fiscal].[month],Leaves)"+ "SELECT "+ "{[Measures].[Amount]} ON COLUMNS,"+ "{ [FilteredBUList] "+ "}on rows"+ " FROM Profitability" That BU parameter is multi value parameter. query should accept multi values . Tag: change the background color in table in report
  - 14
    - SSIS SCript Transform Parallelism Hi, I need some urgent help on a conceptual question. Requirement: I have a simple package with one dataflow task. In that I need to read from a sql table and for every row in that table loop through n times and generate new output rows based on certain conditions (which are best evaluated in custom script as they are rather complex). Hence, if I have 100 rows in the table as my input, I may end up with 100*n rows as output. My Design: To implement this I have used an OLE DB Source which outputs to a Script Transform (ST). In the ST I intend to loop through in custom code and generate new rows using the .AddRow feature when I need new rows. This ST then feeds into another OLE DB Destination which writes the data to the table. Simple! I am using the default buffer settings. All I have tweaked is the Synchronous... property on the script transform (otherwise I do not get to the Output0Buffer within the script!). Problem: I wish to do as much as possible in parallel. So I would expect the OLE DB Source to provide more than one row at a time to the script transform and that should process more than one input row simultaneously. It seems the script componenet is serializing input, so it seems to take one row at a time from the OLE DB source, loop through and process in the script transform). AM I RIGHT IN THINKING THAT THE SCRIPT TRANSFORM IS EXECUTING THE INPUT IN A SEQUENTIAL MANNER CAN I PARALLELISE THIS If so, how Thanks, Tirthankar Tag: change the background color in table in report
  - 15
    - SQL Server Express authentication mode greyed out Having problems connecting to SQL Server Express using 'sa' account and having read threds re problem and MS, advice is that Authenticaion mode needs to be set to both Windows and SQL. I have studio express installed and go to Security from the properties of the Server to change this option to use both authentication modes, however the options are greyed out! Can anyone advise pse. And will amending this option help me to enable the sa login which is refused at the moment, error as follows: Login failed for user 'sa'.The user is not associated with a trusted SQL Server connection Thank you in advance Tag: change the background color in table in report
  - 16
    - how to call a stored procedure in SSIS jaegd - thanks!!! Tag: change the background color in table in report
- Next
  - 1
    - WebRequest over HTTPS fails under SQLCLR, but works elsewhere I have some code in a SQL CLR stored procedure that calls out to a web service at UPS to obtain tracking information for a package. The code fails on the last line, in the call to WebRequest.GetRequestStream(), with the following exception: "System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it\r\n at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)\r\n at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP)\r\n at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception)\r\n --- End of inner exception stack trace ---\r\n at System.Net.HttpWebRequest.GetRequestStream()\r\n at UPSTracking.TrackShipment(String TrackingUri)" Here is the relevant code: WebProxy proxyObject = new WebProxy(); WebRequest request = WebRequest.Create(" https://www.ups.com/ups.app/xml/Track "); request.Proxy = proxyObject; request.Method = "POST"; request.ContentLength = strXMLData.Length; request.ContentType = "application/x-www-form-urlencoded"; StreamWriter sw = new StreamWriter(request.GetRequestStream()); This same code works just fine when not running in the SQL CLR assembly. The assembly is marked as External, but I've also tried marking it as Unsafe, which did not work either. Any suggestions on what the problem might be or how to troubleshoot this further would be greatly appreciated. Thanks, Steve F. Tag: change the background color in table in report
  - 2
    - Table design question - subject matter expert database Thanks to everyone for the help!!!! All of these answers are very helpful. I think that I'll combine the owner and experts into one table. I'm thinking that it would be best to keep things separated as much as possible. Can I mark all of these responses as "answers" I'm going to give it a try!!! Thanks again to all of you! This has been a wonderful and educational experience! Cal Tag: change the background color in table in report
  - 3
    - Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on... "all the Mods " <g> Modulus is an arithmetic operator. It returns the remainder after a division. So 3 Mod 2 = 1 and 7 Mod 10 = 7. OK >L< Tag: change the background color in table in report
  - 4
    - Activation You reference that new instances of a sproc may be launched for one message per convo, but what determines if it will or not Will it only happen if some threshold is exceeded on the queue The reason I was doing the little test was because I haven't seen any articles out there really detailing good ways to run large processing queries asynchronously for one application, so I was wanting to write one. My main curiosity was if there was any way to modify any of the settings for the procedure activation (which I don't think that there is). Tag: change the background color in table in report
  - 5
    - Disable Save Changes prompt Is there a way in SQL Mgt Studio to disable the "Save changes to the following items " prompt that comes up every time I close a query window Tag: change the background color in table in report
  - 6
    - Programatically adding a Timeout value for BulkInsertTask? I've searched around for a while and can't seem to find out how/where I set the timeout on a bulk insert task programmatically. Here is a snippet of code that works as long as the input file is pretty small....when I attempted to pump 1.3 million rows through the default timeout value was not big enough and a timeout exception occurred. Package loadPackage = new Package (); Stopwatch timer = new Stopwatch (); timer.Start(); ConnectionManager conMgr = loadPackage.Connections.Add( "FLATFILE" ); conMgr.ConnectionString = @"C:\BWR.txt" ; conMgr.Name = "FileInput" ; conMgr = loadPackage.Connections.Add( "ADO.NET:ODBC" ); conMgr.ConnectionString = @"Data Source=FOO;Initial Catalog=DestinationDb;Integrated Security=True;" ; conMgr.Name = "DestinationDB" ; TaskHost task = loadPackage.Executables.Add( "STOCK:BulkInsertTask" ) as TaskHost ; BulkInsertTask biTask = ( BulkInsertTask )task.InnerObject; biTask.UseFormatFile = true ; biTask.FormatFile = @"C:\BWR_1.fmt" ; biTask.SourceConnection = "FileInput" ; biTask.DestinationConnection = "DestinationDB" ; biTask.DestinationTableName = "StageBWR" ; biTask.BatchSize = 100; DTSExecResult result = loadPackage.Execute(); timer.Stop(); Console .WriteLine( string .Concat( "Process took(ms): " , timer.ElapsedMilliseconds.ToString())); Console .WriteLine(result.ToString()); if (loadPackage.Errors.Count > 0) { foreach ( DtsError error in loadPackage.Errors) { Console .WriteLine(error.Description); } } Again, the code above works just fine until we hit a timeout. There is no Timeout property on the BulkInsertTask class, nor can I see a way to set it on the Sql Connection. I don't even see them in the Connectionmanager.Properties collection for either the file connection or the database connection. Am I overlooking the obvious somewhere Tag: change the background color in table in report
  - 7
    - MDX Query Help...Please Thanks Deepak. That was helpful. Tag: change the background color in table in report
  - 8
    - Maintenance Tasks didn't install Have you created maintenance plans in sql 2005 if yes then it will be created as a SSIS package. Pls refer the link, http://technet.microsoft.com/en-us/library/ms189953.aspx to create maintenance plan. http://msdn2.microsoft.com/en-us/library/ms137847.aspx . Just double click the maintenance plan and you can view the contents and tasks involved in the package. Regards Deepak Tag: change the background color in table in report
  - 9
    - AMO: Can't update dsv when delete a column The only ideas that I have are: - double check that the database name (that you use in the code) is the same with the database on which you removed the column from the table. There might be a concidence that you have 2 databases containing the same table name and column name, you deleted from one, but the code works on the other database by chance (since I don't see in the code where you explicitly chose the database on which to run the SELECT statement) - double check that the name and the schema, 'dbo', of the table you use in the code are the same as the schema and the name of the table from which you deleted the column Tag: change the background color in table in report
  - 10
    - File System Error after Restore I tried to run new backup in production to start new test but I get this error. I see there is backup file of 29G I think i didn't checked the compressed mode. Backup was not completed. I have lot of disk space. I will checked that linked it's blocked at my work but I have SP2 in procution. TITLE: Microsoft SQL Server Management Studio ------------------------------ File system error: The following error occurred while the '\\ \F:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\OLAP\Data\Risk Reports History.0.db\Positions.0.cub\Positions.0.det\Positions 2006.0.prt\14.fact.data' file was being copied to the 'F:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\OLAP\Backup\Risk Reports History.abf' file: . (Microsoft.AnalysisServices) ------------------------------ BUTTONS: OK ------------------------------ Tag: change the background color in table in report
  - 11
    - Creating Simple Report using Reporting Services SP2 and SharePoint 2007 Integration I tried to workaround this issue by Creating Microsoft Access 2007 Database, using Linked SharePoint List as a tables, then I created Reporting Service Report Using this Database, in Visual Studio the Report is working fine by showing the data correctly but when you try it on the report server reporsitory directly or in the Windows SharePoint Service 3 site It doesn't work at all, it keep loading and loading until the error unexpected error appear if am running it from the sharepoint site. even thougth I configured the data sources correctly in sharepoint for the report Any help on that Thanks Mohd Tag: change the background color in table in report
  - 12
    - Parameter Valid Values I am deploying an rdl that is being deployed in a server.But i am encountering a problem regarding the valid values of the parameter.My parameters have dependencies,and one of my parameter comes out with two dependencies. Scenario : User needs to input his userID to access Book A. Book B needs Book A because the output will be depending on the its content. And Book C depend on Book B. Problem: when deploying, only Book A will have the initial value.The dependency in Book B is only one,which is fine.It shows its valid values. But how about for Book C which have 2 dependencies Because it doesnt show it's valid values.. Tag: change the background color in table in report
  - 13
    - Upgrading to SQLServer2005 hi, I'm using custom authorization in reporting services 2000 to restrict the users. To do this we created a dll customauthorization.dll and placed it in reportserver bin folder and performed changes in rsreportserver.config, rssrvpolicy.config, and web.config files. Now its time to upgrade our servers to SQLServer 2005. Now in SQLServer2005 what new enhancements were done with respect to security and what all extra steps should i follow to perform the upgradation with custom authorization. Please give me suggestions how to upgrade my reports to SQL2005 so that my custom authorization still works. waiting for ur valuable inputs uday Tag: change the background color in table in report
  - 14
    - String Type Multi-Valued Parameter Issue Yes, I have ideas, that is why I wrote what I wrote in my post <s>. Please read and let me know if it makes sense to you... or if not, what part doesn't. >L< Tag: change the background color in table in report
  - 15
    - Problem attaching DB from Network Share Its not at all recommended and it will trouble you if not today tomorrow... change your achitecture instead of sticking on to this. Madhu Tag: change the background color in table in report
  - 16
    - Algorithm used to encrypt password in sysxlogin Hi, Does anyone know which algorithm is being used to encrypt the passwords in the sysxlogins for SQL Server 2000 I've been googling for some time..but I can't seem to find this information. Please help. Many thanks, Leona Tag: change the background color in table in report

Jameslee20

I have a table that i need to display data
for each row I want the background color to be diff
anybody knowhow to do it

color
blank
color
blank

Re: change the background color in table in report

krubug

i am not at work right now but if iam not mistaken the syntax is:

iif(rowcount(nothing)=2, " GRAY " , nothing)

Re: change the background color in table in report

Jameslee20

thank you

Re: change the background color in table in report

Khushi2005

I tried using this property but it gives me error RowCount not declared

where should I write this event

Re: change the background color in table in report

lauramc

Try using RowNumber instead of RowCount.

The code is placed in the background color property. Choose the color dropdown and look for the <Expression> option. Select that, and add your code there.

Re: change the background color in table in report

mcssnt

If I need to see one yes one no like

1111 [visible]

2222 [invisible]

3333 [visible]

4444 [invisible]

......

I change the property Visibility-Initial visibility = expression = IIF(parameter="SOMETHING", FALSE,TRUE) with this I can hide the DATA but I need to hide the Field too (with border and everything), in preview it looks very good but If I deploy the report change and show the field with borders.

MARCOS Sad

Re: change the background color in table in report

Khushi2005

I do not see alternate rows gray .

In that expression what does "nothing" stand for .

I just copied that statement in my code

Do I need to replace it with some values