Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 610
  • Last Modified:

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!
0
H-SC
Asked:
H-SC
  • 3
  • 2
  • 2
1 Solution
 
plusone3055Commented:
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
 
H-SCAuthor Commented:
Sage,
I would only need the first 10 rows to be Yellow.  What would be the expression to do that?
0
 
plusone3055Commented:
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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
jaisy99Commented:
=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
 
H-SCAuthor Commented:
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
 
jaisy99Commented:
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
 
H-SCAuthor Commented:
jaisy99,
Got it!  Many thanks for the explanation.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now