June 25, 2012 at 12:05 pm
hi
i have to use = iif((Fields!Market.Value/SUM(Fields!Market.Value,"dataset1")) * 100 )= 0.0
in my filter,
it gives me error like aggregate function cannot use in a filter.
is there any other way ,i can use this expression in filter
June 25, 2012 at 12:17 pm
Additional que, there is group in tablix,
if i put this filter in group ,its works fine,but thw whole group is invisible.
i just want one row to be invisible.
how to do that
June 26, 2012 at 1:55 am
Can't you try with the visibility of the row, and instead of recalculating the values, refer to the textboxes which contain the values needed?
For example:
= Iif((ReportItems!MarketTextbox.Value / ReportItems!SumMarketTextbox.Value) * 100 = 0, True, False)
It's best to give the textboxes (which you need in this expression) a proper and clear name.
Does this do the trick ?
June 26, 2012 at 8:35 am
its working
thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply