Code to fetch records from table

Business Central/NAV Developers Forum
1

Hi…

I want to fetch some records in a table and want to display in a report… Can anyone help me…

2

Are you using Dynamics NAV or Dynamics AX?

3

Dynamics Nav

4

Good…

May I know what did you try?

5

I took two fields from vendor table in a report … through code i want to display those fields in a report…May i know wat is the code behind that?

6

Do ypu know how to use GET,SETRANGE/SETFILTER,FINDSET/FINDFIRST?

7

No…

8

Please read some basic technical documents

or simply select Help–>C/SIDE reference guide and search for above terms…

9

Plz send me the code

10

I can Directly come to your place and write the code for you If you can bare the expenses [ap]

11

Haha…I know the usage of those properties…let me know the code mohana.

12

I will definitly help you but let me know what did you try…

Please try something before getting full code from forum…

13

What dataitem you have took in report?

I m assuming Purchase Header

Take vendor as record variable

Varialbe Name :- recVendor

If recVendor.get(Purchase Header.“Buy From Vendor No”) THEN ;

Once you written this code then u can display any record of vendor table on ur report

But you need to modify the code according to ur requirement

14

If you know those properties then you should have been able to figure it out yourself.[:^)]

Best to keep this link close at hand:

http://msdn.microsoft.com/en-us/library/dd301468.aspx