Code.GetData(x,y) in RDLC report

julkifli33
Member Posts: 1,092
hai all... anyone know how to use this function?
i want to modify Statement report (report 116), but i want to change the sequence of customer info
is use report items as usual but sometimes not showing every page
any one have same issue?
or is there any link how to use code.getdata?
i want to modify Statement report (report 116), but i want to change the sequence of customer info
is use report items as usual but sometimes not showing every page
any one have same issue?
or is there any link how to use code.getdata?
0
Comments
-
Jatin Patel
Microsoft Dynamics NAV Consultant
Jatin's Blog0 -
Jatin Patel wrote:
hi Jatin, thanks for the link
sometimes code.getdata(1)
but sometimes code.getdata(1,1)
how do we know this 1? or this 1,1 to which record?0 -
julkifli33 wrote:
sometimes code.getdata(1)
but sometimes code.getdata(1,1)
how do we know this 1? or this 1,1 to which record?
If u have only one array for getdata then use code.getdata(1)
and for multiple have to use code.getdata(1,1)Jatin Patel
Microsoft Dynamics NAV Consultant
Jatin's Blog0 -
See properties for your report (in Visual Studio) and look in the Code tab.________________________________
Gunnar Gestsson
Microsoft Certified IT Professional
Dynamics NAV MVP
http://www.dynamics.is
http://Objects4NAV.com0 -
There seems to be a lack of knowledge of how to use the Code.GetData(x,y), I am making some assumptions I would like someone to help me with.
In report 206, Body, TableRow1 there are 4 hidden textboxes :
CustAddr
CompanyAddr
CompanyInfo
SalesHdrInfo
I understand that these are needed to be used in the Header for example, no problem so far.
Where you have =Code.GetData(1,1) or =Code.GetData(1,4) and so on, I think the x = first field in the expression but where does the y come from?
Click on Report.rdlc, Report/Report Properties/Code
This shows the way the report handles the sequence contained in the SalesHrdInfo/Expression and the others
Select SalesHdrInfo
Click on the Properties SalesHdrInfo Textbox (right-top) and get a drop down of all the fields
Select SalesPersonText1 and you see the Value : =Code.GetData(19,4)
That will show you on the report where that field has been used.
Add another field at the bottom of the Expression such as:
Fields!PageCaption.Value + Chr(177) + (add the following to the last line) + Chr(177) +
Fields!PricesInclVAT_YesNo.Value
Drop the field into the header section from the Result list, then add =Code.GetData(22,4) as the Value
If the above is not correct, please someone do the right thing and clear up the explanation guide.Experience is what you get when you hoped to get money0 -
Hi,
Try reading this article .
http://saurav-nav.blogspot.in/2011/07/rtc-report-development-3.html
@colingbradley -
IN Code.GetData(x,y) - X is the data postion in that particular group (red textbox in body) and Y is the group No.
While creating reports you can skip Y if you don't want it.
If you still have any doubts let me know.
Thanks & Regards,
Saurav Dhyani
Do you Know this About NAV?
Connect - Twitter | Facebook | Google + | YouTube
Follow - Blog | Facebook Page | Google + Page0
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