Report Linking Error

[AnthonyMJ]

Hi,

I am getting a report linking error when I try to link a report to another Crytal Report using OpenDocument.jsp. I suspect that the error is due to the date prompts. I have tried to use all kinds of date function calls (ie, Date, DateValue, DateTimeValue, etc) but still experiencing this error -- Report Linking Error Back There was an error in launching the viewer: null

Here is the Formula I'm using:-

"

http://riviera:7580/businessobjects...nch/opendoc/openDocument.jsp?sType=rpt&sPath=

[Public+Folders],[Engineering],[BAC]&sDocName=CheckLink&lsSBeginDate="&DateValue(cstr({?BeginDate},"yyyy-MM-dd"))&"&lsSEndDate="&DateValue(cstr({?EndDate},"yyyy-MM-dd"))


Any help is appreciated.


XIR2 on Unix Solaris
Informatica 7.1.3
CRXIR2, Oracle 9i/10g

 

[dgillz]

I am not sure this is a crystal reports issue. I am positive it is not a crystal reports formula issue as there is no formula required to link reports.

What application are you in when you are doing this?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[AnthonyMJ]

I have created a Text object and selected "A website on the Internet" Option from the Hyperlink tab of the Format Editor dialogue box. I then created the formula above and publish the report to Infoview to test out the report linking.

Fortunately, I was able to resolved the issue by passing the correct date parameter format after to so many trial and error. The date parameter should be passed as Date(YYYY,MM,DD).

Here is the corrected hyperlink.


"

http://riviera:7580/businessobjects...nch/opendoc/openDocument.jsp?sType=rpt&sPath=

[Public+Folders],[Engineering],[BAC]&sDocName=CheckLink&lsSBeginDate=Date(" + ToText(Year({?BeginDate}),0,"") + "," +
ToText(Month({?BeginDate}),0) + "," +
ToText(Day({?BeginDate}),0) + ")" +
"&lsSEndDate=Date(" + ToText(Year({?EndDate}),0,"") + "," +
ToText(Month({?EndDate}),0) + "," +
ToText(Day({?EndDate}),0) + ")"



XIR2 on Unix Solaris
Informatica 7.1.3
CRXIR2, Oracle 9i/10g