We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

SRS reportitems

T Hoecherl
T Hoecherl asked
on
Medium Priority
490 Views
Last Modified: 2012-05-11
I have some complex values in the third and forth group footer of a report.  It seems like I can only address the values as a ReportItems!name.value.  How can I place the 15 ReportItems values into a chart?  I want to have multiple groups as well.
Comment
Watch Question

CERTIFIED EXPERT

Commented:
Not sure I completely understand your question. Could you add some more information, along with a screenshot of the design of the report as it is now.

You might be able to use this technique:
http://blogs.msdn.com/b/robertbruckner/archive/2008/07/20/using-group-variables-in-reporting-services-2008-for-custom-aggregation.aspx
to set some report variables, and use the values of those variables in the graph.
T HoecherlDeveloper

Author

Commented:
This is a report finding General Ledger Contribution by Department.  There are 12 Departments that accumulate revenue and expenses and 2 departments that allocate expenses.  They would like two charts after the report, 1) Gross Contribution % by Department and Total Gross Contribution % and 2) Net Contribution % by Department and Total Net Contribution %.  I have the needed values in two rows in the Group (year) Footer area.  I am trying to get the results from the Group Footer cell expressions into the charts.  The charts only accept fields from the data set.  Here is an example of the Total Net Contribution % value expression:

=(((Sum(cdec(Fields!Revenue101.Value)) +
Sum(cdec(Fields!Revenue102.Value)) +
Sum(cdec(Fields!Revenue103.Value)) +
Sum(cdec(Fields!Revenue104.Value)) +
Sum(cdec(Fields!Revenue105.Value)) +
Sum(cdec(Fields!Revenue106.Value)) +
Sum(cdec(Fields!Revenue107.Value)) +
Sum(cdec(Fields!Revenue108.Value)) +
Sum(cdec(Fields!Revenue109.Value)) +
Sum(cdec(Fields!Revenue110.Value)) +
Sum(cdec(Fields!Revenue111.Value)) +
Sum(cdec(Fields!Revenue112.Value))  )   -
 (sum(cdec(Fields!Expense101.Value)) +
sum(cdec(Fields!Expense102.Value)) +
sum(cdec(Fields!Expense103.Value)) +
sum(cdec(Fields!Expense104.Value)) +
sum(cdec(Fields!Expense105.Value)) +
sum(cdec(Fields!Expense106.Value)) +
sum(cdec(Fields!Expense107.Value)) +
sum(cdec(Fields!Expense108.Value)) +
sum(cdec(Fields!Expense109.Value)) +
sum(cdec(Fields!Expense110.Value)) +
sum(cdec(Fields!Expense111.Value)) +
sum(cdec(Fields!Expense112.Value))  ))+
 (Sum(cdec(Fields!Expense160.Value)) * -1) +
 (Sum(cdec(Fields!Expense150.Value)) * -1)) /
 (Sum(cdec(Fields!Revenue101.Value)) +
Sum(cdec(Fields!Revenue102.Value)) +
Sum(cdec(Fields!Revenue103.Value)) +
Sum(cdec(Fields!Revenue104.Value)) +
Sum(cdec(Fields!Revenue105.Value)) +
Sum(cdec(Fields!Revenue106.Value)) +
Sum(cdec(Fields!Revenue107.Value)) +
Sum(cdec(Fields!Revenue108.Value)) +
Sum(cdec(Fields!Revenue109.Value)) +
Sum(cdec(Fields!Revenue110.Value)) +
Sum(cdec(Fields!Revenue111.Value)) +
Sum(cdec(Fields!Revenue112.Value)) ))
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.