• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 473
  • Last Modified:

SRS reportitems

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.
0
T Hoecherl
Asked:
T Hoecherl
  • 2
1 Solution
 
Nico BontenbalCommented:
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.
0
 
T HoecherlDeveloperAuthor 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)) ))
0
 
Nico BontenbalCommented:
I think the easiest way to do this is adding two more data sets to the report. These data sets hold the data for the two graphs. So these queries perform the same calculations and aggregations you have on the two rows in the footer.
I understand it is frustrating that you'll have to do the calculations again while the data is already there, but i think getting this data into a graph is much more complicated than creating two more queries.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now