Forms :: Pie Chart And Vertical Bar Graph In Oracle 10g

Oct 8, 2013

I have two graph pj item in oracle block one is pie chart and other is vertical bar graph... there is color display in bottom of pie graph which is red=50,yellow-30 and orange=20 ..and in vertical bar red=50,but orange=30 and yellow is 20 ..means orange and yellow is interchange in bar graph..how i can same the both graph value..

the graph is populate through cursor and graph properties is setting through set_custom_propert();

View 1 Replies


ADVERTISEMENT

Application Express :: Drag N Drop Graph In Gantt Chart?

Aug 26, 2013

I'm gonna create a Gantt chart on Oracle APEX and want to re-size, move the graph into other line..how to control the graph itself (just like javascript, ajax and anychart API...) URL.....

View 0 Replies View Related

Application Express :: Customize Tooltip In Flash Chart / Graph

Dec 4, 2012

Is there any way I could customize tooltip (when you go over the bar in the report, small box with the value appears).I would like to display different values there.

View 0 Replies View Related

Application Express :: Chart With Vertical Y-axis Title Having Horizontal Letters?

Oct 24, 2012

I've edited the XML on the Chart Attributes page but I don't find atrtributes to rotate the y-axis title (<text>TITLE</text>) nor the letters themselves in the title. What I'd like is something very close to

T
I
T
L
E

But what I get is a horizontal title rotated -90 degrees. I've looked at lots of Anychart documentation but don't find anything that seems to fit with the XML already given on the Chart Attributes page. I've seen the "rotate" attribute but I don't know where it would go and even then, I'm sure it only rotates the title as a unit and not the individual letters.

View 0 Replies View Related

Forms :: Create Line Graph On Oracle 11g?

Mar 12, 2013

how can i create line graph on oracle 11g forms

View 1 Replies View Related

Oracle Forms 10g Insert Pie Chart In Excel Sheet?

Mar 9, 2012

