http://technet.navision.com/default.asp?
MenuFunctionName=EISNewsArticle&MenuFunctionType=Output&NEWSID=351
Best regards,
Bj�rn M�ller Pedersen
Thy Data Center Development A/S
--- In [EMAIL PROTECTED], "Arkadiusz Zimniak"
<[EMAIL PROTECTED]> wrote:
> Hallo,
>
> Could You send more information what kind of _expression_ could be
set this
> way ??
> What is the syntax ?
>
> Best regards
> Arkadiusz Zimniak
>
> -----Original Message-----
> From: bmp_thydatacenter_dk [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 22, 2004 7:31 AM
> To: [EMAIL PROTECTED]
> Subject: [development-axapta] Re: SQL vs Query engine
>
>
> You can set up this range in a query.
>
> The rule is that if a range value start with a "(" the contents of
> the range is an _expression_ in X++ syntax. You can make a range on
> the custTrans datasource on a random field and set the value to:
>
> (AmountMST != SettleAmountMST)
>
> Best regards,
> Bj�rn M�ller Pedersen
> Thy Data Center Development A/S
>
> --- In [EMAIL PROTECTED], "Don Price"
> <[EMAIL PROTECTED]> wrote:
> > >.custTrans.AmountMst != custTrans.SettleAmountMST)
> > Are you sure you have this set via a range in the report?
> >
> > The rest of those ranges you could setup in the query without
> code, but
> > Not this one.
> >
> > Don
> >
> > -----Original Message-----
> > From: bmp_thydatacenter_dk [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, September 21, 2004 2:23 PM
> > To: [EMAIL PROTECTED]
> > Subject: [development-axapta] Re: SQL vs Query engine
> >
> > I can't figure out why your approach is not working from you
> > description.
> >
> > But an approach I have used many times is to use a temporary
table
> > as a middle tier between feching the data from the database and
> > sending the data to the design. This gives the oppertunity to
> focus
> > on the database communication regardless of the wanted sequence
of
> > data in the design of the report.
> >
> > Best regards,
> > Bj�rn M�ller Pedersen
> > Thy Data Center Development A/S
> >
> > --- In [EMAIL PROTECTED], "Matt Benic"
> > <[EMAIL PROTECTED]> wrote:
> > > Hi all,
> > > I'm going nuts trying to get a report to work. My requirement
is
> > to return a
> > > summary of all unsettled credit notes and payments per
customer,
> > grouped by
> > > credit controller (dimension[5]).
> > >
> > > Seems easy enough, set up a report using custtable and
custtrans
> > joined on
> > > the customer number, use a variable to sum up the total
> > outstanding amount,
> > > and use a programmable section to display it all. Except it
> doesnt.
> > > I have set up such a report, using ranges on the amountMST,
> > transdate and
> > > dimension[5], but when I compare the values with those obtained
> by
> > using the
> > > SQL below in the table browser, the totals of the resulting
> > transactions
> > > dont even come close to matching. Any suggestions?
> > >
> > > SELECT * FROM CustTrans
> > > where (custtrans.accountnum == "003556") &&
> > > (custtrans.amountMst < 0) &&
> > > (custTrans.AmountMst != custTrans.SettleAmountMST) &&
> > > (custtrans.transdate < 31\10\2004)
> > >
> > > (I have omitted the dimension[5] part of the where clause since
> it
> > does not
> > > affect the returned values.. each customer is managed by a
> single
> > credit
> > > controller)
> > >
> > > Regards,
> > >
> > > Matt Benic
> > > Axapta Developer
> > > UTi Sun Couriers Division
> > >
> > > "The universal aptitude for ineptitude
> > > makes any human accomplishment an incredible miracle."
> > > - Col. John P. Stapp
> >
> >
> >
> >
> >
> > Yahoo! Groups Links
>
>
>
>
>
> Yahoo! Groups Links
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
