I would like to know if its possible to pass variables into an url and to get them by javascript into the Region header.For example, I have the url: http://my_server:7777/pls/htmldb/f?p=102:1:::NO::P1_LOGIN,P1_TABLE:toto,correspwhere P1_LOGIN=toto and P1_TABLE=corresp and I want to get the value of ...
it looks like that the a Flash Chart region doesn't renders the text of the "Region Header" property in the header of the region, instead it is rendered in the footer of the region.See http://apex.oracle.com/pls/otn/f?p=2672:1 for an example.For SVG Charts it works.Patrick Check out my APEX-blog: ht ...
We are running APEX 3.1.2 in our environment.I have an application where we have put text information in the headers and footers of all regions and pages. The information in each header and footer is the same for each page, and region markings are the same as well.I input the text (wrapped in html t ...
I am using an interactive report, I want to change the report region header to contain the text:Data Last Refreshed on: 09-AUG-2010where the date is populated via a SQL query against the database.QUESTION: How can I get the result of a query to appear in the region header of an interactive report?I ...
May I ask you guys about 'Specifying a Region Header and Footer' on Region Definition?I have tried to use the #TIMING# and #ROWS_FETCHED# strings on a region and set the parameters on the region header as follows:-===Row(s) #FIRST_ROW_NUMBER# through #LAST_ROW_NUMBER# of #ROWS_FETCHED# displayed===H ...
For some complex query regions of type "PL/SQL function returning query", is there a way to display the actual query being executed (with all bind variables substituted) in the HTML source of the page? In other words, is there a way to put it in HTML comments in the region header or footer? ...
I have a region that uses a SQL Query to generate report output. I have created a hidden field in the region called P10_TEMPIP, using the Source Value or Expression area I use :P10_TEMPIP := owa_util.get_cgi_env('REMOTE_ADDR') to assign it a value. I am trying to display the hidden field in the regi ...
When I click navigate toWorkspace XXX>Builder - Application XXX>Application Reports>Search Region Header and FooterI get areport error:ORA-06502: PL/SQL: numeric or value error: character string buffer too small ...
How do I set the sysdate in a region header or footer?I tried creating a global variable which is filled ON_NEW_INSTANCE but I am not sure how to access it in the header or footer.....The idea is to put something like:'Messages changed between #TWOWEEKSAGO# and #NOW#' in the header. ...
HiIam new to this oracle application express and in the process of learning it. I want to know about the region header and footer attributes and for these attributes can be used and i found that some java script can be placed in region and footers though html header and body are present in the page. ...
I am using "Region Templete without buttons and Titiles".in this, i have lot of empty space on top and bottom of the region.looks like this is because of header and footer's heights....how can i set region header and footer height (equal to 0) ...
I realize that I a can alter the Column Header Cell to some degree utilizing: .apexir_<columname>And I realize Oracle does not want to disclose documents to support developers in this area.Question I have a requirement to have a more dynamic IR Report Column Header utilizing APEX 3.2.The appli ...
I realize that I a can alter the Column Header Cell to some degree utilizing: .apexir_<columname>And I realize Oracle does not want to disclose documents to support developers in this area.Question I have a requirement to have a more dynamic IR Report Column Header utilizing APEX 3.2.The appli ...
Most of the themes including theme17 does not appear properly whenyou Interactive Report is horizontally long (say 30 columns or more).The Page's tab bar, breadcrumb bar, region title bar, etc. gets truncated, I guess after 1920px length (browser screen) based on thebody CSS max-width attribute.Even ...
for my apex application i configured the theme Blue Gray - 13. I want that my application displays all region-, report headers on every page in a different color, for example "magenta".My CSS Code in the page header on page1: <style type="text/css"> .t13RegionHeader {background-color ...
This appears counterintuitive-- Intuitively it would seem that the HTML generated by a subregion, including its header and footer should be properly contained (nested) in the parent region's generated HTML, the boundaries of which are the Header and Footer HTML given.I want this to be true because o ...
I am passing the region headers from one page to another rather than using static header names. for example:- Clicking EDIT against a particular DEPT on DEPT page passes something like "Employees in Department:10" to my EMP page, but on EMP page I just get "Employees in Department" and there is noth ...
In the new version of APEX, when you modify a report region, we have Tabs to navigate between set of data.This is a very interesting layout presentation and I would like to know if it is possible for me to use this kind of layout in my APEX application?Any tips? ...
I have a page on apex which includes 3 chart region.Only one region can take parameter from select list and after run button clicked,whole page is resubmitted.I need to refresh only relevant chart region not the whole page,because other two region does not need to be refreshed. ...
I've searched around for a while but was unable to find an answer to my query.I have a simple report region, which i added a "Print" link to the bottom of - this brings up a formatted PDF version of the report which can be printed out, i'm just using the default PDF layout.When it comes to adding a ...
From sqlworkshop,I have created a view likeCREATE OR REPLACE FORCE VIEW VW_SUB_CL_ADD1 AS (select a.siteid siteid,a.bpaadd_0 bpaadd_0,a.bpanum_0 bpanum_0, case when a.bpaaddlig_0 = '' then '-' else a.bpaaddlig_0 end address1, case when a.bpaaddlig_1 = '' then '-' else a.bpaaddlig_1 end address2, cas ...
From sqlworkshop,I have created a view likeCREATE OR REPLACE FORCE VIEW VW_SUB_CL_ADD1 AS (select a.siteid siteid,a.bpaadd_0 bpaadd_0,a.bpanum_0 bpanum_0, case when a.bpaaddlig_0 = '' then '-' else a.bpaaddlig_0 end address1, case when a.bpaaddlig_1 = '' then '-' else a.bpaaddlig_1 end address2, cas ...
I am trying to make a Cascading Select List in Tabular Form. but getting error while compiling the region source:Error : Query cannot be parsed, please check the syntax of your query. (ORA-00907: missing right parenthesis) Can some one take a look at my region source : <Code here>{SELECT apex_ ...
This is an example of Apex SQL Report in a Region with Slide Effect - made with javascript: http://tryapexnow.com/apex/f?p=12090:10Waiting for comments here.Edited by: Valentin Tabacaru on Apr 30, 2010 5:39 PM ...
I have a report region, that always displays only one row. I'd like to display a few of the columns values just above the report.For example:If my report looks like that: First Name | Last Name | Favorite Color John | Smith | Red I'd like to see just above the table: "John - Red"How do I do that? ...
Folks,I am trying to do something I had thought I had done many moons ago. I have a page, with a report region. I want to add the date/time to the report region title. I had thought I built a page variable with the page name and then some html formatting to right align the date/time into one string. ...
I've a dynamic report in my app. created using function returning query. The number of columns in the report changes based on the selected value from a select list. Like : If I select Emp, it gives information about Emp (Empno, Ename,Sal etc). If I select Dept, it gives information about Dept(Deptno ...
I have a requirement like this. I want to refresh only certain region in the Page and not the full page.Detailed Requirement: I have 2 region in Parent window.I am entering a value in parent window in the First region. so the child window gets Populated.I am entering some values in child window. so ...
i have many IRs in my application and most of them are having too many columns to be displayed in one screen, 15-25 in most cases. Unfortunately, i haven't find a way/option to implement an overflow region for one record. Has anyone achieved something like this, avoiding records to look like a train ...
Hello, I am developing a SQL report based on SELECT query that uses a plsql function.However the PLSQL Function returns a numeric value and , in addition to that, it also has one out parameter.How do I display this out paramete's value on APEX report? ...
After I customized IR theme with my own css, the menus drop down at the wrong place in IE. However this works fine in Firefox.Can anyone help please? ...
I have 2 DB tables one for "QUESTIONS", the 2nd one is "ANSWERS"..i need to create a form which will show all the listed questions available in "QUESTIONS" table but with Radio Buttons beside each question for answers...the field for answers is exist in "ANSWERS" table..Does any1 have any idea how t ...
I want to create a repeatable HTML Header (not an ApEx region Header) for a HTML region as described inhttp://www.html4newbies.com/header_footer_tip.phpI want to include the header at different points in my HTML regionIt says that you need to save the Header in an external file and then reference it ...
I'm trying to reuse a region on apex, but i don't know how to do it.What i'm trying to do is to use the very same region (a sql region) on different pages.Could any one gave some clues? ...
Does anyone know how to change the width of a region in Apex? ...
I have a IR, when I click any column Header and it shows the list of values as a dropdown.some of them (which are larger) get cut off.. means the the entire content/value are not displayed within the dropdown. [width of dropdown is fixed and no of characters in the content/value is more..]how can we ...
In the Interactive report when we click any columns header and select any value from the list for that column.. by default Oracle APEX executes/fires the following javascript function.javascript:void(false); How can I capture this event in Dynamic Action.basically, I want to create a Dynamic Action ...
I included function f_Hide_On_Value_Item_Row from htmldb_remix.js in one of my pages and it was working just fine. I upgraded to APEX 3.0 and the function is not working. The script is in the same directory /i/javascript/, and I have other scripts in that directory that are working. Is there any rea ...
I have a problem to trigger a javascript from apex_item.popupkey_from_query. The sample app:http://apex.oracle.com/pls/otn/f?p=22968:3:1488489892666909:::::Queryselect to_char(dag,'day dd mon yyyy')||apex_ITEM.HIDDEN(1,pk) dag, apex_item.text(2, ben1) ben1, apex_item.text(3, ben2) ben2, apex_item.te ...
For some regions I've defined a horizontal scrollbar - in the Region Header I wrote:div style="" It worked fine with IE, Firefox 2.x and Apex 2.x and 3.x.But after upgrading my browser to Firefox 3.0 this scollbar had disappeared ! Not only in Firefox, but in IE too - this seems very strange to me.I ...
Could using a materialized view in the sql select of an Interactive report cause the downloading to a CSV file to ignore the IR filters? I have Interactive Reports where IR filters are ignored when downloading a CSV file. The report region displays correctly (IR filters work ok),I have Interactive R ...
hi, i am trying to use &TITLE. in a region header as was expecting to see the title of the region shown ? it does not (apex 3.2)however the template for the region has this and it works fine..can someone help ? ...
I have a report page with the following query:SELECT (CASE WHEN SIS_express.field_change_allowed2(:APP_USER,:P0_LOGIN_SCHOOL_YEAR,:P0_LOGIN_SCHOOL,:APP_ID,:APP_PAGE_ID, '#OWNER#','STU_MED_VISIT_REASON','FK_MED_REASON_CODE') = 'Y' THEN APEX_ITEM.POPUPKEY_FROM_LOV(1,NULL,'MED_VISIT_REASON',NULL,NULL,N ...
I recently upgraded an older 2.0 app to Apex 3.1. In the app, I have a few textarea with html editor fields so the user can customize page instructions. In 2.0, I was able to query the database and store the text in a hidden item, then reference the value of that item in an html region for the text ...
I have been trying to implement ExtJS into Apex also but i am getting an error which i couldnt find a way to sort it out.... Can somebody help me? Here is the error message i got;The container of an boundary-point of a range is being set to either a node of an invalid type or a node with an ancestor ...
After two days of searching these forums and AskTom, I think I need to post the following problem.I have what seems to be a valid view of some data created as follows (with an apology for the formatting - doesn't seem to be a way of using a fixed font here):CREATE OR REPLACE FORCE VIEW "PRICING_CAPA ...
In APEX, we needed to generate PDF-reports using fonts with unicode glyphs, which are not supported by FOP which is shipped with APEX, so I decided to configure our environment to use FOP 1.0. I've managed to get custom reports with APEX, however built-in XSL template (which is used to generate PDF- ...
I'm using APEX 4.0.1 with theme 13.I've created a Dynamic Action to show/hide a region on my page but although the contents hide as expected, the Region Title remains. Any idea on how to hide the Region title as well?To identify the region to the DA I'm using the following method:Region Header <d ...
Is there any way to have true scrolling of the data output of a region?Using region header footer div tags isn't really scrolling the data itself, just the first set. I still have to use the pagination options (which don't include scrolling).I'm using 1.5 still - is this all solved with 1.6 ? ...
HiOn my site root in index.php I want to redirect to a subdomain with:if ($_COOKIE["region"]) {// redirect to regionheader ("location: http://www." . $_COOKIE["region"] . ".argyllnewmedia.co.uk");exit;}I have subdomains set up in Cpanel which redirect for exam ...