Page 1 of 1
Sum of a table column(Expression)
Posted: Mon Feb 22, 2016 1:42 pm
by 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
Re: Sum of a table column(Expression)
Posted: Tue Feb 23, 2016 7:51 am
by 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.
Re: Sum of a table column(Expression)
Posted: Tue Feb 23, 2016 3:03 pm
by 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 3186 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
Re: Sum of a table column(Expression)
Posted: Wed Feb 24, 2016 1:04 pm
by Alex K.
Hello,
Can you please send us a simple report with test data which reproduce the issue for analysis.
Thank you.