Last post Jul 16, 2013 01:56 PM by Aaron K. Clark
May 26, 2010 07:19 AM|Peter Schwennesen|LINK
When making a Table Report, I can add a Sum to to each Columns.
After this I manually add a new Column. In this column I make some Calculations based on values found in some of the other columns in my Table report. Thease calculations are performed correct. I am using code like
=ReportItems!TextBox_xxx.Value to get the code from the other text boxes.
But now I will add a sum also to the Column I have manually added, but I get the error message:
reporting Services aggregate function
May 26, 2010 08:40 AMfirstname.lastname@example.org|LINK
May 26, 2010 09:09 AM|Peter Schwennesen|LINK
Hi and Thanks for the answer. But I still get an error.
[rsAggregateReportItemInBody] The Value expression for the textrun 'Textbox_ONormWeight_Total_SubID.Paragraphs.TextRuns' uses an aggregate function on a report item. Aggregate functions can be
used only on report items contained in page headers and footers.
May 27, 2010 01:19 AMemail@example.com|LINK
Instead of that try =sum(Fields!Column3.Value) in sum textbox
May 27, 2010 05:47 AM|Peter Schwennesen|LINK
Hi and thanks for the answer, but unfortunaltely this is also not working.
The TextBox does not contain any Fields information that I can access. But it contains an expression.
The build in Aggregate funtions seems to work only on the Fields directly found in my dataset.
What I have in my text box named TextBox_3 is an expression based on some of the Fields and sum information.
I want to be able to sum these values in the same way as the aggreage funtions are summing the Fields information.
But the 2 sugestions you have menioned return only errors telling me that:
[rsAggregateReportItemInBody] The Value expression for the textrun 'Textbox_ONormWeight_Total_SubID.Paragraphs.TextRuns' uses an aggregate function on a report item. Aggregate functions can be used only on report items contained in page headers
Jun 01, 2010 11:01 PM|You-Hu Fu|LINK
In the Column3 you created, please type in the expression =Fields!datafield1.value/ Fields!datafield2.value
rather than =ReportItems!TextBox_1.Value/ReportItems!TextBox_2.Value Here datafield1 and datafield2 is just the datafields in TextBox_1 and TextBox_2 separately. Then design the report as your previous steps.
Jun 19, 2010 08:57 AM|Peter Schwennesen|LINK
Thanks for the try to help me but I do still not have any luck making what I want. I have made a small example.
I have filled a Table as shown. The [Mode] is from a DataSet.
the <<Expr>> is =Fields!Mode.Value/Sum(Fields!Mode.Value, "DataSetTest")
This results in:
I now want to sum all the rates and end up with x.xx = 1.00
but suggestions already received does not work. I have named the Text box "Rate"
Jul 16, 2013 01:56 PM|Aaron K. Clark|LINK
This particular fix worked for me. But it was dropping the decimal places.
Any reason why?