BI Publisher (MOSC)

MOSC Banner

No values to be shown but all values to be passed in parameters

edited Jan 12, 2015 10:00AM in BI Publisher (MOSC) 3 commentsAnswered

We are creating Data Models and Reports in BI Publisher. We have added certain parameters on the basis of which the report can be filtered for results. In the parameter properties we have selected the option of "All values passed" as well . When we run the report in BI Publisher and select the parameters, the report display the results based on those parameters.

When we select "No" option in any parameter, then the return value of that parameter we get in the report contains all the values possible for that parameter in the Database by default we want all values to be passed. In case of no values, we want to display No values in the report. Kindly suggest a solution where we can get no values in report but still data should come in the report for all values.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center