I'm not sure of the syntax I need to use. When I try the following, it doesn't work.
public void init() { date ed; ; super(); ed = today() + 192; this.query().dataSourceTable(tablenum(InventBatch)).addrange (fieldnum( InventBatch, ExpDate)).value(queryRange(Today(),ed))); } //I get: Syntax Error. --- In development-axapta@yahoogroups.com, kristanto surjadi <[EMAIL PROTECTED]> wrote: > > 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: development-axapta@yahoogroups.com > 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] >