Yesterday I got very interesting issue. So When put filter on color, config, style and size. A strange error occur. Filter works for 99% of records but on 1 percent time out occurs. When we dig deep into issue, we found that End user, used the special character '(' in style. And when we execute the filter on dim of special character reports goes toward timeout. It means some … [Read more...] about Special character In Query range, Dynamics ax 2012 R3 and DFO 365 for operation.
Archives for April 2017
During report development we populate temp table and bind it to SSRS report. And most of the time we were doing one to one mapping inside while loop or query run loop., Kindly consider following code snippet. While select sum(Qty) from Inventtrans group by ItemId, InventDimId , DatePhysical Where datePahyical > _fromdaet && datePhayical _fromdaet && datePhayical … [Read more...] about Data manipulation tip 4 Dynamics ax 2012 and D365 of Operations Insert_recordset
If we consider the following code snippet. CustSalesQty _temp1,_temp2; _temp1.IntQty=100; _temp1.CustAccount ="Cust00001"; _temp1.insert(); _temp1.IntQty=200; _temp1.insert(); _temp1.IntQty=300; _temp1.CustAccount ="Cust00003"; _temp1.insert(); while select * from … [Read more...] about Data manipulation tip 2 Dynamics ax 2012 and D365 of Operations Table initialization method.
Currently I am doing Report development project, I got some tips for Data manipulation , these tips I recently learned. Copy data from one table buffer to other of same type. During report development, We usually populate temp table with result of Query execution. Usually we need copy of same data for aggregate … [Read more...] about Data manipulation tip 1 In Dynamics ax 2012 and D365 Of Operations Data copy method.
Today after Db resorted form Production / live server, Full CIL failed, And During compilation I found very strange error. Error described that " Code Permission Error" And It pointed to out of box SSRS report. Interestingly a junior developer added customization on report. And there is no error on report. Finally I found that that report has some out of the box Design … [Read more...] about Code permission Error, SSRS report missing. Dynamics Ax 2012 R3.