For each row in a detail section, I need the field value from the same field in the previous row to calculate the difference. Is this possible and if yes, how?
3 Answers, 1 is accepted
answered on 21 Sep 2012, 04:28 PM
Such operations are far easier in SQL and therefore it will be best if you perform them there. The snippet may look like this:
select t1.value - t2.value from table t1, table t2
where t1.primaryKey = t2.primaryKey - 1
Of course you may want to order the query as the results may be unexpected otherwise. Name the resulting value to use it in your report easily.
If you are not using sql data source this task can be even easier and performed in code for example.
the Telerik team
BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >