i have weekly report totals anywhere 200 - 1000 rows of data. accounting people, total value of import use accrual purposes. either have total appear @ top of report or in separate text box indicating total report. have idea on how accomplish this?
if understand correctly need result of aggregate function on tablix shown in textbox outside tablix.
that can achieved placing textbox anywhere on report, , in expression textbox add reference dataset need aggregate, e.g.:
=sum(fields!somevalue.value, "mydataset") where somevalue name of field need aggregate, , mydataset name of dataset fieldis in.
Comments
Post a Comment