I have groupings in which the first column of each new group hides duplicates
(all in one report). I would like the first listing (row) of each new group
to be highlighted (i.e. the one without the hidden field).
Is there any way to accomplish this task?you might test to see if a value in the table is = the min of a column's values (if your data is ordered on one of your columns)
you could also include a rowtype column in your datasource to examine
Your hidden expression would be like:
=iif(Fields!fieldsortedby.value = min(Fields!fieldsortedby.value),false,true)
--
Message posted via http://www.sqlmonster.com
Wednesday, March 7, 2012
Conditional formatting when visability = True or False
Labels:
column,
conditional,
database,
duplicates,
false,
formatting,
group,
groupings,
hides,
listing,
microsoft,
mysql,
oracle,
report,
row,
server,
sql,
visability
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment