Home » Developer & Programmer » Reports & Discoverer » View gross salary on section wise (developer 6i, )
View gross salary on section wise [message #651735] Tue, 24 May 2016 03:24 Go to next message
Salehin
Messages: 62
Registered: March 2013
Location: Chittagong, Bangladesh
Member
As our company have different section i.e cutting, quality, finishing etc. when I run emp_check report file it shows gross only cutting section because I select n_gross_cut on query. Is there any way to show every section's gross on my report. I attach a picture of my report.
/forum/fa/13135/0/
  • Attachment: 5%.jpg
    (Size: 179.29KB, Downloaded 2166 times)
Re: View gross salary on section wise [message #651737 is a reply to message #651735] Tue, 24 May 2016 03:40 Go to previous messageGo to next message
Salehin
Messages: 62
Registered: March 2013
Location: Chittagong, Bangladesh
Member
Please check my rdf file
Re: View gross salary on section wise [message #651738 is a reply to message #651737] Tue, 24 May 2016 04:13 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Your refusal to write any SQL yourself shows extreme laziness. You also refuse to answer requests such as showing the query behind that report. Showing industry in creating new topics does not disguise this.

Generally, you give the impression of being a lazy sloth who does not deserve assistance. Perhaps other people will disagree.

[Updated on: Tue, 24 May 2016 04:15]

Report message to a moderator

Re: View gross salary on section wise [message #651742 is a reply to message #651738] Tue, 24 May 2016 05:00 Go to previous messageGo to next message
Salehin
Messages: 62
Registered: March 2013
Location: Chittagong, Bangladesh
Member
Sorry dont misunderstand I thought if i share it in reports section that will help me because barbara said to me that she had nothing to open my rdf file.

here is my sql code

select ep.empno, ep.b_name, ep.card_no,ep.first_name||' ' ||ep.middle_name||' '||ep.last_name ename,
ep.religion_name, em.des_name,ep.age, em.N_GROSS_HLP , eo.section_name,eo.joining_date, em.grade,eo.floor_desc
from emp_personal ep, emp_official eo, emp_payment em
where ep.empno = eo.empno
and ep.empno = em.empno(+)
--and eo.section_name = 'Sewing'

and eo.joining_date between '1-APR-2015' and '30-APR-2015'
--and ((eo.joining_date between '1-may-2014' and '31-may-2014') or (eo.joining_date between '1-may-2015' and '31-may-2015'))
and ep.status = 'Active'
and eo.ot_ent = 'Yes'
--and em.grade between '3' and '6'
--and eo.floor_desc=:floor
and eo.company_name = :unit
order by ep.empno

[Updated on: Tue, 24 May 2016 05:03]

Report message to a moderator

Re: View gross salary on section wise [message #651745 is a reply to message #651742] Tue, 24 May 2016 05:52 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
So try the logic that you have been shown to display the appropriate column value, depending on the value of section_name. You have been given examples. Only a lazy sloth would persist in refusing to do this.

And, by the way, please read How to use [code] tags and make your code easier to read and use [code] tags next time you post code. Also, format your code, http://www.dpriver.com/pp/sqlformat.htm you will find it easier to debug if you do.
Re: View gross salary on section wise [message #651784 is a reply to message #651742] Wed, 25 May 2016 02:10 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
Please see my latest response in your previous thread:

http://www.orafaq.com/forum/mv/msg/200973/651777/#msg_651777
Re: View gross salary on section wise [message #651957 is a reply to message #651784] Sat, 28 May 2016 05:36 Go to previous message
Salehin
Messages: 62
Registered: March 2013
Location: Chittagong, Bangladesh
Member
Sorry I am quite busy with office task. Catch you later.
Previous Topic: Report Builder has stopped working
Next Topic: How to embed email body when sending oracle report as an attachment
Goto Forum:
  


Current Time: Thu Mar 28 11:37:56 CDT 2024