| Master Detail Model Editor Problem [message #545519] |
Thu, 01 March 2012 00:09  |
 |
asad.mahmood
Messages: 3
Registered: February 2012
Location: Islamabad
|
Junior Member |
|
|
Dear All,
I am facing problem in report while creating the Data Model. Here is two tables name
1. tblsalary
2. employee
query is
select * from employee
where employee.employeeid = tblsalary.employeeid
my report has tree portion one is showing salary by department wise in pie chart. second portion is showing salary by role wise in bar chart and third portion the salary of individual employee in Data Table.
when i click ok any department the click any role it display the employee salary for the clicked department and role but display wrong data..
Please tell me i need master detail Model Editor so what will be the correct way.
Thanks
Regards,
Asad mahmood.
|
|
|
|
|
|
|
|
|
|
| Re: Master Detail Model Editor Problem [message #545558 is a reply to message #545539] |
Thu, 01 March 2012 03:27  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Sorry for the confusion; I updated my previous message. I forgot to put "I" there, which significantly changed the sentence.
I didn't mean that you shouldn't use "that tool" (at that time, we didn't know it is Oracle BI Publisher). I meant to say that "I don't use that tool" (which is based on a fact that I'm not familiar with terminology you used).
As of duplicate salaries: can you run that query in SQL*Plus? What is the result? If it is OK, then you should search for solution in Oracle BI Publisher. If it is still incorrect, then it is query that should be modified. Obvious "workaround" might be to include "SELECT DISTINCT", but that might not be a correct solution.
Anyway: perhaps you should wait for someone who actually knows how to use that tool; I'm useless.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
