Convert Date time to Date in AX2012 SSRS

1.Go to field properties.
2.General > Value > Click on expression(fx) >
=Format(Fields!TransDate.Value,
"dd/MM/yyyy")

Comments

Anonymous said…
Its not working for a blank value
8 January 2014 at 09:42
Post a Comment

Popular posts from this blog

Monthwise number sequence in SO and PO

Image
Refreshing the number sequencing for sales order each month so that sales order creation month can be identified based on the number. Initial setup: /// This batch will update the numbersequence format ‘yr/Month/######’ for salesorder number. /// class Monthwisenumberseq extends RunBaseBatch { } // new method protected boolean canGoBatchJournal() {      return true; } // new method public void run() {      NumberSequenceReference     numberseqref;      NumberSequenceTable            numberSeqTable;      container                                   segments;      str                                              annotatedFormat, format, datestr;      ;      ttsBegin;      datestr = date2str(systemDateGet(),              321,              DateDay::Digits2,              DateSeparator::Slash, // separator1              DateMonth::Short,              DateSeparator::Slash, // separator2              DateYear::Digits4,  
Read more

Drill Down Reports in AX 2012

Image
Drill Down Reports: Here we are going to do Drill down reports in ssrs - AX 2012 1.Create new query in AOT Named as Custtransaction. 2.Add CustTrans as datasource. 3.Set Dynamic  = yes in field property. 4.Open Visual studio 2010 5.Create new report > In property change the name to CustTrans 6.Add new dataset with below properties  Datasource = Dynamics AX  Datasource Type = Query            In query property select the query (CustList) 7.Create Precision Design. 8.Select Table in report tools. 9.Select Voucher,Transdate,Invoiceid,Amount currency Now we need to group the data based on the account number. Follow the below steps:  Adding Group    Select the row which we want to hide and show > Right click > Row visibility.    Select hide button to hide the row details.   Now we can expand and we can see the Customer details.   Same way we can group coloumn wise. 
Read more