Prompt values are not getting passed in hyperlink -BOXI 3.1

building reports webintelligence
1

we are facing a problem in hyperlink while passing values in BOXI 3.1, wwe have a column Proposal ID, which is a hyperlink,
reqdment is when click on project ID, corresponding page related to that project details should open.
with the Proposal, there are 2 Date prompts (having fixed values passed in them) and one other, total 4 prompts,
but problem is that values to the prompt are not getting passed automatically and prompts appears while opening the next window.

hyperlink is :

="<a href=http://…/…/OpenDocument/opendoc/openDocument.jsp?iDocID=AVJOG9uPS5ZNoLBYtJjItSA&sIDType=CUID&sType=wid&sWindow=New&sRefresh=Y&NAII=Y&lsMProposal Status="+Replace(Replace(Replace([Status Name];"&";"%26");"#";"%23");Char(34);"%22")+"&lsS"+URLEncode(“Include Closed (Y/N):”)+"="+URLEncode(UserResponse(“Include Closed (Y/N):”))+"&lsMProposal+(Name)="+Replace("*";" “;”")+"&lsSEnter+CR+From+Date="+FormatDate(ToDate(“1/1/1998”;“M/d/yyyy”);“M/d/yyyy”)+"&lsSEnter+CR+To-+Date="+FormatDate(ToDate(“9/9/9999”;“M/d/yyyy”);“M/d/yyyy”)+">"+FormatNumber([Request Id] ;"#####")+""

Can anyone help in this?

Zeenat :india: (BOB member since 2007-12-11)

2

I suggest checking that the prompt text that you entered in your formula matches exactly (including upper case/lower case/spaces, etc.) the prompt text from your parent report. Does proposal status have any prompt text? If Proposal Status is the prompt text, it has an enclosed space within it and you should be using the URLEncode function, or a plus sign between Proposal and Status.

bkaporch :us: (BOB member since 2008-12-02)