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