Thanks for your posting. Can you please let us know what type of report you are using? Are you using Matrix report? I mean How you are displaying the information the line above # Store BOM .
What does the rownumber line displaying?
Thanks for your posting. Let say you have column group with month so you can write expression for the textbox # Store BOM fill colour like this
If you have any question please let me know.
A screenshot for your help
Syed Qazafi Anjum
- Proposed as answer by Sanjeewan Kumar Thursday, November 22, 2012 3:09 PM
This does not solve my issue as your the "1" in your "iif(Fields!month.Value>1" is constant. I need the shading to occur dynamically based on the current month No. Becasue these are fiscal months and cant use date math as Jan which is the last fiscal month < the current calendar month of Nov. This is way im trying to use a rownumber in some way.
- Edited by fountainhead7 Wednesday, November 21, 2012 9:28 PM
What's the data type of the “Month” field? If it is Date type, then please refer to the following expression:
=IIF(DateDiff(“m”,First(Fields!Month.Value), Fields!Month.Value)>=0 and DateDiff(“m”,Fields!Month.Value, now())<0),"Gray","White”)
=IIF(DateDiff(“m”,First(Fields!Month.Value), Fields!Month.Value)>=0 and DateDiff(“m”,Fields!Month.Value, now())<0),"Gray","White")
TechNet Community Support