Totaling up the Grand Total

[ajpetersen]

This should be easy enough, but it has been killing me. I have done my homework, but have yet to find a solution.

See attachments for the report I am working on. I figured screen shots would be the best way to explain it.

Everything is working fine expect the Grand Total Sales Price. Although I am not happy with the way I get the Grand Total Number of Sacks (using for each statements), its all I know. If you know of a better way to do it, please let me know.

For Grand Total Sales I have tried a few different things but nothing has worked. I have tried =Sum(txtTotalSales.Value), =Sum(Sum(Fields.NumberOfSacks) * Fields.Ticket.TagPrice), and the for each statement in the codebehind.png.

BTW if it helps, the data types in the database are:
TagPrice: money
NumberOfSacks: float

Any feedback would be greatly appreciated! Thanks!

[ajpetersen]

I have been working on this all yesterday and this morning and I am still unable to figure it out. Any ideas? I hope to get this figured out by this week.

Thanks in advance,

[IvanDT]

Hello Claude,

The following Grand Total Number that you are describing can be achieved without using any code, we have attached a sample report which illustrates your case based only on the provided screenshots. We suggest to take a look at the following help articles which will help you deal with the functions and user aggregates:

• Expression;
• Using Expressions;
• Extending Expressions.

Kind regards,
IvanDT
the Telerik team