How to refer text box

lakshanvindana · 2011-11-02

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 · 2011-11-02

Can you be more clear what you want to do?

Are you a technical person or customer?

lakshanvindana · 2011-11-02

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 · 2011-11-02

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

lakshanvindana · 2011-11-02

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 · 2011-11-02

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 · 2011-11-02

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

thanks Mohana
:thumbsup:

Troubles_In_Paradise · 2011-11-02

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 · 2011-11-04

could you please give me an example.

Troubles_In_Paradise · 2011-11-04

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 · 2011-11-09

thanks,

cannot use REPORTITEM in report body, this is the issue

Troubles_In_Paradise · 2011-11-09

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 · 2011-11-09

may be you used it in header

Troubles_In_Paradise · 2011-11-09

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 · 2011-11-23

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

Troubles_In_Paradise · 2011-11-23

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).

Howdy, Stranger!

Quick Links

Categories

How to refer text box

Answers