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 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.
