Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...

SQL Server Reporting Services

Index ‹ SQL Server

- Previous
  - 1
    - How to export to a fixed width flat text file with row delimiters? Ragged right should work. It's just fixed width with a row delimiter. Have you tried it Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 2
    - error running ssis package It sounds like a timeout issue. You say that the task which is failing is moving a large amount of data, and taking more than 30 minutes Is it always failing after the same amount of time If so, you might check the timeout on the connections. Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 3
    - Recursive Multi-Level Query using CTE. Attn: Experts! I cannot give this a serious look until tomorrow; here are a couple of posts I have made previously concerning recursive queries and hierarchies: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1174303&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1219738&SiteID=1 I am puzzling over the way roleID is used in the example. I can't see where the '2' comes from for your desired results. I am afraid I don't understand how the RoleIDs work. Also, I don't understand why OrgID 103 does not appear in the target output -- it is in the UserOrgRole table. Also, please describe the order you wish for the output. Do you wish the output ordered by only OrgID or by (1) hierarchy depth and then (2) Orgid Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 4
    - Need urgent help on Aggregate Function Could you explain why "calculated member does not work if i use the plain mdx as above" - what dimension/hiererchy did you create the member on, and what results did you get Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 5
    - Problem: Formatting The Sql Report If you are using table to show data in reporting service just select table header and set in property repeaton each page = true. Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 6
    - Guidelines for choosing collation Alex, you can find some guidance on choosing a collation in these BOL articles: - Collation Settings in Setup, http://msdn2.microsoft.com/en-us/library/ms143508.aspx . This describes the kinds of choices that you have, and some characteristics of each to help you evaluate tradeoffs. - Windows Collation Sorting Styles, http://msdn2.microsoft.com/en-us/library/ms143515.aspx . This discusses effects on Unicode and non-Unicode data, and includes table explaining the meaning of suffixes. - Using Binary Collations, http://msdn2.microsoft.com/en-us/library/ms143350.aspx . Includes a couple of guidelines for _BIN and _BIN2 usage. - Windows Collation Name (Transact-SQL), http://msdn2.microsoft.com/en-us/library/ms188046.aspx . The refernece on how to specify a Windows collation name in T-SQL, with a summary of options. Ultimately, there are three things that mostly determine what collation you need: interaction with other SQL Server servers (what do they use & support ), interaction with the applications (what do they expect & support ), and interaction with users (what do they expect ). In particular, for the _BIN2 suffixed Latin_General (and bearing in mind that binary is case-sensitive, accent-sensitive, etc): Binary collations in this release of SQL Server include a new set of pure code-point comparison collations. Customers can choose to migrate to the new binary collations to take advantage of true code-point comparisons, and they should utilize the new binary collations for development of new applications. The new BIN2 suffix identifies collation names that implement the new code-point collation semantics. In addition, a new comparison flag is added corresponding to BIN2 for the new binary sort. Advantages include simpler application development and clearer semantics. Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 7
    - SQL Server 2005 Install fails on Vista Would you share the log files located at %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG It is strange as SQL Server 2005 Express also depends on .NET Framework but you can install it successfully. Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 8
    - New features of Reporting Service in SQL 2008 I belive in BOL, section "What is New", but that is just for this CTP. Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 9
    - roll back in for each container TomWhite_jr wrote: Hi, I'm using data flow as flat file source -> derived column ->Data Conversion-> oledb destination I have a fifty thousand record in a delimited file. while processing i got error in 45000th row. In database only 40000 records are there(why is there no all 45000 records). Is there any way to roll back all the 40000 records. Tom, The SSIS dataflow processes data in buffers. A buffer contains a fixed set of rows and usually is about 10000 rows (usually slightly less than that actually - for reasons I won't go into right now). By default, the OLE DB Destination will commit rows a buffer at a time so if one row fails, all rows in that buffer fail. You can change this behaviour by setting "Rows Per Batch"=1. This will mean each row will get committed a row at a time so at the point of failure you will get 44999 rows in the destination. It will be slo-o-o-o-o-w though! -Jamie Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 10
    - SSRS 2005 probplem with mdx prameter passsing Such expressions can be difficult to debug by visual inspection alone - I'd suggest temporarily adding a text box to your report, with its value set to the above expression. When you run the report, you'll see the actual query string generated. If the problem isn't obvious, posting this string here would be helpful. Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 11
    - SSIS SCript Transform Parallelism No, it processes a buffer at a time, like other pipeline components. What you are seeing is the wrapper code that SSIS generates for script components. If you want to get to the entire buffer, override the ProcessInput method. Code Block Public Overrides Sub ProcessInput( ByVal InputID As Integer , ByVal Buffer As Microsoft.SqlServer.Dts.Pipeline.PipelineBuffer) Be aware that a buffer contains a subset of rows, not necessarily all of them. Buffers default to around 10,000 rows. Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 12
    - SQL Server Express authentication mode greyed out I Hi Tim, I guess that you didn’t connect with a server principal (user) which has the appropiate permissions to change the authentication type. Dont worry about the message " Login failed for user 'sa'.The user is not associated with a trusted SQL Server connection", this is dedicated to the fact that you only have Windows authentication enabled. SQL Server won’t accept any SQL Server logins then (even if it is sa). If you don’t have any Windows User on hand which is priviledged to change the authentication mode (normally and by default the (Windows) group "Administrators" (and all users assigned to that group) are system administrators at Sql Server level) you can switch the authentication mode in the registry. http://support.microsoft.com/kb/322336/en-us Make sure you restart the service after doing that. HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 13
    - how to call a stored procedure in SSIS Just create a new instance of "OLE DB Command". Pick and choose your connection, and call the command as exec <procedure name> Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 14
    - change the background color in table in report i am not at work right now but if iam not mistaken the syntax is: iif(rowcount(nothing)=2, " GRAY " , nothing) Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 15
    - WebRequest over HTTPS fails under SQLCLR, but works elsewhere I haven't solved this yet, but wanted to add a couple other pieces of information: - This problem seems to only be related to making the request over SSL. The code works fine over port 80. - The same code listed above works just fine in a standalone WinForms application (using SSL) on the same machine (my dev box). Could SQL Server be blocking the outgoing request on port 447 Is this something I have to configure Again, thanks in advance for any information or advice. This is driving me crazy! Steve F. Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 16
    - Table design question - subject matter expert database I wouldn’t scale the expert out to n-tables: tblExpert Subjectid (FK) EmployeeId (FK) (Both columns a compound PK) If you want a precedence in the experts you can introduce another column e.g. priority / Order. Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
