Search found 15 matches
- Mon Aug 11, 2008 5:58 am
- Forum: Oracle Forms & Reports
- Topic: How to draw chart with matrix?
- Replies: 0
- Views: 1159
How to draw chart with matrix?
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 1...
- Mon Mar 17, 2008 4:55 am
- Forum: Oracle Forms & Reports
- Topic: How to get distinct values?
- Replies: 3
- Views: 9495
- Sun Mar 16, 2008 5:07 am
- Forum: Oracle Forms & Reports
- Topic: How to get distinct values?
- Replies: 3
- Views: 9495
How to get distinct values?
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
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
- Thu Jan 31, 2008 4:06 am
- Forum: Oracle Forms & Reports
- Topic: how to manage many list items in forms 6i?
- Replies: 0
- Views: 1158
how to manage many list items in forms 6i?
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. Th...
- Tue Jan 29, 2008 4:10 am
- Forum: Oracle Forms & Reports
- Topic: How to redrawing items in a form?
- Replies: 0
- Views: 1171
How to redrawing items in a form?
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 ora...
- Wed Nov 21, 2007 7:22 am
- Forum: Oracle Forms & Reports
- Topic: How to manage the result of LOV?
- Replies: 1
- Views: 1426
How to manage the result of LOV?
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...
- Wed Sep 26, 2007 3:42 am
- Forum: Oracle Databases
- Topic: How to convert many row data to columns?
- Replies: 3
- Views: 2136
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: Location 10 2...
- Tue Sep 25, 2007 4:22 am
- Forum: Oracle Databases
- Topic: How to convert many row data to columns?
- Replies: 3
- Views: 2136
How to convert many row data to columns?
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? Thanks
- Wed Aug 29, 2007 2:55 am
- Forum: Oracle Forms & Reports
- Topic: Graphic builder 6i
- Replies: 0
- Views: 1108
Graphic builder 6i
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 who...
- Wed Aug 29, 2007 2:45 am
- Forum: Oracle Forms & Reports
- Topic: drawing an organizational chart
- Replies: 0
- Views: 1192
drawing an organizational chart
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 | | | ADAMS S...
- Wed May 30, 2007 4:25 am
- Forum: Oracle Forms & Reports
- Topic: hierarchical query
- Replies: 1
- Views: 1478
hierarchical query
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.
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.
- Wed May 23, 2007 7:23 am
- Forum: Oracle Forms & Reports
- Topic: How to retrieve LONG RAW image from Oracle 10G dat
- Replies: 0
- Views: 1203
How to retrieve LONG RAW image from Oracle 10G dat
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 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
- Mon May 14, 2007 5:08 am
- Forum: Oracle Forms & Reports
- Topic: changing parameter value at run time
- Replies: 6
- Views: 2338
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 a...
- Mon May 14, 2007 4:12 am
- Forum: Oracle Forms & Reports
- Topic: changing parameter value at run time
- Replies: 6
- Views: 2338
- Mon May 14, 2007 2:50 am
- Forum: Oracle Forms & Reports
- Topic: changing parameter value at run time
- Replies: 6
- Views: 2338
changing parameter value at run time
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
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