Home » Developer & Programmer » Reports & Discoverer » master/transaction report
master/transaction report [message #212682] Sun, 07 January 2007 12:52 Go to next message
lune
Messages: 27
Registered: August 2006
Location: UAE
Junior Member

Hi All

I have a master /transaction report

let say for example emp table and dept table
let say there are some department that do not
have employee on it

How can I show only the department that have enployee
and remove the department without employee from the report


can anybody help me?


____
lune

Re: master/transaction report [message #212719 is a reply to message #212682] Sun, 07 January 2007 23:25 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If there are two tables involved, query which fetches data from them uses a join. It will, by default, omit departments that do not have employees. But if you use OUTER join, all departments will be displayed.

So, it seems that you used outer join. Have you? If so, don't use it.
Re: master/transaction report [message #213095 is a reply to message #212682] Tue, 09 January 2007 08:24 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
hi lune,

have u solved your problem?

Bye
Ashu
Re: master/transaction report [message #213370 is a reply to message #213095] Wed, 10 January 2007 08:19 Go to previous messageGo to next message
lune
Messages: 27
Registered: August 2006
Location: UAE
Junior Member


Hi

Unfortunately No I Haven't Solve it

Re: master/transaction report [message #213827 is a reply to message #213370] Fri, 12 January 2007 08:00 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
hi lune

I hope you have solved you problem if not then try for the one I am sending to you.

Bye
Ashu
  • Attachment: mat_det.RDF
    (Size: 40.00KB, Downloaded 175 times)
Re: master/transaction report [message #214012 is a reply to message #213827] Sat, 13 January 2007 09:51 Go to previous message
lune
Messages: 27
Registered: August 2006
Location: UAE
Junior Member

Hi Ashu,

Thank You for ur help I will try it


-----
lune
Previous Topic: Upgradation of Oracle Discoverer from release 4 to 9i.
Next Topic: Discoverer cannot handle B- and B+ value
Goto Forum:
  


Current Time: Tue Dec 06 16:30:31 CST 2016

Total time taken to generate the page: 0.04968 seconds