- Next
  - 1
    - Activation MAX_QUEUE_READERS = Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 2
    - Disable Save Changes prompt No, currently there is no way to disable the prompt to save unsaved changes in the T-SQL script editor. You can submit suggestions for Management Studio functionality at http://connect.microsoft.com/sqlserver . We use customer feedback like this when we are prioritizing future work. Thanks, Steve Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 3
    - Programatically adding a Timeout value for BulkInsertTask? I don't see this timeout behavior you're describing with an OLEDB connection manager connecting to SQL Server 2005. The bulk insert task always runs until its done, whether it takes seconds or an hour. So, a couple of things 1. What is interval duration before the timeout occurs 2. Have you tried using an OLEDB connection manager rather than ODBC over ADO.NET 3. What database (including version) are you connecting to and does it have a query governer limit set Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 4
    - MDX Query Help...Please Could you explain how you derive this result from the 3 rows of data - only 1 of which is associated with CustomerID 1 ItemID Price LowPrice AveragePrice 1 2.00 4.00 5.00 Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 5
    - Maintenance Tasks didn't install Have you installed Integration services SSIS is it shown in configuration manager. I think you neeed ot as all the maintenance plans in sql 2005 is configured to run as a SSIS package ! Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 6
    - AMO: Can't update dsv when delete a column ivanchain wrote: Dim dataTable As DataTable = adapter.FillSchema(dsv.Schema.Tables(i), SchemaType.Mapped) ivanchain wrote: But, from the first messagebox and the second messagebox, I see the dsv is not updated after I delete the column Let's also check if the returned 'dataTable' still contains the column you deleted. If it does contain the column, then we need to double check the table name and its columns in SQL Server.If the returned 'dataTable' doesn't contain the column, it looks like you need to replace the table in the DSV with this returned 'dataTable', but according to documentation at http://msdn2.microsoft.com/en-us/library/152bda9x.aspx , this should not be the case. The rest of the code looks good, the problem is not in AMO, but in the FillSchema area. Adrian Dumitrascu Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 7
    - File System Error after Restore Could you post the full error message Thanks, Bryan Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 8
    - Creating Simple Report using Reporting Services SP2 and SharePoint 2007 Integration You may want to check out this thread on how to use a SharePoint list as a Datasource: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1154115&SiteID=1 HTH Prash Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 9
    - Parameter Valid Values I am assuming your parameters are named: Book A Book B Book C Book C will display its valid valid values, after A and B have been selected. On initial display (unless you have defaults) it will appear as though there are none, but after selection of B, C will refresh. C really only has 1 dependency (B), not 2. Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 10
    - Upgrading to SQLServer2005 Hi, The changes in Reporting Services 2005 are not that much except for the new Report Model and Report Builder. The changes in the reports are limited to some extra designers and stuff like multiple selection for parameters, ... . According to me, you will need to perform the same steps to use the .dll as you did before. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 11
    - String Type Multi-Valued Parameter Issue Any ideas on this anyone Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 12
    - Problem attaching DB from Network Share This is by design and really not recommended due to I/O problems. If you must, take a look at the following KB. http://support.microsoft.com/kb/304261 Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 13
    - Algorithm used to encrypt password in sysxlogin Laurentiu wrote a really good article on this topic, I hope you will find it useful: http://blogs.msdn.com/lcris/archive/2007/04/30/sql-server-2005-about-login-password-hashes.aspx -Raul Garcia SDE/T SQL Server Engine Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 14
    - Help!- Image display problem with SSRS report in IE 6 I have a report that has both data and graph. I call the SSRS API to get the report in MHTML format and use Response.BinaryWrite to output the resultant byte array. I also set the Response.ContentType = "message/rfc822". The browser renders the data correctly but shows the image as blank I have also tried setting the above to "multipart/related".. but this doesn't work as well. The above problem is replicated in IE 6. Things work fine in IE 7.0. Can someone please help out Thanks in advance. Naresh Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 15
    - Line location as expression Yes, it is possible if I understand you correctly and if you are willing to do some custom rendering. Check out CustomReportItem and look at the Polygons sample in the RS sample stuff. If you go this route, take it from me you will find out it's not all about 1's and 0's <rofl>. But, yes, you are really not being clear <g>. So maybe I've misunderstood... >L< Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...
  - 16
    - Capacity Of SQL Server From SQL Server 2005 Books Online online: Maximum Capacity Specifications for SQL Server 2005 http://msdn2.microsoft.com/en-us/library/ms143432.aspx Features Supported by the Editions of SQL Server 2005 http://msdn2.microsoft.com/en-us/library/ms143761.aspx Editions and Components of SQL Server 2005 http://msdn2.microsoft.com/en-us/library/ms144275.aspx Memory: Hardware and Software Requirements for Installing SQL Server 2005 http://msdn2.microsoft.com/en-us/library/ms143506.aspx Licensing http://www.microsoft.com/sql/howtobuy/default.mspx 1.a Number of records is determined by storage capacity Tag: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...

Doua

Is there an expression syntax that will do this Does it have something to do with ROWNUMBER().

Any help is greatly appreciated! Thanks in advance! Probably an easy one for you gurus out there!

Re: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...

Doua

Figured it out... thanks!

=IIF(ROWNUMBER() <= 5, "Red", IIF(ROWNUMBER()... and so on...

Re: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...

Lisa Nicholls

Good one! But instead of <= you might want to try a Modulus comparison here, right, so that it will keep working without nesting IIF()s I'm thinking something like:

Code Block

= IIF(ROWNUMBER(Nothing) Mod 10 = 0 OrElse
ROWNUMBER(Nothing) Mod 10 > 5, "blue", "red")

>L<

Re: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...

Doua

Can someone point me to webpage that explains all the "Mods" I've seen "Mod 2", now "Mod 10" Thanks!

Re: Shading first 5 rows "red", then next 5 "blue", then next 5 "red", and so on...

Lisa Nicholls

"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<