your select
While select field1, field2, sum(field3)
from xtable
group by field1, field2
{
element.send(xtable);
}
Best regards
Erik
________________________________
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of pepejeans2k
Sent: 15. august 2005 12:00
To: [email protected]
Subject: [development-axapta] While ....group ......error
To all,
Does any one ever face error when you do a while statement like this :
While field1, field2, sum(field3)
from xtable
group by field1, field2
{
element.send(xtable);
}
While field2, sum(field3)
from xtable
group by field2
{
element.send(xtable);
}
the report returns an error "Invalid Field" as it's looking for field1
in the second statement. If I swap statement 2 with statement 1, no
error. There must be some connection with the group by statement.
How do we overcome this error?
Best rgds,
BS
SPONSORED LINKS
Computer part
<http://groups.yahoo.com/gads?t=ms&k=Computer+part&w1=Computer+part&w2=P
rogramming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.s
ig=yLpvcLTIDJ5FTkRJGsO11w>
Programming languages
<http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Computer+p
art&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4
&s=90&.sig=cuhEClK4dU4wapXFmKisbQ>
Microsoft axapta
<http://groups.yahoo.com/gads?t=ms&k=Microsoft+axapta&w1=Computer+part&w
2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90
&.sig=yfeG_U6QaLfPOZZIud02Fg>
Support exchange
<http://groups.yahoo.com/gads?t=ms&k=Support+exchange&w1=Computer+part&w
2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90
&.sig=hy8yRGMzrmxdphyITTUeqA>
________________________________
YAHOO! GROUPS LINKS
* Visit your group "development-axapta
<http://groups.yahoo.com/group/development-axapta> " on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
be>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
________________________________
[Non-text portions of this message have been removed]
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
