13 March 2012

Get the query value in report

1. This is to get report query range value
Declare a variable in classdeclaration
CustGroup custGroup;

Prompt()

custGroup = this.query().dataSourceTable(tablenum(CustInvoiceJour)).range(1).value();

Write a display method in headder or body
Abd return the value

In query we will get from to range also
Ex: 1001 .. 1010

_______________________
2. Write following code in prolog/ headder or init() method.

public void ExecuteSection()
{
SysReportRun sysReportRun;
;
super();
sysReportRun = element;
sysReportRun.printRanges(true);
sysReportRun::executePrintSection(element);
}

No comments:

Post a Comment

Give me the commetns and solutions

AXmodel file import in D365 F&O

 ModelUtil.exe -import -metadatastorepath=k:\aosservice\packageslocaldirectory -file=C:\Temp\DEST.axmodel