You can add x++ code add the report Init metod transdate td; ; td = today() + 192;
this.query().dataSourceTable(tablenum(datasourcetablename)).addrange(fieldnum( datasourcetablename, ExpDate)).value(queryRange(datenull(),td))); this.query().dataSourceTable(tablenum(datasourcetablename)).addrange(fieldnum( datasourcetablename, ProdType)).value(queryValue(xx1)); this.query().dataSourceTable(tablenum(datasourcetablename)).addrange(fieldnum( datasourcetablename, ProdType)).value(queryValue(xx2)); this.query().dataSourceTable(tablenum(datasourcetablename)).addrange(fieldnum( datasourcetablename, ProdType)).value(queryValue(xx3)); --- On Fri, 6/6/08, letron_brantley <[EMAIL PROTECTED]> wrote: From: letron_brantley <[EMAIL PROTECTED]> Subject: [development-axapta] Newbie Question - Range Syntax To: [email protected] Date: Friday, June 6, 2008, 8:50 PM Hello everyone, My company is going through an implementation of Dynamics AX 4 and I have been tasked with writing some reports. It's coming along pretty well, but I am running into little things that are blocking me. One question that I have has to do with Ranges in the AOT. When I create a new range based on a date field, what syntax do I use in the properties pane when I want to say "ExpDate < Today + 192"? Also how do I create a range that says "= xx1 or xx2 or xx3"? In SQL I can do "ProdType in ('XX1', 'XX2', 'XX3'). Thanks Letron [Non-text portions of this message have been removed]
