Link to home
Start Free TrialLog in
Avatar of H-SC
H-SCFlag for United States of America

asked on

Highlight First 10 Rows

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!
Avatar of plusone3055
plusone3055
Flag of United States of America image

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..
Avatar of H-SC

ASKER

Sage,
I would only need the first 10 rows to be Yellow.  What would be the expression to do that?
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 :(
ASKER CERTIFIED SOLUTION
Avatar of jaisy99
jaisy99

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of H-SC

ASKER

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")
Avatar of jaisy99
jaisy99

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!
Avatar of H-SC

ASKER

jaisy99,
Got it!  Many thanks for the explanation.