Thursday, May 16, 2013

SRSS Reporting Format Report Date In Visual Studio 2010 with Dynamic AX 2012

1. Print page number like Page 1 of 2
="Page "&Globals!PageNumber &" of "&Globals!TotalPages

2. Print current date with prefix like Jakarta, 1 April 2013
="Jakarta, " & day(Globals!ExecutionTime) & " " & monthname(month(Globals!ExecutionTime)) & " " & year(Globals!ExecutionTime)

3.Print date with passing parameter from dataset dynamic ax 2012 //ex. param is  InvoiceDate
="Jakarta, " & day(Fields!InvoiceDate.Value) & " " & monthname(month(Fields!InvoiceDate.Value)) & " " & year(Fields!InvoiceDate.Value)

4. Print date without timestamp
=Format(Fields!Start_Date.Value,"dd/MM/yyyy")

5. Print number
=RowNumber(nothing)


6. Print or counting amount of records on table or matrix
=CountRows("Tablix1")

7. Print only one records in row
=IIF(Rownumber("Tablix1") >1,"","Solar Beban LMM")


No comments: