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...
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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.