Posts

Showing posts from October, 2019

XMLP: Padding Zeros for Numeric Values in templates

<xsl:value-of select='format-number(SSR_TOT_EN_GRDPTS, "0.000")'/>

PC: Dynamic Where Clause

REM ***********************************************Modification Summary******; REM SL.No Developer     Mod. No.   Date      Changes REM ----- -----------    ---------- ---------- ------------------------------------------- REM************************************************************************; &str_WhereClause = ""; &str_NoAddnlClause = "N"; /* Clause for acad org */ If (LAC_CSG_RPT_AET.ACAD_ORG.Value <> " ") Then    &str_WhereClause = " A.ACAD_ORG = '" | LAC_CSG_RPT_AET.ACAD_ORG.Value | "' ";    &str_NoAddnlClause = "Y"; End-If; /* Clause for Subject */ If All(LAC_CSG_RPT_AET.SUBJECT.Value) Then    If &str_NoAddnlClause = "Y" Then       &str_WhereClause = &str_WhereClause | " AND A.SUBJECT = '" | LAC_CSG_RPT_AET.SUBJECT.Value | "' ";    Else       &str_WhereClause = "  A.SUBJECT = '&qu