This discussion is archived
2 Replies Latest reply: Jul 25, 2013 10:53 AM by Rudy Ising RSS

How to create BI Publisher Criteria Report

user12257898 Newbie
Currently Being Moderated
Dear All,
How to prompt for a Date Range in a Contract Managament using BI Publisher.
  • 1. Re: How to create BI Publisher Criteria Report
    SunnyBains-Oracle Journeyer
    Currently Being Moderated
    Oracle have created a knowledgebase article opn how to do this:

    https://support.us.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1491300.1&h=Y

    However it states that Prompt for Criteria is currently only available on a single date value per report. Prompt for Criteria can not currently be used on any other type of field (text, number, etc.).
  • 2. Re: How to create BI Publisher Criteria Report
    Rudy Ising Explorer
    Currently Being Moderated

    I have found that you can extend this functionality to other field types other than date fields (i.e. you can make it work with text, number, etc.) by modifying the syntax in the CRITERIA box.

     

    However, this feature still does NOT support setting up MULTIPLE criteria (i.e. Date and Contract Number, for example)  You can only have ONE CRITERIA option.

     

    Like older versions, you can use the greater than/less than with an AND statement to get a range for this one criteria.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points