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 [email protected], 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: [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]
>
