Hi,
I am using table in which I have Items, quantity and price. I have set the datasource of my table using stored procedure. My tables resides in the detail section. After that I placed a textbox control in the report footer section to calculate the total quantity. By using the following expression.
=Sum(Fields.Quantity). But total doesn't appear in the report.
Expalanation in Steps:
1) Table is placed in a detail section (bind with a stored procedure)
2) Textbox in a report footer section to display total. (not appearing in the report) =Sum(Fields.Quantity)
Items Quantity Price Total
ItemA 2 10 20
ItemB 3 5 15
5 (It is a textbox in a report footer section but it's not displaying the total quantity and appears blank in a report)
I am using table in which I have Items, quantity and price. I have set the datasource of my table using stored procedure. My tables resides in the detail section. After that I placed a textbox control in the report footer section to calculate the total quantity. By using the following expression.
=Sum(Fields.Quantity). But total doesn't appear in the report.
Expalanation in Steps:
1) Table is placed in a detail section (bind with a stored procedure)
2) Textbox in a report footer section to display total. (not appearing in the report) =Sum(Fields.Quantity)
Items Quantity Price Total
ItemA 2 10 20
ItemB 3 5 15
5 (It is a textbox in a report footer section but it's not displaying the total quantity and appears blank in a report)
1 Answer, 1 is accepted
0
Hi Muhammad,
You cannot use "=Sum(Fields.Quantity)" expression in a value of textbox because the datasource of the table is not "visible" for your textbox and the value will be always evaluated to NULL. This is the reason you cannot see anything when you render the report.
If you want to get the sum of this field you should add "Total" row as the last row of your table.
How to add "Total" in your table is elaborated in the following help resource:
I hope this will help you find a solution to your problem.
Greetings,
Hristo
the Telerik team
You cannot use "=Sum(Fields.Quantity)" expression in a value of textbox because the datasource of the table is not "visible" for your textbox and the value will be always evaluated to NULL. This is the reason you cannot see anything when you render the report.
If you want to get the sum of this field you should add "Total" row as the last row of your table.
How to add "Total" in your table is elaborated in the following help resource:
I hope this will help you find a solution to your problem.
Greetings,
Hristo
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Public Issue Tracking
system and vote to affect the priority of the items