Dear All,
I have few queries regarding The PivotTable.
Our reporting requirements are in excel download with summarization in
the form of PIVOT table .
But I have no knowledge of pivot table in axapta.
Which type of code I will write?
How are make the pivot Table in axapta?
Plz guide about the pivot …
Regards
Santosh Ahuja
----- Original Message ----
From: Agus Riyadi <[EMAIL PROTECTED]>
To: development-axapta@yahoogroups.com
Sent: Wednesday, 19 December, 2007 6:25:13 PM
Subject: [development-axapta] Bug in Ax 4.0 date range?
Hi,
I found that delivery date exceeded report ( AP> Report > Status> Delivery
date exceeded, the report is PurchCollectionLett erList) in Ax 4.0 is
incorrect.
It is incorrectly recognize datenull range as a 01/currentmonth/ 1900, not
01/01/1900 as should.
here is the excerpt from fetch method:
queryBuild = this.query() ;
confirmedDlv =
queryBuild.dataSour ceTable(tablenum (PurchLine) ).addRange( fieldnum(
PurchLine,
ConfirmedDlv) );
confirmedDlv. value(queryRange Concat(strfmt( '..%1',
queryValue(collecti onLetterDate- 1)), *queryNotValue( dateNull( ))*));
queryRun_PurchColle ctionLetterList = new
QueryRun(queryBuild ); //PUT BREAKPOINT HERE
You will see the value of confirmedDlv range incorrect.
This causes all purchline with blank confirmedDlv are included as query
result. I am worry this happen at another place too.
Anyone know how to fix this?
Regards,
Agus
[Non-text portions of this message have been removed]
5, 50, 500, 5000 - Store N number of mails in your inbox. Go to
http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html
[Non-text portions of this message have been removed]
