Opendoucument Issue

23 Views

Hi Experts,

Pls help out for :

1) Opendocument link sometimes opens the report correctly and sometimes return opendocument login page. What could be the issue and how to fix it?

2) Also, link works fine with full url path of opendocument.jsp given in the link itself. However, when replaced by Universe object which reads link from a DB table returns error. Same URL object is working fine in another report. Please see working and non-working links and advise what went wrong.

WORKING :

Code:

"<a href="Char(34)"http://abc.xyz.net/OpenDocument/opendoc/openDocument.jsp?&sType=rep&sRefresh=Y&sPath=[ABC]&sDocName=ABC_XYZ&lsS1.SelectCalDate:="FormatDate(<Cal Date> , "mm/dd/yyyy")"&lsS2.SelectCountry:="<Country>"&lsS3.SelectState:="<Stae>"&lsS4.SelectTown:="<Town>"&lsS5.SelectPoolType:="<Pool Type>"&lsS6.SelectY/N:="<Status Y>Char(34)">"FormatNumber(<Currency> , "#,##0")"</a>"

NON WORKING

"<a href="Char(34)<URL>"/OpenDocument/opendoc/openDocument.jsp?&sType=rep&sRefresh=Y&sPath=[ABC]&sDocName=ABC_XYZ&lsS1.SelectCalDate:="FormatDate(<Cal Date> , "mm/dd/yyyy")"&lsS2.SelectCountry:="<Country>"&lsS3.SelectState:="<Stae>"&lsS4.SelectTown:="<Town>"&lsS5.SelectPoolType:="<Pool Type>"&lsS6.SelectY/N:="<Status Y>Char(34)">"FormatNumber(<Currency> , "#,##0")+"</a>"