Aggregate functions can be used only on report items contained in page headers and footers : using aggregate on aggregate function in expression

Question

0.00/5 (No votes)

See more:

Hello people

I have a problem, I would like to calculate an expression and it is not allowed in RDLC I would like to know if there is another way.

I have a table with two columns, where [Coluna1] = 17 is from database, Coluna2 = Coluna1 * 25000, I would like to get the total of Coluna2, but it is giving the following error: Aggregate functions can be used only on report items contained in page headers and footers : Using Aggregate on Aggregate function in Expression

Thank you

What I have tried:

=Sum(reportitems!coluna2)

Posted 12-Jan-21 4:49am

Member 14669973

Updated 13-Jan-21 8:40am

Add a Solution

Comments

Maciej Los 13-Jan-21 2:20am

If Coluna2 = Coluna1 * 25000 then =SUM(Coluna1 * 25000).

Member 14669973 13-Jan-21 4:02am

hey morning!

I'm using reportview (Rdlc) on VB.net, where am I supposed Apply this code?

I have been tried this:

Public Total_lookup_Sum As Integer = 0

Public Function Lookup_Sum(ByVal value As Integer) As Integer

Total_lookup_Sum = Total_lookup_Sum + value

Return value

End Function

=Code.Lookup_Sum(Fields!Divida.Value*Fields!Taxa.Value) in page property

and this: =Code.Total_lookup_Sum in TotalTextBox

But i di

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2021-01-12T19:17:00

Solution 1

You can write custom function for that. Below one has sample code with screenshots which's simple. You need to customize code based on your requirement
Aggregate functions can be used only on report items contained in page headers and footers : Using Aggregate on Aggregate function in Expression | Ashwani.Ashwin[^]

Posted 12-Jan-21 19:17pm

thatraja

Comments

Maciej Los 13-Jan-21 4:09am

5ed!

Member 14669973 · Answer 2 · 2021-01-13T08:40:00

first of all thanks for everything,

I couldn't use this code but, I managed to find another way to get around and give the right result

what i did is opening a new column and that stayed like

Column1=17(Result From Database)

column2=25000(Result From Database)(Hided)

Column3(Total)=Fields!Column1.Value*Fields!column2.Value

Column4(Total)=Sum(Fields!Column1.Value)*(Fields!column2.Value)

and i Hide the Column2