OpenDocument Link not working as expected

[Former Member]

I am using OpenDocument to open a crystal reports with two optional hierarchical parameters like below:

http://<server>:<>/OpenDocument/opendoc/openDocument.jsp?iDocID=<CUID>&sIDType=CUID&lsMparentPrompt=[<parent>]&lsMchildPrompt=no_value

My requirement is to open report by supplying one parameter only and skipping the other. The problem I am facing is, above url is generating empty report instead of generating report only for given parent with all its childs. Is there anything, I am doing wrong here?

Any alternative solution to my problem is most welcome. Thanks in advance.

[Former Member · Accepted solution]

Hi Waqas,

Please find the below information on Open Document - Input Parameters. With reference to your requirement, you have to use IsS[Name] instead of IsM[Name], since its has a single prompt with optional parameter value.  Try the below URL and let me know.

i.e:

http://

<server>:<>/OpenDocument/opendoc/openDocument.jsp?iDocID=<CUID>&sIDType=CUID&lsSparentPrompt=[<parent>]&lsSchildPrompt=no_value

OpenDocument – Input Parameters

lsS[NAME]

 Optional parameter but required if document needs it

 Specifies a value for a single prompt

 Substitute [NAME] with Parameter/Prompt name

 Values

 A single prompt value

 no_value for an optional prompt

eg:

http://<servername>:<port>/BOE/OpenDocument/opendoc/openDo

cument.jsp?iDocID=4767&lsSCountry=USA

lsM[NAME]

 Optional parameter but required if document needs it

 Specifies multi value parameter

 Substitute [NAME] with Parameter/Prompt name

 Values

 Multiple values separated by commas

 no_value for an optional prompt

eg:

http://<servername>:<port>/BOE/OpenDocument/opendoc/openDo

cument.jsp?iDocID=4767&lsMCountry=USA,Mexico,Canada

lsR[NAME]

 Optional parameter but required if document needs it

 Specifies range value parameter

 Substitute [NAME] with Parameter/Prompt name

 Values

 Range values separated by double period (..)

 no_value for an optional prompt

 Crystal requires [], Webi does not

eg:

http://<servername>:<port>/BOE/OpenDocument/opendoc/openDo

cument.jsp?iDocID=4767&lsRDateRange=[Date(2013,1,1)..Date(201

3,6,30)]

sRefresh

 Optional parameter

 Forces document refresh

 WebI Refresh on Open parameter will supersede this parameter

 Values – Y or N

eg:

http://<servername>:<port>/BOE/OpenDocument/opendoc/openDo

cument.jsp?iDocID=4767&sRefresh=Y

sReportName

 Optional parameter

 Specifies which tab to show on open in a WebI report

 Handy to use when you want a particular tab to show when there

are more than one tab in the document

eg:

http://<servername>:<port>/BOE/OpenDocument/opendoc/openDo

cument.jsp?iDocID=4767&sReportName=Report+2&sRefresh=Y

Hope the above information on Open Document helps you to some extent...

--Raji. S

[Former Member · Accepted solution]

Hi Raji, Thanks for reply.

You are right 'no_value' works with 'IsS[Prompt]' as it should. But in my case this prompt is multiple value prompt and 'no_value' with 'IsM[Prompt]' is not working as documented.

What I did as workaround is I modified the filter associated with that prompt in the report.