Home » Developer & Programmer » Reports & Discoverer » details between master
details between master [message #615373] Mon, 02 June 2014 23:48 Go to next message
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 1171 times)
Re: details between master [message #615376 is a reply to message #615373] Tue, 03 June 2014 00:06 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Looks like a "Group above" layout.
Re: details between master [message #615379 is a reply to message #615376] Tue, 03 June 2014 00:33 Go to previous messageGo to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
I do not think,
after what group?master?
Re: details between master [message #615381 is a reply to message #615379] Tue, 03 June 2014 00:58 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: details between master [message #615404 is a reply to message #615381] Tue, 03 June 2014 08:01 Go to previous messageGo to next message
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 1171 times)
Re: details between master [message #615415 is a reply to message #615404] Tue, 03 June 2014 10:45 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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?
Re: details between master [message #615452 is a reply to message #615415] Wed, 04 June 2014 02:56 Go to previous messageGo to next message
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
Re: details between master [message #615460 is a reply to message #615452] Wed, 04 June 2014 04:22 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: details between master [message #615465 is a reply to message #615460] Wed, 04 June 2014 04:39 Go to previous messageGo to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
Thank you so much dear friend, was very simple.
I do not know why I do things for myself too hard!
Re: details between master [message #615466 is a reply to message #615465] Wed, 04 June 2014 04:41 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Lack of experience, I guess.
Re: details between master [message #615476 is a reply to message #615466] Wed, 04 June 2014 05:47 Go to previous message
hahaie
Messages: 194
Registered: May 2014
Senior Member
Yes, unfortunately

[Updated on: Wed, 04 June 2014 05:47]

Report message to a moderator

Previous Topic: Postscript Generation
Next Topic: Problem Dot Matrix Printers Print
Goto Forum:
  


Current Time: Thu Mar 28 05:04:26 CDT 2024