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 |
|
Seth.Gering
Starting Member
1 Post |
 Posted - 2011-08-17 : 01:40:34
|
Is there a way to reference values in a grouped dataset in SSRS? I am trying to get a calculated value from grouped values, however none of the methods I've tried seems to generate the correct value. The data are grouped vertically and horizontally and are similar to the following. The grouping works fine, but getting the values from the fields seems to be tricky.------Group1 Group2 CalculationGroupA---0.5---4.0---(2A-1A) or 4.0-0.5GroupB---2.0---3.0---(2B-1B) or 3.0-2.0*If the image gets published, below is another example. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-17 : 04:09:46
|
| you can use like=ReportItems!Group2Textboxname.value - ReportItems!Group1Textboxname.value------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Get calculation from grouped value in SSRS