H-SC
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!
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!
ASKER
Sage,
I would only need the first 10 rows to be Yellow. What would be the expression to do that?
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 :(
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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")
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
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!
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!
ASKER
jaisy99,
Got it! Many thanks for the explanation.
Got it! Many thanks for the explanation.
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..