I have a Table in Rdlc report with 6 Columns and a dataset. A dll is added ( referenced ) to the Report, named RepHlpr.dll. This dll have a shared function GetPar which calculates and gets data from other databases. Column Amount is working fine and getting data as per the expression, As :
While getting Sum of Copper and HP, Everything Works fine because these column gets values from dataset.
I am getting problem to get Sum of Values of Amount. I have tried Expressions :
=Sum(Textbox44.Value)
=Sum(ReportItems!Textbox44.Value)
=Sum(Table1.Textbox44.Value)
But Its showing Error : Textbox48 ( in which above expression is coded ) uses an aggregate function on a report item. Aggregate functions can be used only on report items contained in page headers and footers.
Is there any way to get Sum of Column Amount ?
Best Answer
You can apply Sum on your formula of that textbox instead of trying to apply it on the value of textbox:
For example if name of your report data set is
"DataSet1"
Example
I created a
Code
function:Then I set expression for my extra column that is not data bound:
Then I added a
TextBox
and set itsSum
expression based on my custom column expression:And here is the screenshot: