Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Galopper
Starting Member
12 Posts |
 Posted - 2011-02-02 : 06:12:23
|
| Hi there!In a report I would like to show a conversion rate which is calculated from two values which are in the produced table. The values are not totals, they are values that can change per page-call and form these values totals are calculated. The calculation therefore should not take place in the query designer, it should take place in the report itself.Example tableName || Value-----------------------------------Start page || 100Page 2 || 50Page 3 || 25Endpage || 20Endpage 2 || 5 Conversion: 20/100*100How do I get the first (the 100 (for the Startpage) value and the last value (endpage , 20) in an expression as a variable (place holder) and from that then calculate conversion? The calculation cannot be done in the query designer, it must be calculated in the report itself.I hope I have described my problem clearly enough. The problem seems trivial nonetheless I can’t find a solution.Thanx in advance!Eddy |
|
|
|
|
|
Calculated Value in a report