SSRS Format Function


User-Defined Numeric Formats (Format Function) - http://msdn.microsoft.com/en-us/library/4fb56f4y%28v=VS.80%29.aspx

User-Defined Date/Time Formats (Format Function) - http://msdn.microsoft.com/en-us/library/73ctwf33%28v=VS.80%29.aspx


Format Function - http://msdn.microsoft.com/en-us/library/59bz1f0h%28v=VS.80%29.aspx

Comments

Post a Comment

Popular posts from this blog

AX 2012 R3: Cannot edit a record in Purchase order - update table (PurchParmTable).

Image
AX 2012 R3: Cannot edit a record in Purchase order - update table (PurchParmTable). Error: Cannot edit a record in Purchase order - update table (PurchParmTable). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record. Scenarios: This happen when, I try to cancel Purchase Order Confirmation or GRN in AX 2012 R3. Anyone encounter this before? Appreciated can share some solutions. All the best. Ariston J.
Read more

AX 2012: The AOS server name or instance name is not correctly configured

Image
Scenario: When installing Reporting Extension in Reporting Server using Microsoft Dynamics AX 2012 R3 Installation wizard, then I got the below error. Error Details: Performing a service status check for prerequisite 'Application Object Server (AOS) Services WSDL URI accessible Error fetching services status. Reason: The AOS server name or instance name is not correctly configured Check succeeded. services check failed Solution Details 1. In "Microsoft Dynamics AX Configuration Utility". 2. Check if Connection Details in Connection Tab are valid and in correct setups. 3. Refresh Configuration to regenerate WCF configuration 4. Try to install again
Read more

AX 2012 Get Financial Dimension Value by Worker RecID

public Name mscGetOriginatorFinancialDimension(RefRecId _workerRecId) {     RecId       defaultDimension;     DimensionAttributeValueSet      dimAttrValueSet;     DimensionAttributeValue         dimAttrValue;     DimensionAttribute              dimAttr;     Common                          dimensionValueEntity;     defaultDimension        = HcmEmployment::findByWorkerLegalEntity(_workerRecId, CompanyInfo::current()).DefaultDimension;     dimAttrValueSet         = DimensionAttributeValueSet::find(defaultDimension);   ...
Read more