How to refer text box

lakshanvindana
Member Posts: 79
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...
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...
Lakshan Kulawansa
ERP Consultant - MS Dynamics NAV
https://lk.linkedin.com/pub/lakshan-vindana-kulawansa/37/2a2/592
ERP Consultant - MS Dynamics NAV
https://lk.linkedin.com/pub/lakshan-vindana-kulawansa/37/2a2/592
0
Answers
-
Can you be more clear what you want to do?
Are you a technical person or customer?0 -
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?Lakshan Kulawansa
ERP Consultant - MS Dynamics NAV
https://lk.linkedin.com/pub/lakshan-vindana-kulawansa/37/2a2/5920 -
Why you want to do without Sum(fields!ABC.Value)??0
-
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 ?Lakshan Kulawansa
ERP Consultant - MS Dynamics NAV
https://lk.linkedin.com/pub/lakshan-vindana-kulawansa/37/2a2/5920 -
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..0 -
yes, can't refer from text box name, tried several ways, couldn't found any (simple way) yet.
thanks Mohana
:thumbsup:Lakshan Kulawansa
ERP Consultant - MS Dynamics NAV
https://lk.linkedin.com/pub/lakshan-vindana-kulawansa/37/2a2/5920 -
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".~Rik~
It works as expected... More or Less...0 -
could you please give me an example.Lakshan Kulawansa
ERP Consultant - MS Dynamics NAV
https://lk.linkedin.com/pub/lakshan-vindana-kulawansa/37/2a2/5920 -
lakshanvindana wrote:could you please give me an example.
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?~Rik~
It works as expected... More or Less...0 -
thanks,
cannot use REPORTITEM in report body, this is the issueLakshan Kulawansa
ERP Consultant - MS Dynamics NAV
https://lk.linkedin.com/pub/lakshan-vindana-kulawansa/37/2a2/5920 -
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?~Rik~
It works as expected... More or Less...0 -
may be you used it in headerLakshan Kulawansa
ERP Consultant - MS Dynamics NAV
https://lk.linkedin.com/pub/lakshan-vindana-kulawansa/37/2a2/5920 -
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.~Rik~
It works as expected... More or Less...0 -
correct, can use in same group, but cannot use out of it.Lakshan Kulawansa
ERP Consultant - MS Dynamics NAV
https://lk.linkedin.com/pub/lakshan-vindana-kulawansa/37/2a2/5920 -
lakshanvindana wrote:correct, can use in same group, but cannot use out of it.~Rik~
It works as expected... More or Less...0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions