Solved

Highlight First 10 Rows

Posted on 2014-04-28
7
557 Views
Last Modified: 2014-04-30
Hello,
I am using microsoft sql report builder 3.0 to build my rdlc report and have a basic table on my report that I need to highlight only the first 10 rows of data with a yellow background color.  How can this be done?

Thanks in advance!
0
Comment
Question by:H-SC
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 22

Expert Comment

by:plusone3055
ID: 40027638
http://technet.microsoft.com/en-us/library/aa337198(v=sql.100).aspx

To apply a background color

1.
In Report Builder design mode, select a text box or cell(s).

2.
On the Format menu, click Fill.

The Format dialog box opens with the Fill tab selected.

3.
In the Color area, select a color.

4.
Click OK..
0
 
LVL 1

Author Comment

by:H-SC
ID: 40027647
Sage,
I would only need the first 10 rows to be Yellow.  What would be the expression to do that?
0
 
LVL 22

Expert Comment

by:plusone3055
ID: 40027659
I'm not sure if you could ONLY highlight the first 10 rows.. I know you can Alternate rows
like this

IIF(RowNumber(Nothing) Mod 2 = 0, "Yellow", "White")


you could try the Logic  

IIF(RowNumber(Nothing) Mod <=10 , "Yellow")

but you might be out of luck :(
0
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 
LVL 1

Accepted Solution

by:
jaisy99 earned 500 total points
ID: 40028315
=IIf(RowNumber(nothing)>10,"Transparent","Yellow")

Make sure view properties is checked.
Highlight the entire row.
Find the background fill on the properties box on the right hand side of your screen.
Instead of selecting a color, click expression
Add the above expression.

Hope that helps.
0
 
LVL 1

Author Comment

by:H-SC
ID: 40029432
jaisy99,
Many thanks, this is very close to a solution.  For some reason when I test.  It colors all rows...in the case below it made all of the rows orange.  Any ideas?

=IIf(RowNumber(nothing)<11,"Yellow","Orange")
0
 
LVL 1

Expert Comment

by:jaisy99
ID: 40031023
Hmm, not sure.  I just pasted it into mine and it worked.  You might want to double check that only the detail row was highlighted before you pasted your expression into the Fill Background Color in the properties box.  The reason is that the properties box view changes depending on which area of the report you have highlighted or selected.  For instance, if the entire table is highlighted, then the fill may apply to the whole table.  That is my best guess though.  Sorry not more help.  

The easiest way to highlight the detail row is to click the associated grey portion of the table's border just to the left of your detail cells.  The border is not always visible, you may have to click within the table to view it.

Good luck!
0
 
LVL 1

Author Comment

by:H-SC
ID: 40031887
jaisy99,
Got it!  Many thanks for the explanation.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question