This is example of Fetch Method in Ax Reports of Microsoft Dynamics axapta x++ language. By this example you can get Idea that how to declare variables to use querybuilddatasource at run time. You can see how to add query range in querybuilddatasource object. Here report programmable section used to execute. public boolean fetch() { QueryBuildRange rangeStatus; Query q = new Query(); QueryBuildDataSource qbds; ; q = this.query(); qbds = q.dataSourceTable(tablenum(Table1)); if (groupByClosed1 == 1) { qbds.addRange(fieldnum(Table1,Closed)).value(enum2Value(groupByClosed1)); } if (groupByImplemented1 == 1) { qbds.addRange(fieldnum(Table1,Implemented)).value(enum2Value(groupByImplemented1)); } if (groupByPending1 == 1) { groupByPending1 = 0; qbds.addRange(fieldnum(Table1,Closed)).value(enum2Value(groupByPending1)); } qbds.addSortField(fieldnum(Table1,TicketNo)); queryRun = new QueryRun(q); while(queryRun.next())...
Microsoft Dynamics Ax,AIF,Axapta, Enterprise portal,,Microsoft , United State,U.S., SharePoint , BI Tools, Performance Tuning, SSRS,Business Logic,Ax ERP Errors and solution,Dynamics 365 Errors Solution,Business software .