Home » Developer & Programmer » Reports & Discoverer » master-detail report (oracle 10g)
master-detail report [message #590586] Fri, 19 July 2013 07:49 Go to next message
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.
Re: master-detail report [message #590686 is a reply to message #590586] Mon, 22 July 2013 02:20 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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".
Re: master-detail report [message #602307 is a reply to message #590586] Mon, 02 December 2013 22:56 Go to previous message
shahzad-ul-hasan
Messages: 615
Registered: August 2002
Senior Member
have you solve your problem???
Previous Topic: Pass parameter from forms to Report (Very Urgent)
Next Topic: barcode
Goto Forum:
  


Current Time: Thu Mar 28 03:43:02 CDT 2024