Solved

Highlight First 10 Rows

Posted on 2014-04-28
7
482 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
  • 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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
This video discusses moving either the default database or any database to a new volume.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

705 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now