Lookup for a Dialog box for a Report in axapta 2009

Finance and Operations/AX Developer Forum
1

Dear Friends,

I need a lookup for a dialog for a report. Which the dialog contains the ITEMNAME field it has to be group by ITEMGROUPID which available in the INVENTTABLE.

on dialog the code listed.

public Object dialog(Object _dialog)

{

DialogRunbase dialog = _dialog;

DialogGroup dialogGroup;

;

dialogGroup = dialog.addGroup("@SYS7402");

dialogGroup.frameType(1);

dialog.addGroup("@SYS7402", dialogGroup);

dialogCountName = dialog.addField(typeid(IName),“Item Name”);

dialogCountName.value(ItemName);

return dialog;

}

void Fld3_1_Lookup()

{

Query _Query = new Query();

QueryBuildDataSource qbds;

QueryBuildRange queryBuildRange;

SysTableLookup sysTableLookup;

;

sysTableLookup.addLookupfield(fieldnum(InventTable, ItemName));

qbds = _Query.addDataSource(tablenum(InventTable));

QueryBuildRange = qbds.addRange(fieldnum(InventTable, ItemName));

QueryBuildRange.value();

if(sysTableLookup)

{

sysTableLookup.parmQuery(_Query);

sysTableLookup.performFormLookup();

}

}

Here What the lookup method should contain.

Thanks in advance.

G.Rajkumar