OraFAQ Forum: Reports & Discoverer » details between master

Home » Developer & Programmer » Reports & Discoverer » details between master

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

details between master [message #615373]

Mon, 02 June 2014 23:48

hahaie
Messages: 194
Registered: May 2014

Senior Member

hello
according to file attachment:
should the output of file attachment create by report builder.
in file attachment,output sorted by NUMBER field.
so,details in between master.
how this output implement in report builder?
tanks

Attachment: MASTER.JPG
(Size: 123.05KB, Downloaded 490 times)

Report message to a moderator

Re: details between master [message #615376 is a reply to message #615373]

Tue, 03 June 2014 00:06

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

Senior Member
Account Moderator

Looks like a "Group above" layout.

Report message to a moderator

Re: details between master [message #615379 is a reply to message #615376]

Tue, 03 June 2014 00:33

hahaie
Messages: 194
Registered: May 2014

Senior Member

I do not think,
after what group?master?

Report message to a moderator

Re: details between master [message #615381 is a reply to message #615379]

Tue, 03 June 2014 00:58

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

Senior Member
Account Moderator

This is a master-detail report. Detail records follow its master record. Master record is placed above detail records. This is a "Group Above" layout.

Report message to a moderator

Re: details between master [message #615404 is a reply to message #615381]

Tue, 03 June 2014 08:01

hahaie
Messages: 194
Registered: May 2014

Senior Member

I'm sorry,
this attachment provides a better concept.
now,this attachment how in report builder?

Attachment: out1.JPG
(Size: 30.82KB, Downloaded 563 times)

Report message to a moderator

Re: details between master [message #615415 is a reply to message #615404]

Tue, 03 June 2014 10:45

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

Senior Member
Account Moderator

I don't understand such a layout, especially the "Department" part. Where did Sara's salary go?

Report message to a moderator

Re: details between master [message #615452 is a reply to message #615415]

Wed, 04 June 2014 02:56

hahaie
Messages: 194
Registered: May 2014

Senior Member

department_no,dept_name are id,name of department that sara,behzad lives.
salary of sara,behzad >1000
so,for sara,behzad show information of department

Report message to a moderator

Re: details between master [message #615460 is a reply to message #615452]

Wed, 04 June 2014 04:22

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

Senior Member
Account Moderator

One option is to create a query which fetches all data (emp_no, emp_name, salary, department_no, deptname). Then create format triggers for all fields but emp_no and emp_name.
SALARY format trigger would return FALSE if salary > 1000.
DEPARTMENT_... format triggers would return FALSE if salary < 1000.

Report message to a moderator