Is it possible to set the "Maximum Records per Page" attribute for a repeating frame at Runtime? The requirement of my report is that the user should select how many records to see and the report shall display the this number of records.
create on user parameter :p_no
after that go to u r datamodel query
write query like that
select col , count(col2) from table name
where clause condition
group by col1
hav*ing count( col2 ) > :p_no;*
Please try below method
1. Create a report parameter T
2. Modify your query to something similar to below.
SELECT * FROM
(SELECT * FROM EMLOYEE)
WHERE ROWNUM <= :T
This will enable user to specify no. of records to be display while running report.
SRW.SET_MAXROW(query_name char,maxnum pls_integer);
you can use this in before report trigger
here :p_rec_no is user parameter having number datatype;
suppose your report has two queries ,Q_1 and Q_2
and you have a user created parameter, named p_data,
that enables users to specify which data they want the report to display.
either Q_1 or Q_2 . In the before report trigger, you could use the SRW.SET_MAXROW
procedure to ensure that only one query's data is fetched
Function FETCHIT RETURN BOOLEAN IS
IF :p_data <> 1 then