I HAVE A REPORT LAYOUT LIKE THIS
RUNDATE -FIELD DEPTNO-FIELD
------------------------------------------------------------
-------------------
EMPNO-----ENAME------SAL-----COMM----MGR-----
------------------------------------------------------------
------------------
------- ------------ -------- -------- --------
MY REQUIREMENT IS I WANT DEPTNO 10 VALUES IN ONE
PAGE,DEPTNO 20 VALUES IN ONE PAGE,AND 30 IN ONE PAGE.
I WANT LIKE THIS ....
Answers were Sorted based on User's Feedback
Answer / shaheem
use page protect property set to yes for the repeating frame
for the group dept.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / manjunath
Hi,
U will create group above style for the deptno. After that u
will select repeating frame of group deptno properties there
u can change the property Maximum Records For Page - 1
u will get required Output
Bye..
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nabi
goto repeating frame property palletese
and set maximun number of records= 1
Is This Answer Correct ? | 1 Yes | 0 No |
In what situation u create the BPA.
Can we create two blocks with the same name in form 3.0 ?
can u call procedure or function is sq l query in reports
HOW TO MAKE A MATRIX REPORT MANUALLY WITH SINGLE GROUPT QUERY OR MULTIPLE GROUP QUERY ?
What is the order of the triggers fired once the form is opened?
What are all the system Parameters available in ORACLE Reports
HI in report builder am creating paramters.for that i have taken emp table from scott user . in deptnum am displaying distinct deptno.if i select dept 10 ,empnum drop down should display empno's of deptno 10. .if i select dept 20 ,empnum drop down should display empno's of deptno 20.for this wat i have to do.
What are the Coordination Properties in a Master-Detail relationship?
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
what is the difference between call_form, new_form and open_form?
What is the use of Validation triggers in Reports?
How to solve the error ?Frequency below its group? while running the report. Why it is happened and How to solve that?