ERPstuff - Oracle EBS Community

Hi,
I've a report of multiple indicators,in this report i've matrix consists of two groups (then indicators name and the time dimention),my problem is that when i tried to draw chat of indicator's value with time dimention i couldn't see any field in this groups (within the matrix).
I've db oracle ...

Hi,
Thanks for your reply.
I want the unique values for each column separately. The output will be like this :

IND_TIME_YEAR: 2007, 2008
IND_TIME_MONTH: 1,2,3,7,8
CON_ID: 123,234,345
GVN_ID: 098,087

Regards,

Hi,
I've a report query and i want to get the distinct values of each column in this query, is there a way to do this?
I've oracle 10g and reports 6i.
Regards

Hi,
I've tried to manage four list items relateed to each other
the countries,states,cities,areas. when i change the value in the first list the second list should populated with values related to the first list and the third list should populated with values related to the second list and so on ...

Hi,
I've a form which contains items.
when i chaged a list in this form at runtime some items should appear and some shouldn't,My problem is to get ride of the space between items i redrawing the items and this operation takes time.
Is there any way to do this whith out redrawing the items.
I've ...

Hi,
I'm working on database oracle 10g and form developer 6i.
I have LOV returns the first name and the last name of the employees.If I press f9 and write the first letter (S for example)it brings the employees whoes first name begin with S, what i want is that after writting the first letter i want ...

Hi,
I'm sorry, there was a mistake in the question.
What i mean is that I've got a data set:

Location Deptno Ename
NEW YORK 10 MILLER
NEW YORK 20 FORD
CHICAGO 10 KING
NEW YORK 30 JAMES
CHICAGO 20 ADAMS

The goal is to have 1 row only per Deptno

Result set should look like for deptno=10 ...

Hi,

I need some help on how to do this:

I've got a data set:

Deptno Ename
10 MILLER
20 FORD
10 KING
30 JAMES
10 CLARK
20 ADAMS

The goal is to have 1 row only per Deptno

Result set should look like:

Deptno Ename1 Ename2 Ename3
10 MILLER KING CLARK
20 FORD ADAMS
30 JAMES

Any Ideas ...

Hello
I have oracle developer 6i and oracle database 10g.
In the report I want to display the chart's bars or the lines in different colors depending on the values.
For example employee in sales department whose salary over 1000 $ and have commission will display in red color while the employees ...

Hello - I have oracle database 10g.
I want to draw an organizational chart include the hierarchy of the employees in table emp,
but i don't want to draw the hierarchy as a tree in SQL. I want to draw it as a diagram.
example:

KING
/ | \
JONES BLAKE CLARK
/ \ | |
SCOTT FORD ALLEN MILLER ...

hi
i'd like to know how can i merge two hierarchical trees together.
for instnace to query for each deparatment all its employees with considering to the employees hierarchicy.

HELLO....
I WOULD LIKE TO KNOW How to retrieve LONG RAW image from Oracle 10G database table and put it in a control item due to a specific employee number.
regards
nadia

i don't have porblem in lexical parameter.
my problem is like this:
in group1 i passed a lexical parameter but in group2 i have a tree with no data link to group1, for example group1 contains depts and group2 contains emps but there aren't any data link and i want to appear for each dept it's emps ...

Thanks for your attention,
i'm facing this problem in oracle reports.

hi
i have a problem and i need some help. i'm trying to change the value of a field at excution time ,the problem is that i have two queries without any link between them and i want to change data the second query due to the data in the first query.
with regards