I have been requested to create an excel sheet report in my Forms application (10.1.2.0.2) with data grouped in a pie chart, something like the attached pic (if you cant open go to this link: [URL]

I'm able to create the excel sheet by using OLE2 tool, but I dont know how to insert my pie chart from code.

Attached File(s)

piechart.jpg ( 251.88K )
Number of downloads: 1

View 1 Replies View Related

Forms :: How To Design A Simple Graph

May 23, 2011

How to design a Simple Graph?

View 1 Replies View Related

Export Graph From Oracle Enterprise Manager?

Aug 12, 2013

is there a way to export/download graphs that are shown on Oracle Enterprise Manager? I tried to find some buttons that make it possibile, but I'm unable to find them...

View 1 Replies View Related

Forms :: Vertical Text On Buttons

Jan 5, 2011

Refresh my memory if there's a way to display vertical text on buttons in forms?

e.g. v
e
r
t
i
c
a
l

View 3 Replies View Related

Forms :: To Output Query In Vertical Way

Dec 27, 2011

i have output query in 1 row, for example

Id Name Salary
100 John 2000

i need to output the same query in vertical way like:

100
John
2000

View 3 Replies View Related

SQL & PL/SQL :: Vertical Partitioning In Oracle

Mar 19, 2013

Explain me steps to do vertical partitioning in oracle .

View 3 Replies View Related

Forms :: Horizontal And Vertical Scroll Bar For Tabular

Aug 20, 2011

i need to create a form with 15 col and 10 records in tabular format to display records from the table....i done it with vertical scroll bar ..bt.i need both horizontal and vertical scroll bar for that tabular.

View 2 Replies View Related

Forms :: Vertical Scroll Bar Is Not Showing Properly?

Mar 1, 2010

When I first access the form and query for records, it works as per the expectation and with scroll bar to scroll up and down. But when I do "View>Record>Last", it reaches to last record, but not able to use the scroll bar to scroll the records up(I am on last record, so can't do downward scrolling).

The scroll bar is displaying in Full, no room to scroll up down.It happens only when I do "View>Record>Last".

View 2 Replies View Related

Forms :: Design Mode - Horizontal And Vertical Scroll Bar

Oct 25, 2010

How to create horizontal and vertical scrollbar at a time while design mode??

View 2 Replies View Related

Forms :: Vertical Scrollbar Not Showing All Records When Scroll Down?

Sep 14, 2011

Vertical scrollbar not showing all the records when I scroll down.

Using Oracle forms 10g , operating system windows.

I have two fields with number of items dispayed = 15.

I have a vertical scroll bar with them. There are 34 records in the table but the scrollbar only shows 15 records.

View 22 Replies View Related

Forms :: How To Create Pie Chart In Excel Sheet

Mar 9, 2012

In my Forms application, I must create an Excel sheet with data displayed by a pie chart, i.e. something like this

[URL]......

I'm able to create the Excel sheet by using OLE2 tool, but I dont know how to create and insert the pie chart. Searching in this forum, I found this post:

[URL].....

it's useful, but somewhat hard to understand. In detail, how can I set the form_charttype and form_chartsource so that it would produce my pie chart?

View 6 Replies View Related

Forms :: Organization Chart - Generate Automatically Without Opening Any Program

Apr 11, 2007

I need is to generate this chart automatically from the form builder without opening any program like visio (for instant). that's mean when I select the wanted department the chart will be generated automatically .

View 9 Replies View Related

Reports & Discoverer :: Get Graph Output At Report Level?

Dec 24, 2010

get Graph output at report level.

View 1 Replies View Related

Reports & Discoverer :: Change Format Of Figure Display On Bar Graph?

Aug 18, 2009

how i can change format of figure display on bar graph(data labels) in oracle 10g graphical reports .i want to change format fom 99.99 to 9999 .

View 1 Replies View Related

Reports & Discoverer :: Graph - Repeating Frame (Change Dynamically Y And X Axis Title)

May 23, 2012

I'm presently creating a Graph on a repeating frame.

I made a query with a group that pointing to the repeating frame.

The problem : I want to change dynamically the Y and X axis Title.

The graph accept user parameter inside the XML file. But how to make it dynamically based on SQL query?

I try with formula, but can't make it work with a group. I have to put the formula at Report Level, but to make it dynamically for each group i have to make it work at the group Level.

View 1 Replies View Related

Reports & Discoverer :: How To Set Vertical Alignment In 6i

Nov 5, 2010

how can i set the alignment of the text field in report 6i.

View 10 Replies View Related

SQL & PL/SQL :: Making Vertical Records To Horizontal

Aug 18, 2010

I need to build a query on making a vertical records to horizontal records. I did read somewhere saying that we can use decode function. But im still trying to understand how decode function can make a vertical records to horizontal records.

View 4 Replies View Related

SQL & PL/SQL :: Convert The Table From Vertical To Horizontal

Apr 21, 2010

I have a table like the

WEEK STORE SALES
1 A 12
2 A 18
3 A 20
4 A 25

I need a query to build out put like

store week1 week2 week3 week4
A 12 18 20 25

View 4 Replies View Related

Client Tools :: Vertical Display Of Table

Jun 29, 2010

I would like to format my output for the select query.

Example:

SQL>select empno, ename from emp;

empnoename
1987766Jack Blake
187765Greg Ni

But I would like to get the output in the below format

EMPNO:.................1987766
ENAME:.................Jack Blake

EMPNO:.................187765
ENAME:.................Greg Ni

I will need printing the column name. I would like to know how do we address the column name to print.

View 24 Replies View Related

Server Utilities :: Loading Vertical Data Using Sqlldr?

Aug 23, 2013

Here's my table:

SQL> desc stg_query_overflow
Name Null? Type
----------------------------------------- -------- ----------------------------
HOSTNAME VARCHAR2(50)
NPSID NUMBER
NPSINSTANCEID NUMBER
OPID NUMBER

[code]....

Here's my controlfile:

load data
infile '/u01/tony/server_name/query_overflow.dat'
badfile '/opt/oracle/tony/sql_dir/bad/server_name_query_overflow.bad'
discardfile '/opt/oracle/tony/sql_dir/discard/server_name_query_overflow.dsc'
append
into table stg_query_overflow

[code]....

Here's a sample of data that I can't load into the table via sqlldr:

echo
echo ***** Creating view: "pul_promotion_response"
CREATE or replace VIEW "pul_promotion_response"
(
"promo_rsp_id",
"promo_hist_dtl_id",
"indiv_id",

[code]....

Here's the error(s) I receive in my log file:

Record 272: Rejected - Error on table STG_QUERY_OVERFLOW, column NPSID.
ORA-01722: invalid number
Record 273: Rejected - Error on table STG_QUERY_OVERFLOW, column NPSID.
ORA-01722: invalid number

As you can see, sqlldr is interpreting this vertical sql code as the npsid column, when in fact it is the querytext column. How can I insert each record when some of my data is in this vertical format?

View 1 Replies View Related

Application Express :: How Vertical Left Side Menus Created

Jun 11, 2012

I was keen on creating left side vertical menus instead of using a tab for every page to organize my application better. An example is

[URL].......

I tried creating a list and attaching it to a page. Did not work. Still investigating this. Specifically, what list option that person is using. Not sure, if its really a list or maybe the vertical navigation bar?

View 3 Replies View Related

Reports & Discoverer :: Vertical Expansion Based Upon Info In Previous Column

Mar 19, 2012

I've a 6 column report where col5 is set to expand vertically (based upon comments) and works wonderfully. Col6 is a single character column, therefore does not expand so the report looks rather messy.

I would like col6 to expand in accordance to col5. Is it possible?

View 8 Replies View Related

Application Express :: Enkitec Navbar Vertical List Appears Momentarily?

Jul 24, 2013

Apex 4.2.0.00.27Firefox 22.0, IE 8 Just started using the Enkitec Navbar, and we have noticed that when a page is rendered a vertical list always appears momentarily before being replaced with the Navbar list. It happens on all applications we have installed it on, and every time a page is refreshed. 

View 13 Replies View Related

SQL & PL/SQL :: Hierarchical Query For Chart Of Account

Aug 19, 2013

I want Hierarchical Query..I have Table of chart of account

CREATE TABLE COA
(
ACCOUNT_CODE CHAR(19),
ACCOUNT_TITLE VARCHAR2(70),
ACC_TYPE Char(1),
PARENT_CODE CHAR(19)
)
[code]....

View 2 Replies View Related

Application Express :: Tooltip For Pie Chart?

Oct 26, 2013

I have a 2D pie chart. The chart takes the column names as label and shows the results(3)  like passed--4, failed--3, on hold ---6.  Now I want to have tooltip  , if I point on passed--4, it should show  "number of students passed  last year"similarlyIf I point on failed--3, it should show  "number of students failed  last year"

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved