[Axapta-Knowledge-Village] X++ select vs TSQL select

Hi all, I'm trying to use an outer join on a table in an aggregate x++ select statement but AX doesn't seem to like it and an inner join is forced. the X++ statement looks like this: select AccountNum from vendTable group by AccountNum outer join maxOf(Name) from contactPer

RE: [Axapta-Knowledge-Village] FRx with AX 3.0

As an alternate solution you might want to look at XL Reporter. It is a fully intergrated DAX Excel Based Report Writer that works great with Dimensions. To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Thu, 15 Nov 2007 13:21:43 +Subject: [Axapta-Knowledge-Village] FRx with AX 3.0 I'm t

Re: [Axapta-Knowledge-Village] The Values on the form displayed are not current - F5 refresh

Hi, Have you used _ds.reread() before _ds.research() ? Regards, Aji Sarosa Email: [EMAIL PROTECTED] On 11/16/07, shaakera_b <[EMAIL PROTECTED]> wrote: > Hi All, > > We have very complex form, with many data sources. When some of the > fields one of the data sources are changed, the other data s