had disabled dynamic fields and limited the fields in the select, but had
missed SettleAmountMST, so this was always zero.
Don, as I stated earlier, this was not origonally set in a range, however as
some of the other respondents mentioned, it is actually possible to put it
in a range. It can be placed as a range on custTrans.AmountMst by
specifiying (AmountMST != SettleAmountMST). (You must include the brackets
for it to work)
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
-----Original Message-----
From: Don Price [mailto:[EMAIL PROTECTED]
Sent: 22 October 2004 09:51 PM
To: [EMAIL PROTECTED]
Subject: RE: [development-axapta] Re: SQL vs Query engine
>.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.
