Skip to Content
0

Prompt LOV Missing

Nov 24, 2016 at 08:31 PM

57

avatar image

Hi,

We are using SAP BI BO 4.1 sp3 for Business Objects and Universe as Datasource

Requirement: We need to pass the Customers from Parent BO report to Child BO report.

Issue: Customer (0CUST_SALES__CUSTOMER) Characterisitic is used as input control in parent report when we select all customer and provide as input query flter prompt, not all customers are listing in the report.

Is therey any limitation on the Input control for passing values between Parent and Child Report.

Single object passing is ok with the help of document link but multiple values is creating problem in Child Report . below is the link

For ex: Hyperlink code for one Report Filter.This value will be passed to detail report prompt.

="<a href=../../../OpenDocument/opendoc/openDocument.jsp?&iDocID=ASn_Z6loBVpEpjtf1UPvPJ4&sIDType=CUID&sType=wid&sRefresh=N&sWindow=New&lsMCustomer="+URLEncode(ReportFilters([Customer])))+">"+"Click Here To View Detail Report"+"</a>"

Report Behaviour:-

1. Initially when Customer Input Control value is "All Values' in check box and user clicks on Hyperlink, "ALL" is passed from Parent to Child which is as expected.
2. When the value is changed from Customer Input Control for ex: Chinna, Melodia, frus etc..the changed list of values is not getting passed to Detail report prompt.This is the issue. Single value passing is working fine.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Sushil Padhye Nov 25, 2016 at 09:49 AM
0

Hello Din,

Are you getting any Error after you click on the Hyperlink with Customer values selected??

Also please check whether you have "Prompt" at Child Report with "InList" so that Multiple Input can be passed.

One more point which i got in above formula is "ReportFilters" instead of "ReportFilter". This could have cause issue while passing value as URLEncode(ReportFilter([Customer])) would give you correct data.

="<a href=../../../OpenDocument/opendoc/openDocument.jsp?&iDocID=ASn_Z6loBVpEpjtf1UPvPJ4&sIDType=CUID&sType=wid&sRefresh=N&sWindow=New&lsMCustomer="+URLEncode(ReportFilter([Customer]))+">"+"Click Here To View Detail Report"+"</a>"

Regards,

Sushil Padhye

Share
10 |10000 characters needed characters left characters exceeded