In ssrs report I need to sum the net text box

Question

In ssrs report I need to sum the net text box

Anonymous

I have an SSRS report that gives me the sum of transactions per product but the net calculation per transaction case calculation is the sum of the text box - the sum of another box using report items but when I go to sum the grand total of all net transaction and use sum(ReportIytems !Net) I get an error.I need grand total of net. Not sure how to accomplish the end results. Please review the image.

net sum from ReportItwms!

Anonymous

2023-07-01T23:27:21.17+00:00

1 answer

Your answer

Answer 1

Anonymous

Hi @Jannette Jones

What is the error when you run it?

I did a simple test, calculating the total of Reviser and Operator. The two totals are then added using "=reportitems!Textbox75.value+reportitems!Textbox76.value" without error.

Screenshot 2023-07-03 103141

Screenshot 2023-07-03 103216

Are you referring to the name of the report item correctly?

Best regards,

Aniya

Anonymous

2023-07-03T18:18:22.38+00:00

it hasn't given me the right answer in the text box I need to basically sum all values in the net column

I need the net sum to a = the grand total of the sum. The number supposes

to be a different amount.
Anonymous

2023-07-04T01:50:03.7466667+00:00

Hi @Jannette Jones

I seem to understand your design.

So this net sum should be equal to [Sum(fee)] minus the sum of discounts. I don't know what your discount expression is, can you use the field values to calculate their total? Aggregates containing report items can only be used in headers or footers.

Best regards,

Aniya
Anonymous

2023-07-04T03:17:21.0166667+00:00

Mt disc expression is =IIF(IIF(Fields!ProductID.Value = "NON-STANDARD Manual Product",0,Fields!Disc.Value) = 0, 0, IIF(Fields!ProductID.Value = "NON-STANDARD Manual Product",0,Fields!Disc.Value))
Anonymous

2023-07-04T03:18:13.1333333+00:00

is there way to just sum(ReportItems!TotalCharge1.Value)?
Anonymous

2023-07-04T05:33:27.16+00:00

Hi @Jannette Jones

Sum(ReportItems!TotalCharge1.Value) needs to be placed in the header and footer before it can be used. You might try [Sum(fee)]+sum(disc expression).

You can also try to use custom code, you can refer to this link: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d4a3969a-f3fc-457b-8430-733d7b590ff6/use-reportitems-to-sum-all-textboxes-in-a-tablix?forum=sqlreportingservices.

Best regards,

Aniya

Share via

In ssrs report I need to sum the net text box

1 answer

Your answer