Linking Report with date prompt

building reports webintelligence
1

Hi All,

Iam using following syntax to link to report having date prompt,

=Hyperlink("/openDocument.jsp?&sPath=<path_name>&sDocName=Report_viewer&sType=wid&&sWindow=New&sRefresh=Y&lsSRun_date="++"&lsSParent_child_code="+ , FormatDate( ,“mm/dd/yyyy”))

Iam getting “Incorrect datatype(DMB0003)” Error, when i remove highlighted part, variable definition is fine, but i need first prompt value also, Basically how to get this hyperlink working for a date parameter.

Regards
Venkat

Venkat_k (BOB member since 2004-08-20)

2

I got solution for this, It is just that hyperlink expects to have character string attached, hence first convert date to character with Formatdate in a different variable and use that variable in hyperlink.
Links should be fine.

Venkat_k (BOB member since 2004-08-20)

3

Hi,

I tried as you mentioned.
I ddinto work for me.

Is there any other way, we can do that?

GowthamSen :india: (BOB member since 2006-08-31)

4

Hi Venkat,

Thank you very much.
It worked. :wave:

Previously, I gave the wrong format.

Its working now.

GowthamSen :india: (BOB member since 2006-08-31)