OraFAQ Forum: Reports & Discoverer » master-detail report

Home » Developer & Programmer » Reports & Discoverer » master-detail report (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

master-detail report [message #590586]

Fri, 19 July 2013 07:49

furqan
Messages: 115
Registered: January 2012
Location: Hyderabad

Senior Member

dear experts

my report is based on two tables.master and detail.
i am using GROUP ABOVE style.displaying master tables
columns up and detail table columns down.

my problem is ...i want 3 columns from master table
(i.e)RECEIVER ID,RECEIVER NAME and RECEIVE DATE to
be printed at the bottom of the page.

and also i want only 4 records from detail table to be printed
on each page.

please help.

Report message to a moderator

Re: master-detail report [message #590686 is a reply to message #590586]

Mon, 22 July 2013 02:20

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

i want 3 columns from master table (...) to be printed at the bottom of the page.

Stretch the frame so that it covers the whole page; set its Vertical elasticity to "fixed". Move these fields to the bottom of the page (you'll probably have to disable flex and confine when doing that, otherwise everything will move up and down (stretch) or (some of) these fields will stuck in a wrong frame.

Quote:

i want only 4 records from detail table to be printed

Set "Maximum records per page" for that repeating frame to "4".

Report message to a moderator

Re: master-detail report [message #602307 is a reply to message #590586]

Mon, 02 December 2013 22:56

shahzad-ul-hasan
Messages: 638
Registered: August 2002

Senior Member

have you solve your problem???

Report message to a moderator

Previous Topic:	Pass parameter from forms to Report (Very Urgent)
Next Topic:	barcode

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 02:43:36 CST 2024