Opendoc BEx queries feeding Crystal Reports 2008

[Former Member]

Has anyone successfully passed parameters through opendoc url to a Crystal report that uses a BEx query?

I can open the crystal report fine in infoview but it ignores anything after the docname in the url (ie parameter values). I believe it has something to with the fact that the crystal report uses BEx query to populate with data as I have tested other crystal reports using excel as a source and it works.

A little background on the crystal: 2008 12.0 (no service pack) and BOE: 3.0. Installed is the integration kit 12.0 because we use Bex queries to feed the crystal. I have embedded the database logon information for the BI database into the crystal report ( through cmc via database properties). The BEX query designer is 7.0.

Thanks

[Former Member]

Hi ,

I am facing the same problem.

My open doc syntax:

"=http://hwdboe01:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=33935&sType=rpt&sRefresh=N&sWindow=new&isApplication=true&YlsS[0COMP_CODE]-[20COMPANY]="&G30&"&lsS[0DEBITOR]-[20CUST_CLASS]="&G31"

I am creating parameters in crystal with technical name format from Bex query as i dont have access to create character restriction in Bex query and in my Bex query there is 1 optional prompt and a mandatory prompt which i am not using in the syntax.. will that make any difference..

Crystal parameters: [0COMP_CODE]-[20COMPANY]

[0DEBITOR]-[20CUST_CLASS]

And G30 =0000X G31=0000X in excel/ xclesius.

I have inputed tech names .. but still it opens up parameter entry screen ...

Please let me know where i am going wrong .

Thanks in advance ,

Pallavi

[Former Member]

I realize now that in order for the url to work, the crsytal report must use Bex variables. After doing this in the query definition to restrict data, the url works.

[Former Member]

Hi Cuen,

When you are using openDoc, are you noticing that the 'Parameter Entry' screen is showing up? I can't seem to find the string that will suppress this.

Thanks,

Brian

[former_member204024]

Hi Cuen,

Can you please explain how you resolve this issue. I am facing the same issue.

Thanks and Regards,

Subbu S.

[former_member204024]

Hi Cuen,

Can you please explain how you resolve this issue. I am facing the same issue.

Thanks and Regards,

Subbu S.

[Former Member]

In crystal report you can make parameter fields but in order to get opendoc you need to create these parameter fields in bex query designer as character restrictions (without default values)

These will then show up as Parameter fields in Crystal. Lets say you created two character restrictions, their technical names will be shown as parameters. (usually the technical names will be something like !V000001.

You can then create open doc url from xcelsius to CR

="http://ServerName:8080/OpenDocument/opendoc/openDocument.jsp?sType=rpt&sDocName=Portfolio+Summary - NEW - HN&sRefresh=Y&lsS[!V000001]="&Q4&"&lsS[!V000002]="&G129

Q4 = u201C2008u201D G129 = u201CDCF018C7DBA1F0F1933600163504CC36u201D in excel/xcelsius

[Former Member]

Hi Brian,

Are you assigning a value to all parameters, even optional ones, in the url?

Regards,

Cuen

[Former Member]

http://coevi13:8080/OpenDocument/opendoc/openDocument.jsp?sDocName=Executive Portfolio Report_Risk_Leakagetest&sWindow=NEW&lsSZPMOP3C30_ZPMOP3C30_Q404.[0CALYEAR]-[20CALYEAR]=2008

ZPMOP3C30_ZPMOP3C30_Q404.[0CALYEAR]-[20CALYEAR] is the field name

I have also tried

http://coevi13:8080/OpenDocument/opendoc/openDocument.jsp?sDocName=Executive Portfolio Report_Risk_Leakagetest&sWindow=NEW&lsSYear=2008

Year is the name of the Crystal report prompt

When I try

http://coevi13:8080/OpenDocument/opendoc/openDocument.jsp?sDocName=Executive Portfolio Report_Risk_Leakagetest&sRefresh=Y

the report opens but it doesnt force a refresh or prompt the user either

Edited by: Cuen Gower-Winter on Mar 2, 2009 5:46 PM

[Former Member]

Hi Cuen

Can you please paste the URL link that you are using?

Thanks

Ashwini Yadav