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 |
|
tech2
Yak Posting Veteran
51 Posts |
 Posted - 2013-10-16 : 15:30:04
|
| Hi,I'm trying to reference a cell with a 'Total' from 'DataSet5' to 'DataSet1'The cell with the 'Total' is in 'Textbox32', in 'DataSet5' and I'm trying to copy this value in 'Textbox24', in 'DataSet1.I've tryed several expressions but can't find one that will work. Below is an example.=(ReportItems![Textbox32].Value,"DataSet5")Any help would be highly appreciated. SSRS 2008 R2Thanks, |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-17 : 04:35:52
|
| You cant use the items outside scope where its defined. Are they both inside same container?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
tech2
Yak Posting Veteran
51 Posts |
Posted - 2013-10-18 : 14:49:21
|
| The expression is below:=(ReportItems!Textbox24.Value)-(ReportItems!Textbox56.Value) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-20 : 03:54:05
|
| I was asking on the scope. Are Textbox24 and Textbox56 inside same container? (table/matrix)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
ReportItems