Forms :: Excel Charts / How To Set Title And Labels
Apr 13, 2012
im still trying to create workcharts into an Excel sheet (see thread "How to create pie chart in Excel sheet"). I could not be able to create pie chart, but I got to create a histogram chart. Now, I wish to customize labels and legend.
The issue is that the data range is made by non-contigouous cells, and some of them are merged. So, I tried to create by hand a pie chart, and this is the code behind:
Sub Macro1()
'
' Macro1 Macro
'
'
Sheets("SUMMARY COSTS 2011-2012-2026").Select
[code]....
how can I implement this code in Forms 10g using OLE2? In details, how does SeriesCollection work?
View 3 Replies
ADVERTISEMENT
May 31, 2013
Is there a way to prevent Apex from combining labels into an "other" category in the charts?
View 4 Replies
View Related
Mar 20, 2012
I have a question related to margins in button labels. Is it possible to change left / right or top/bottom margin space in that kind of elements ?
View 1 Replies
View Related
Jul 23, 2010
I am using Developer 6i and i want to know how to replace the default icon in form window title bar with company's logo.
View 1 Replies
View Related
May 11, 2009
how to change form applet title .
The default title displayed is oracle developer forms runtime-Web...How can i replace this title with the one i want.
View 4 Replies
View Related
Mar 6, 2007
A form have a frame in the name of 'Frame5'. I need to change the title of the frame.
I Had done like Set_item_property('blkname.Frame5',title,'newtitle');. The coding is compiled properly even i had received the error when im running like 'Unable to resolve references to item blkname.frame5'.
View 6 Replies
View Related
Apr 30, 2013
How to print ampersand & in Oracle report from the parameter.
If give paramter 'Title of the report Profit & Loss'
it Print:-Title of the report- Profit & Loss
If give paramter Title of the report- Profit & Loss(without single code)
it Print:-Title of the report- Profit
View 1 Replies
View Related
Apr 21, 2011
I have a varchar2 column that contains something like this:
10100010
Each digit represents a flag that corresponds to a certain label:
1 - Bananas
0 - Oranges
1 - Apples
0 - Tomatos
0 - ..
0 - ..
1 - Kiwi
0 - Others
What I want to do is, translate '10100010' into the string '(Bananas,Apples,Kiwi)' using SQL-only. As a bonus it would be nice if the string is completely empty if all flags are '0', so no '()'.
View 6 Replies
View Related
Mar 14, 2013
I'm trying to create a histogram based on time range using a bar chart. I made the query correctly and the bar chart displays the histogram.
However I want to make the axes labels on the x-axis go under the tick marks of the axis. Right now they are under the corresponding bar. This doesn't convey the notion of a range. For e.g. if I have 23 observations between 10 and 20 seconds, I need to show 10 on the left of the bar and 20 on the right. In other words the bar is between two tick marks. I want to show 10 under the left tick mark and 20 under the right tick mark.
How do I do this? I tried using the attributes of the label tag under x_axis in the chart xml, but couldn't get it to work.
View 1 Replies
View Related
Jun 22, 2012
I am trying to do a Flash Chart in APEX 3.1. Is there a limitation on how many labels I can get horizontally. No matter what I do the number of labels I get horizontally is 15. We are trying to show the amount of days in a month.... Can I do that? If so how?
View 5 Replies
View Related
Jun 25, 2013
I just upgraded from APEX 4.1.1 to APEX 4.2.2All is good, but I can't create pie charts. Pie Charts never worked for me, but I waited until 4.2.2 to try again. Still will not work. I imported the workspace from my previous APEX version,so something must not be set correct in my workspace. I can create the pie chart on apex.oracle.com
Here's my info:- Application Express Version: 4.2.2- Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production- OS Red Hat Enterprise Linux Server release 5.9- WebLogic 10.3.5- Apex Listener 1.1.3.243.11.40
View 6 Replies
View Related
Jan 29, 2013
I need to create a Radar Chart, this kind of chart isn't avaible on APEX then, I should buid it, I have found some models of this chart, but I'm not getting sucefull when I try to use the data from my database.
I'm using APEX 4.1.
View 1 Replies
View Related
Oct 18, 2012
using APEX can we develop Charts and dashboards.
View 1 Replies
View Related
Nov 21, 2012
I am using "Function Returning SQL Query" (as query is dynamic) to draw the bar chart (flash).
I am facing some issues while trying creating a BI report for this chart.
Issue is : In Shared Components -> Report Queries : Its only expecting an SQL Query.
Do we have any ways to define a "Function Returning SQL Query" over here ? Note that, If using a static SQL both charts / BI reports are working fine with out any issues.
View 3 Replies
View Related
Jul 17, 2013
I have a requirement create graphs, charts and maps based on data from a data warehouse (dw).
As I see things, there are two possibilities: Graphs, charts and maps based on an XML fileGraphs, charts and maps based on Oracle tables Both would contain small data sets that will allow for quick response.
The intent of these graphs, charts and maps is to generate a dashboard that would allow the user to quickly drill down to the desired warehouse data. The proof of concept has already been validated using the Oracle table scenario.
My question is whether or not this could be accomplished reading xml files for generating the same set of dashboard items? My Oracle database and APEX environments configuration are as follows:
NLSRTL 11.2.0.1.0 Production Oracle Database 11g Enterprise Edition 11.2.0.1.0 64bit Production PL/SQL 11.2.0.1.0 Production TNS for Solaris: 11.2.0.1.0
ProductionApplication Express 4.2.2.00.11APEX Listener Release 2.0.2. / Tomcat
An Oracle database directory has been setup and is accessible to our APEX application.
View 0 Replies
View Related
Feb 20, 2013
I just upgraded my APEX 4.0 application to 4.2, and ran the utility to upgrade my charts to HTML5. After completing the upgrade, I noticed my charts no longer displayed in the region.
I am currently using IE9 to view the application, since that's the browser over 90% of my users have. Is there something more I need to install?
View 4 Replies
View Related
Oct 11, 2012
whether the overlapping Multiple series charts are possible in Oracle APEX or not .
I am trying to create two graphs for two data sets , one as marker and another as line , but its giving me issues such as
1) X axis is taking all the points of the first series suppose(
1,5,10,180) itsplotting these first . and its then starting labeling
the x-axis for another one which has values like
(20,50,100,1000,15000)
so my X-axis is now ---> 1,5,10,180, 20,50,100,10000,150000
In case i make my marker chart series as the 2nd sequence , then its drawing all the markers on the right side of the chart .
[URL].........
Workspace:- NR_WORKSPACE
Username:-user1
password:- H123$
whether this thing is achievable in oracle apex or not , is there any work around ?
View 0 Replies
View Related
Feb 9, 2010
I am trying to put a report footer on a report that has a title.
However, when I specify the REPFOOTER under the title specification, I get the text after every row in the report. If I put it before the TTITLE definition, I get the TTITLE text before and after the report and the REPFOOTER text after the report.
How do I get the TTITLE to appear only before the report and the REPFOOTER text to appear only after the same report?
For example, if I specify
REPFOOTER 'footer text'
TTITLE 'title text'
the above text prints the TTITLE text before and after the report. and the REPFOOTER text after the report. Is there a way to only have the TITLE text come before the report and the REPFOOTER text after?
View 1 Replies
View Related
Oct 17, 2012
i am getting error when iam starting enterprise manager GUI dbcosole,its not displaying the graphs of HOST CPU and active session graphs instaed its giving me error such as java.lang error and null point error below the graphs.
i stop and start the dbconsole from services and from command prompt and rebooted the server,but still showing the same error..did open in other kernals such as mozilla and google still the same issue..
View 3 Replies
View Related
May 28, 2010
I want to export forms data into Excel sheetfor that i am using Client_Ole2.I have attached Webutil object library and Pl/Sql libraryStill I can not export data from Form to Excel sheet
View 7 Replies
View Related
Aug 21, 2013
i I am using APEX4.2 and created
(1) a drop down list item called P38_DESK which contains a list of desks such as A, B, C
(2) a Chart region with region title: Chart Mvt by &P38_DESK.
(3) a dynamic action to "refresh" the Chart region if the value of P38_DESK is changed.
I can see that everytime the desk is changed from the drop down list, the chart section/region gets refreshed accordingly but NOT the Chart's region title.
It only showed the first value I chose. e.g. Chart Mvt by A So in APEX4.2, how can the CHART's region title be changed dynamically ( without submitting the entire page ) to reflect the value from the drop down list P38_DESK ?
View 7 Replies
View Related
Apr 12, 2013
I have task. I am using oracle forms 6i. I want to import excel data to oracle forms(its common task using ole2 package). But this time I want to map the columns i.e my database table having 5 columns. and the excel file is having 2 or 3 columns then i suppose to map those columns and accordingly insert it to my table.
So far i have import column heading of excel to oracle forms, then i've provide list item for mapping each column. so that user can map excel column to database columns. Now I am confuse how to write the code so that selected columns should get inserted into database.
-more details
I have table with columns id, name, location, address, plan. in those columns i need to insert records form excel. user having a excel with 3 columns col1, col2, col3. on the form i've fetch column headers of excel and in front of that i've provide database column list , so user can match excel column with database column. e.g.
COL1 --> list value of database column
COL2 -->list value of database column
COL3 -->list value of database column
Once user map those column i want to insert those values into my database table (table with columns id, name, location, address, plan). and i am confuse about this code.
View 1 Replies
View Related
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
Jul 6, 2012
How to use process to display the date parameters selected by the user to generate the report in Page title ?
View 2 Replies
View Related
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
Mar 30, 2012
I need to generate a single excel file which each department details in seperate sheets of the excel file, each sheet should ne named with department no (ex :Dept_10, Dept_20,Dept_30) and the main excel should be named as Emp_details.
Header row and total row should be in bold.I have created 3 individual excels thru toad and moved them to single excel and renamed the sheets.
Can we programatically do this thru SQL or PL/SQL, does Oracle provide any build packages for excel.As excel files cannot be uploaded,I am unable to upload the excel file I generated manually.
select to_char(empno) empno,ename,job,mgr,hiredate,
nvl(sal,0) sal,nvl(comm,0) comm,nvl(sal,0) + nvl(comm,0) "Total Income" ,deptno
from emp
where deptno = 10
union all
select 'Total',null,null,null,null,sum(nvl(sal,0)),sum(nvl(comm,0)),sum(nvl(sal,0))+sum(nvl(comm,0)),null
from emp
where deptno = 10;
View 1 Replies
View Related
Jun 23, 2010
I have generate a excel file through oracle developer 2000 6iwith password protect using OLE2 but autofilter,sort and format column options are not working.
PROCEDURE UnProtectCell(r NUMBER,c NUMBER) IS
BEGIN
args:= ole2.create_arglist;
ole2.add_arg(args, NumToRange(r, c));
XLRange:= ole2.get_obj_property worksheet, 'Range', args); ole2.destroy_arglist(args);
[code]...
View 6 Replies
View Related
Apr 27, 2010
if there is a way to import excel to form in Oracle Apps Server running on UNIX using forms program unit?wanted to know where do we need to place the file on the server and how do we need to invoke the excel.
View 29 Replies
View Related
Jul 20, 2005
I have been using F60util.pll to convert a form contents directly. But in Forms 9i , this library is giving an error. Which alternative should i use for F60util.PLL.
View 4 Replies
View Related
Jul 17, 2013
I create this because I need a way to export SQL commands in several forms to Excel without using CSV files. So this routine opens MS-Excel automaticaly and then export the data of the SQL into a sheet within the excel. Is a procedure that can be use in any form and using simple or complex SQLs.
I compressed 3 files in the TXT file. So, first change the extension from TXT to RAR and then unzipped the file.
View 6 Replies
View Related
