Sum of a table column(Expression)

[hadipour]

hi
i have a table with a column that its Expression Column not a database(Datasource) column

Code: Select all

{FactorDetail.TotalPrice+(FactorDetail.TaxPercent*FactorDetail.TotalPrice/100)}

and i need to sum this column but cant use your summery function because it just work with database(Datasource) orginial column (that load in the summery function box data band and data column combo box) not a expression column .
how can i get sum of a table column that is expression type
i tried to work with table cell name but summery function didn't accept it ...

thx

[HighAley]

Hello.

What version of our product do you use?
Please, try to use the sample expression if Sum function.
If this does not help, could you send us a sample report template with data that reproduces the issue?

Thank you.

[hadipour]

Hi
to resolve this problem at first i send the expression column that i need from controller(mvc) to stimulsoft with sql query and in stimulsoft i created a column in my datasource and used it in my sum function...
After your reply i looked to your documentation and i used a calculated column as a second way to use sum function...
my problem was with a table column that was expression type, not a column that specified in datasource columns and sum function can only work with specified column in datasource .

Untitled.jpg (77.5 KiB) Viewed 3180 times

i don't know is that possible to add this ability to work with sum function and expression column that isn't specified in datasource or not but my problem solved.
thank you

[Alex K.]

Hello,

Can you please send us a simple report with test data which reproduce the issue for analysis.

Thank you.