1 Reply Latest reply: Oct 29, 2012 8:16 PM by carlos cortez RSS

    Report Parameter problem

    957731
      Hi all,

      I am new to Oracle Report and currently I am using the oracle report builder of Oracle Developer Suite 10g. I am writing a report for user to retrieve invoice information with a parameter for user to enter invoice number, may I know can I configure this parameter in this way:

      When user enter invoice number in this parameter, it will retrieve the corresponding invoice record. If user leave it blank, it will retrieve all invoices?

      Thanks a lot in advance.

      Best Regards,

      Alex

      Edited by: 954728 on Oct 29, 2012 3:05 AM
        • 1. Re: Report Parameter problem
          carlos cortez
          Hi,

          If you are retrieving the invoces from a database, so you should do something like this in your query's where clause:
          SELECT *
          FROM INVOICES I
          WHERE I.INVOICE_NUMBER = NVL(:P_INVOICE_NUMBER,I.INVOICE_NUMBER);
          where :P_INVOICE_NUMBER is the reports's parameter that may have the number of the invoice or it may be null. :)

          Regards
          Carlos