How to refer text box

lakshanvindana

hi guys,

please let me know a solution.

i have a table in RTC body. let say i have a textbox in table called A.
i need to refer the A textbox in same table (in body).

how i can do that?

Thanks...

mohana_cse06

Can you be more clear what you want to do?

Are you a technical person or customer?

lakshanvindana

Thanks for reply
im a technical person

RTC - body

---

textbox name : A
textbox value : Sum(fields!ABC.Value)

textbox name : G
textbox value : < here i want to refer A >

without placing Sum(fields!ABC.Value), i need to refer textbox A, and get the textbox value.
how to do that?

more ex;
i can refer A in Header like ReportItems!A.Value know, like that, is there any way?

mohana_cse06

Why you want to do without Sum(fields!ABC.Value)??

lakshanvindana

2 reasons,

1. if put Sum(Last(Fields!ABC.Value)), then it wont work.
2. i have another calculation

are you clear with my issue ?

mohana_cse06

What about doing all your calculations in classic and just flowing the value with a text box?

I dont think you can refer the value with text box name..

lakshanvindana

yes, can't refer from text box name, tried several ways, couldn't found any (simple way) yet.

thanks Mohana
:thumbsup:

Troubles_In_Paradise

lakshanvindana wrote:

Thanks for reply
im a technical person

RTC - body

---

textbox name : A
textbox value : Sum(fields!ABC.Value)

textbox name : G
textbox value : < here i want to refer A >

without placing Sum(fields!ABC.Value), i need to refer textbox A, and get the textbox value.
how to do that?

more ex;
i can refer A in Header like ReportItems!A.Value know, like that, is there any way?

you can use ReportItems also in the body. And you can do calculation on values called from the other textbox.
You have to pay attention to the grouping because you can "call" only a textbox on the same level of grouping or a textbox "grouper".

lakshanvindana

could you please give me an example.

Troubles_In_Paradise

lakshanvindana wrote:

could you please give me an example.

simply:
MyDecField.Value = 123,00

TextboxA = Fields!MyDecField.Value
TextboxB = ReportItems!TextboxA.Value + 2

in TextboxB you will have 125.00

Is this what you ask?

lakshanvindana

thanks,

cannot use REPORTITEM in report body, this is the issue

Troubles_In_Paradise

lakshanvindana wrote:

thanks,

cannot use REPORTITEM in report body, this is the issue

Are you sure? Because before suggesting it I tried and it works for me.
Could you post a screenshot of what you've tried so far?

lakshanvindana

may be you used it in header

Troubles_In_Paradise

Troubles In Paradise wrote:

you can use ReportItems also in the body. And you can do calculation on values called from the other textbox.
You have to pay attention to the grouping because you can "call" only a textbox on the same level of grouping or a textbox "grouper".

This is the error that refers to what I said you in my previous post.
The error doesn't say "You can't use ReportItems" it's only a problem of report structure (read carefully the error).
If you create 2 textboxes and call the second from the first with ReportItems!SecondName.Value you will see that ReporItems works.
After this you have to change your report's design in order to obtain what you want.

lakshanvindana

correct, can use in same group, but cannot use out of it.

Troubles_In_Paradise

lakshanvindana wrote:

correct, can use in same group, but cannot use out of it.

:-k another suggestion... you could try to save the value in a global variable and then use this variable for your calculation (VB script function directly in VS).