Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mgmonto

    Oracle Reports: Setting a Runtime Where Clause in the Report SQL

    I have a report that has a start date as an in parameter that can either have a value or be null at runtime. The where clause of my report sql is: where date_received >= :p_start_date If I don't put a value in for :p_start_date then no data is returned. How do I set up the where clause of the...
  2. mgmonto

    Oracle Reports: Showing Margin Objects Only on First Page of Report

    I have an oracle report that contains margin fields within the body, that reference character placeholder columns. The place holder columns are not populated with actual report data retrieved from a query. They are populated with labels/indicators for the end user. My problem is that I only...
  3. mgmonto

    Oracle Reports: show record number in tabular report

    I've looked in several places and have not found how to display the record number in an Oracle tabular report. I would like to display the record number, of each record, on the left side of the report. I'm using 9i Oracle Reports Developer. Any help would be much appreciated. mgmonto
  4. mgmonto

    ? Running an Oracle Report from the Web Using PL/SQL Web Page

    I have a PL/SQL Web Page, very simple, and I'm trying to run a report on the click of a button, within the page. The PL/SQL Server Web Page Procedure is as follows: create or replace procedure my_first_psp as begin snl_iris_common.h_open('My First PSP'--common code for page...

Part and Inventory Search

Back
Top