Skip to Content
0
Former Member
Feb 10, 2012 at 06:06 AM

Open document passing parmeter from Column value

21 Views

Hi,

I'm using BO4.0 sp2 and in Webi I'm using URL Reporting to open my child report based on the value passed from the Country clomun of my report.The prompt name in the child report is EnterCountry.

As I need to pass the parameter value from Country column to my child report so that it should show the data for that specific country I used select object to specify the parameter value it displays =[Country] value for the parameter.Now I can see my URL as follows

http://TestBO:8080/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=91482&lsSEnterCountry=([Country])

when I click on Ok buttom to proceed ahead it does not close the window.

I thought this could be because of "=" sign appeared in the text box given for the parameter value so I tried to remove the "=" sign still the dialog box doesn't get close and I can see the URL asa below

http://TestBO:8080/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=91482&lsSEnterCountry=(Country])

If I remove the curly brackets and put square brackets to get the Object, the URL opens the report however, it displays a message as "No data to retrieve in Query"

So I'm wondering if this is a bug in BO4.0.

Could any one please look into this and help me out?

Thanks,

Anu