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 |
|
Serge
Starting Member
44 Posts |
 Posted - 2008-03-05 : 05:27:19
|
| Hi,I am trying to pass values from one textbox to another so for example in textbox2 in expression field I write the following: "=Fields!textbox1.Value". I keep getting error saying: "the expression can only refer to fields within the current data set scope ..."Can someone please let me know how do I do it?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-05 : 05:44:29
|
| Use ReportItems!textbox1.value. But make sure those two textboxes are in same scope. |
 |
|
|
Serge
Starting Member
44 Posts |
Posted - 2008-03-05 : 05:54:25
|
| Thank you very much!Sorry dumb question, how do you set scope of a text box??? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-05 : 08:55:17
|
| the scope of textbox is automatically set as container which contains it. |
|
|
|
Serge
Starting Member
44 Posts |
Posted - 2008-03-05 : 09:17:40
|
| The textbox is inside reports body... Its not iside any containers... So what scope is it set to? |
|
|
|
MikeM
Starting Member
6 Posts |
Posted - 2008-09-30 : 12:41:08
|
| New question on this same subject. Can a person incapsulate all the report into the same scope so all ReportItems from the groups can be used in expressions at the end of the report? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-30 : 13:57:46
|
quote:
Originally posted by MikeM
New question on this same subject. Can a person incapsulate all the report into the same scope so all ReportItems from the groups can be used in expressions at the end of the report?
didnt get that. can you elaborate? |
|
|
|
MikeM
Starting Member
6 Posts |
Posted - 2008-09-30 : 16:40:55
|
| When I try and perform a expression such as =ReportItems!textbox1 / ReportItems!textbox2 where textbox1 in grouping group_1 and textbox2 is in the footer row (expression in the footer row), I get an error that both textboxes have to be in the same group and scope. I wondering if I could possible do this by somehow saving the value of these two textboxes to a variable after the values have been computed. Is what I described possible? |
|
|
|
|
|
|
Passing values between textboxes