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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics