Hello,
If I have a text box with the following value : =Sum(Fields!Sales.Value)
Can I then in another text box write something like:
=textbox30.Value + textbox50.Value
Is this possible?Try:
=ReportItems!textbox30.Value + ReportItems!textbox50.Value
--
-- John H. Miller [MSFT]
-- SQL Server BI Product Group
----
--
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
----
--
"ashvsaod" <ashvsaod@.hotmail.com> wrote in message
news:em00MfcdEHA.3412@.TK2MSFTNGP11.phx.gbl...
> Hello,
> If I have a text box with the following value : =Sum(Fields!Sales.Value)
> Can I then in another text box write something like:
> =textbox30.Value + textbox50.Value
> Is this possible?
>|||When I do this I receive the following error:
The value expression for the textbox 'WIP_4' refers to the report item
'Textbox30'. Report item expressions can only refer to other report items
within the same grouping scope or a containing grouping scope.
So what can I do now? I must admit I don't even know what this means.
"John H. Miller" <jhmiller@.online.microsoft.com> wrote in message
news:410994a0$1@.news.microsoft.com...
> Try:
> =ReportItems!textbox30.Value + ReportItems!textbox50.Value
> --
> -- John H. Miller [MSFT]
> -- SQL Server BI Product Group
> ----
--
> --
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> ----
--
> --
> "ashvsaod" <ashvsaod@.hotmail.com> wrote in message
> news:em00MfcdEHA.3412@.TK2MSFTNGP11.phx.gbl...
> > Hello,
> >
> > If I have a text box with the following value : =Sum(Fields!Sales.Value)
> >
> > Can I then in another text box write something like:
> >
> > =textbox30.Value + textbox50.Value
> >
> > Is this possible?
> >
> >
>|||You can find some details on how scope works in RS BOL - see
http://msdn.microsoft.com/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_1l6b.asp
--
-- John H. Miller [MSFT]
-- SQL Server BI Product Group
----
--
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
----
--
"ashvsaod" <ashvsaod@.hotmail.com> wrote in message
news:u3R3ZBddEHA.1644@.tk2msftngp13.phx.gbl...
> When I do this I receive the following error:
> The value expression for the textbox 'WIP_4' refers to the report item
> 'Textbox30'. Report item expressions can only refer to other report items
> within the same grouping scope or a containing grouping scope.
> So what can I do now? I must admit I don't even know what this means.
> "John H. Miller" <jhmiller@.online.microsoft.com> wrote in message
> news:410994a0$1@.news.microsoft.com...
> > Try:
> >
> > =ReportItems!textbox30.Value + ReportItems!textbox50.Value
> >
> > --
> > -- John H. Miller [MSFT]
> > -- SQL Server BI Product Group
> ----
> --
> > --
> > "This posting is provided 'AS IS' with no warranties, and confers no
> > rights."
> ----
> --
> > --
> >
> > "ashvsaod" <ashvsaod@.hotmail.com> wrote in message
> > news:em00MfcdEHA.3412@.TK2MSFTNGP11.phx.gbl...
> > > Hello,
> > >
> > > If I have a text box with the following value :
=Sum(Fields!Sales.Value)
> > >
> > > Can I then in another text box write something like:
> > >
> > > =textbox30.Value + textbox50.Value
> > >
> > > Is this possible?
> > >
> > >
> >
> >
>|||Yeah, I found it and all is solved. Thanks for all the assistance.
"John H. Miller" <jhmiller@.online.microsoft.com> wrote in message
news:4109b720$1@.news.microsoft.com...
> You can find some details on how scope works in RS BOL - see
>
http://msdn.microsoft.com/library/en-us/RSCREATE/htm/rcr_creating_expressions_v1_1l6b.asp
> --
> -- John H. Miller [MSFT]
> -- SQL Server BI Product Group
> ----
--
> --
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> ----
--
> --
> "ashvsaod" <ashvsaod@.hotmail.com> wrote in message
> news:u3R3ZBddEHA.1644@.tk2msftngp13.phx.gbl...
> > When I do this I receive the following error:
> >
> > The value expression for the textbox 'WIP_4' refers to the report item
> > 'Textbox30'. Report item expressions can only refer to other report
items
> > within the same grouping scope or a containing grouping scope.
> >
> > So what can I do now? I must admit I don't even know what this means.
> >
> > "John H. Miller" <jhmiller@.online.microsoft.com> wrote in message
> > news:410994a0$1@.news.microsoft.com...
> > > Try:
> > >
> > > =ReportItems!textbox30.Value + ReportItems!textbox50.Value
> > >
> > > --
> > > -- John H. Miller [MSFT]
> > > -- SQL Server BI Product Group
> >
> ----
> > --
> > > --
> > > "This posting is provided 'AS IS' with no warranties, and confers
no
> > > rights."
> >
> ----
> > --
> > > --
> > >
> > > "ashvsaod" <ashvsaod@.hotmail.com> wrote in message
> > > news:em00MfcdEHA.3412@.TK2MSFTNGP11.phx.gbl...
> > > > Hello,
> > > >
> > > > If I have a text box with the following value :
> =Sum(Fields!Sales.Value)
> > > >
> > > > Can I then in another text box write something like:
> > > >
> > > > =textbox30.Value + textbox50.Value
> > > >
> > > > Is this possible?
> > > >
> > > >
> > >
> > >
> >
> >
>
No comments:
Post a Comment