how to sum two database field connected in my report by csharp code on before print event

Question

csharp

Answer 1

Hi, whenever you declared a select query in the c# code add 2 columns like this

1. if you are adding 2 fields from one table:
SELECT *,(field1 + field2) AS fieldname FROM Table;

2. if you are adding 2 fields from 2 tables:
SELECT table1.field1, table2.field1, table2.field2, table1.field2, (table1.field1 + table2.field1) as newfieldname
FROM table1
INNER JOIN table2
ON table1.field2 = table2.field2;

Answer 2

hi i am scriping in DevXpress XtraReport designer in my Autocount accounting software so how do i declare a select query