SSRS 2008 - Need to Sum(ReportItem...)
...Except, here's the snag.
It's a Fetch-XML report, destined for CRM2011 in the cloud. (Or should that be "on the cloud?" *shrug* )
I've got the mother of all complex expressions already (350+ lines, references two other report items in the detail row).
Cannot use another dataset.
Cannot use custom code.
I need to "merely" Sum() the total in a group footer of a table.
However, I cannot (naturally) use Sum(ReportItem!MyExpressionControl.Value) as SSRS does not like that.
Are there any workarounds I can use to total up my ridiculously complex expression from my detail row of my table?
(Without using custom code or any SQL - as it's a cloud report and I cannot use those).
My head-scratching is wearing me out.
Cheers!
~J
March 21st, 2011 10:31am