Passing parameters from a form to a report

Finance and Operations/AX Developer Forum
1

I have a form which has two string edit fields.I need to show a report based on the account number entered in these field for example

If

Field 1 =“1101”

Field 2 =“1200”

then my report needs to print all customer details whose account number is between the above range.I do not want to use the range and parameter needs to be passed only through code.

How can i achieve this?Please advice.

2

You maybe write while select loop with where condition (like between) then display method for display cust name or Id

3

You need to use arguments. Check the init method of Reports\SalesInvoice to get started.

4

STEP 1) create a menu item ,set PROPERTIES a)OBJECT TYPE:-REPORT

b) OBJECT :-(Name of the Report)

C) name: REPORT123

STEP 2) place a Menu button in FORM ,set PROPERTIES

A)MENUITEMNAME:-REPORT123

B)DATASOURCE:- NAME OF THE TABLE

STEP3) iNIT METOD IN report ,

TABLEname _TABLENAME;

if(element.args().dataset() == tablenum(TableNAME))

{

_TABLENAME = element.args().record();

}

YOU WILL GET THE CURRECT aCTIVE RECORD IN “_TABLENAME” table buffer.Then you can select the record using the table buffer;

//_TABLENAME.field1;

//_TABLENAME.field2;

Regards

RAM

5

All these things are possible if you are using a table in the form(temp or permanent table)[:)]

6

I have uploaded objects to implement passing parameter from one object to another. you can download it from here.

http://cid-1c1c99d247edd270.office.live.com/self.aspx/Navision%20Objects/PassingParam.fob?ccsf=1#sn_ccCommentCtrl_anch

Note:

In the code unit dont forget to set the single instace property.

7

kathik. D

Its is DynamicsAx.I think u send link for “Navision”.Check the post and link

8

Thanks guys.Will post the refined Code soon.