I have 2 expression column in my tablix. They contain an expression that multiples two column.I want to show the sum of this expression column in footer in two textboxes as sum for first expression column and sum for second expression column also i want to show result in every page or last page.presently i did so with reportItem! but it will not work for every page.
running value and lastvalue worked for it
yes u r right and i want to show the total of those two column in the last page but it is showing total according to per page line like if i am having 5 lines in fist page and amount is 100 then first page 500 and if 3 lines in next page then 300 in next. how can i obtain 800 in last page.
Hi sharudas,
Could you share a screenshot of your current report with more detailed description if possible?
It would be helpful for me to understand your report appearance/layout better.
Below is my understanding based on what you've described.
| Product Name | Shipments | Cost ($) | Price ($) | Total Sale | Total Profit |
|---|---|---|---|---|---|
| TV | 120 | 150 | 300 | 36000 | 18000 |
| Washing Machine | 100 | 250 | 500 | 50000 | 25000 |
| Oven | 80 | 50 | 150 | 12000 | 8000 |
| 98000 | 51000 |
Do you want to E5(98000) and F5(51000) are always fixed on report bottom/footer?
(and would them be your 2 expression columns?)
Thanks.
Regards,
Clofly
#1
Siv Sagar
149
Super User 2025 Season 1
#2
Daivat Vartak (v-9d...
53
Super User 2025 Season 1
#3
Vahid Ghafarpour
32
Super User 2025 Season 1
Share
Report
All responses (
Answers (
