Hi Tim, thanks for reply, actually i had already tried using to_char in sql but unfortunately excel still recognizing it as date and displaying it in dd-MMM-yy Regards, Zeenat

Issue is solved. have added two spaces at the end of date format and finally excel is taking it as string. to_char(pu.createdate,'DD-MON-YYYY ') Regards, Zeenat

Hi, i have installed ETBAddInSetup and restarted system, still unable to find BIP add in .

Hi Brajesh, thanks for quick response. in that shared article we need to select excel template but i dont have any template as of now i need to create one. hope my requirement is clear. Regards, Zeenat

Hi Thomas, Thanks for responding. i tried setting null values for future dates but we are using sum() to get cumulative value hence it gives 0 instead of Null. any inputs???? Regards, Zeenat

Issue is resolved. updated code snippet : <RowData> <xsl:value-of select="xdoxslt:set_variable($_XDOCTX,'gctc', 0)"/> <xsl:value-of select="xdoxslt:set_variable($_XDOCTX,'guct', 0)"/> <xsl:for-each-group select="current-group()" group-by="MON_YY" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"><Cell> <xsl:value-of…