Application Express :: Center A Button Within Region?

Feb 28, 2013

How do I center a button within a region? I tried 'align="center"' but this seemed to be ignored. The button is at the left of the screen. Also, what are the 'display points' (Page Template Region Position 1-8) used for, and why is there a specification for column position of 1-9? Could these be attributes that will allow my button to be centered on the window instead of on the left?



ADVERTISEMENT

Application Express :: Region Button To Go To Back To Top Of Page

Oct 24, 2013

In Application Builder, when editing an item's properties there is a handy 'Up' arrow at the top right of each region which takes you back to the top of the page. Is there any way of adding something similar to an actual page region as this would be useful when creating particularly large pages (I know, we should design smaller pages but that's not always possible).

View 11 Replies View Related

Application Express :: Add Button On Report Region Named As Send Email

Dec 28, 2012

I want to add button on report region Named as "Send E-mail" that should be on each row

so how can i do?

View 8 Replies View Related

Application Express :: Pivot XML In Region

Jul 12, 2012

I tried to follow Pivot query using XML option in APEX

I can get the data into the xml serialized state, but how do I display the actual values in a region? See my example app below. I want the two far right columns in the Pivot XML region to duplicate what is in the original version.

[URL].......

View 3 Replies View Related

Application Express :: Region Of Interactive Report

Oct 31, 2013

I've created a interactive report, and i have more items than my window behaves. So, i want to separate in two regions, and put in one region a scroll bar. How i can do this?

View 3 Replies View Related

Application Express :: Items Align In Region?

Dec 18, 2012

I have 2 regions in my application one is html form region and another is tabular form .I created 6 items in html region and created DA for the items to hide according to the value of items and then created tabular form

find below the sample link

[URL]...

user name: aneesmohamed.m@gmail.com
psswd: symphony

once i select the first item(declaration letter) it will show the second item (applicacable) perfectly,but when i select applicable as yes and discrepancy then all the items become misplaced,

View 7 Replies View Related

Application Express :: How To Decrease The Width Of A Region

Oct 10, 2013

11gxe , apex 4.0 , firefox 24 ,i want to decrease width of a specific region , how ?

View 3 Replies View Related

Application Express :: Display PDF In Apex Region?

Jul 11, 2012

I have a requirement to view the PDF content in the apex page region, I am using Apex 3.2 and Oracle 10 Enterprise edition. I Uploaded the PDF file in the shared component under static file. Now i need to view the content of the PDF file. method to view the PDF content.

I saw the link in denes blog here he shows how the PDF is getting displayed. but there is no steps of methods mentioned

[URL]...

View 20 Replies View Related

Application Express :: Calling A Page In A Different Region?

Sep 5, 2012

I am using Apex 4.0 with oracle 11g.I have a requirement where I need to call a page in a region in different page.

For example. I have 2 pages page1 and page2

I need to call the page1 in page2 region.

View 2 Replies View Related

Application Express :: Display Row Number In Report Region

Feb 6, 2013

I would like to display the row number in the report region at the beginning of each row for each page (based on the number of rows to display per page).

So if the number of rows per page is 15, I would want to show each row from 1 to 15. When going to the next page (16 - 31) I would like to show row 1 to 15 again next to each row. And if the number of rows per page is 20, I want to see row numbers 1 to 20 on each page.

Since I believe an Update button only processes the current page, I would like to then use this row numbers (1 - 15) to get the values of the displayed column for each row to perform an insert to another table.

View 1 Replies View Related

Application Express :: 4.2 - Where Is Flash Chart Region Source

Sep 4, 2012

I just noticed on apex.oracle.com (4.2) that I couldn't find the region source for flash charts. I expected to find it under the Region Definition tab.

Has this moved or will it be included in a later release?

View 12 Replies View Related

Application Express :: How To Create Different Bodies In Single Region

Jul 12, 2012

How to create more than 1 body in a single region. E.g i created report region and under body tag in region all other charts reports are created.

i dont want that .. i want to create different bodies in a single region.

View 2 Replies View Related

Application Express :: No Navigation Region On Home Page?

Sep 21, 2012

I've created a new appliacation which has a home page and I've created a report page which updates a table. I want to add a link to my homepage, as a text line for example UpdateTable, and when I click the link, it goes to my report page. I've had a look in my Apex CookBook, and it says I do this by using the Navigation region in my home page. The problem is I don't seem to have a navigation region in my home page. I thought initially it meant the navigation bar, but I now realise this is the header bar. Do you know how I can create a navigation region in my home page..?

View 2 Replies View Related

Application Express :: Changing Icon In List Region?

Nov 23, 2012

I am new to apex , procedure to change the icon in List Region....... see the below link

[List Region Image[URL]....

View 0 Replies View Related

Application Express :: Partial Page Refresh PL/SQL Region

Aug 13, 2013

I have an APEX page with a master and a detail. The master is a classic report with a column link which sets an hidden item on my

page:javascript:$s('P280_DAK_ID','#DAK_ID#'); 

I have a dynamic action which reacts on change of the item P280_DAK_ID.It then refreshes the detail region which is a PL/SQL region with the following:

begin apex_p280.show_xml(p_dak_id => v('P280_DAK_ID'));end;

This prints a few pieces of text to the screen, nothing special. Everything works except the refresh of the detail region.This is due to the fact that the new value of P280_DAK_ID is not in the session state yet. So my question is: what would be a nice solution to set the item in the session state without a submit? With a normal region I could fill in 'Page items to submit', but with a pl/sql region I can't. 

View 1 Replies View Related

Application Express :: Edit Region Display Selector

Dec 7, 2012

Is possible to remove the "show all" of the Region Display Selector? How can i do this?

View 8 Replies View Related

Application Express :: Scrollable Content Region - Template?

Jul 31, 2013

I have just implemented a "Data Load" function which is the OOTB page type in apex 4.2 which allows the end user to go through a wizard and import csv data into a table.

 When the user is viewing the data to be imported - they have to scroll across the length of the screen (depending on how many columns you are loading). I noticed there is a Region template called "Scrollable Content Region". I tried applying this template to my region, and when this didn't work, to a container region. 

The scrollbars appear (horizontally and vertically) but they are greyed out as the region is still at max width and you have to use the browser to scroll instead.I think this looks untidy as the header colour-styling ends, as well as other regions being stretched.

View 3 Replies View Related

Application Express :: 4.2 New Database Sessions Per Report Region?

Nov 22, 2012

Does version 4.2 create a new db session for each report run on a page?

The reason I ask is we have a page with 4 report regions, each querying a global temporary table that is populated in a 'Before Regions' page process. The first report displays the correct data, but the others return 'No Data Found' and it is because the Global Temporary Table has been cleared out following the first report. This did not happen in 4.1.

I know we should be using Apex Collections, and we will in future, but time is at a premium to get this live

View 3 Replies View Related

Application Express :: Move Interactive Search Bar To Another Region

Dec 4, 2012

I have an interactive report which needs a horizontal scroll bar as it holds too much information for the screen, the problem is when a user scrolls the search bar is lost

i wanted to know if this could be changed by moving the interactive search (the whole action bar) to another form which would sit above the report.

View 2 Replies View Related

Application Express :: Cell Padding In SQL Report Region

Aug 23, 2013

I have what I hope is a simple question. I have a SQL Report region and I want to add more padding to the left and right sides of the table cell.  I don't want to change the style sheet because I don't want to affect other pages.  But I tried adding style attributes on the "Region HTML table cell attributes" field but I still can't get it to work. give me an example of how I can do this?

View 9 Replies View Related

Application Express :: How To Populate Date Picker Value In Calendar Region

Jul 2, 2012

I have a calendar region based on a simple query from a table which has date and name columns. The calendar type is monthly with 3 buttons - previous, today & next. It works perfectly.

I have added a date picker in a calendar region now. If i choose any date, the calendar month should be refreshed accordingly. Ie... by default it would show July 2012 month. When i choose the month as March 2012 in the date picker, it should show March month data.

View 0 Replies View Related

Application Express :: HTML Text In Reports Sub-region Not Displaying

Nov 30, 2012

I have a number of reports subregions in a page . Each of reports sub-region has a HTML text and a cell (report with a single column ) having a count sql . Now , the problem is that the HTML text in some below sub-regions are not getting displayed .. Is there a limit on the no. of sub regions???? Can there be any alternative way to display all the HTML text and the corresponding count sql in a page .

View 1 Replies View Related

Application Express :: Report Columns Duplicated When Region Is Copied

May 15, 2013

Re: Report Columns duplicated when region is copied.

When I copy a region which I have created via master-detail form, the report columns are duplicated. I'm actually copying the whole page but I have had other cases where I just copying the desired region and the columns were duplicated there as well. And, of course, there is no way that I know to delete columns from the form. But I doubt because -- in at least some cases I've tried -- the columns seems to be "linked" in that a change to one copy of the column was duplicated in the other when changes were applied.

In the example (below), there are three regions on the page and the problem occurs in region 2. (I think I will likely delete the first region.) It's been agonizing trying to get the report of region 2 and the tabular formish edits of region 3 on the same page. I made this in Oracle 11.2 in our APEX 4.1 and imported it to 4.2. You can see it here:

WS apex_examples_01
demo
demo
Appl. 991204

Page 57 is the original page created in 4.1 and imported
Page 58 is the page copied from 57 under 4.1 and imported
Page 59 is the page copied from 57 under 4.2 (Same result as in 4.1.)

If you want to try the page, select DSD01 from the DSD LOV, click "Query Process" and then click the edit icon. Ignore the region 1 errors -- I'll probably delete this region. The data is region 3 is for Run Date 12-May-13.

Is there some setting that allows this region to be copied without duplicating columns?

P.S. I think I know why it happens: APEX hates me!

View 3 Replies View Related

Application Express :: How To Display 4.2 Chart Region Title Dynamically

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

Application Express :: Possible To Detect Status Of Hide / Show Region

Nov 11, 2012

Is it possible to detect the status of Hide / Show Region.

I have three hide/show regions RX,RY,RZ. When an event EX happens, then region RX should expand and the rest of the region should collapse. When an event EY happens, then region RY should expand and the rest of the region should collapse.
........
...
We can use this JS on DA to change the status of a region:

$("RX.uRegionControl").click();
$("RY.uRegionControl").click();

.....But, first we need to detect the status to know where to apply that DA. ? I am working on apex 4.2. theme 25.

View 2 Replies View Related

Application Express :: Hide And Show Region In A Page With Some Validations

Aug 4, 2012

I am using Apex 4.1 and theme 24. I have a hide and show region in a page with some validations. On any validation error the region refreshes and closes. I don't want the region to close on refresh except Submit.

View 2 Replies View Related

Application Express :: Resizing Region Height When Window Is Resized

Jul 25, 2013

I have a tree region, surrounded by <div>, the height of which is set on page load by a dynamic action so that it is 200px smaller than the window.innerHeight. I have set overflow:auto in the style so that the full free can still be viewed. I now want a dynamic action which fires when the window is resized, which automatically adjusts the size of the region accordingly, so that the region always remains 200px smaller than the innerHeight of the window. I can get the dynamic action to fire by setting the event to resize, however it does not change the size of the region.

View 1 Replies View Related

Application Express :: 4.2 Early Adapter 2 Numeric Region Template Name?

Jul 30, 2012

In 4.2 early adapter 2 there is a packaged application called Incident Tracking. In this application page number 50 is having a region called Tickets. It has a template which is numeric.

I could not find the template under the application theme. Even if I try to create a page with the same page template but when I try to create a region in the region template LOV the numeric template is not displayed.

View 4 Replies View Related

Application Express :: Creating A Mobile Listview Region Results In Error

Feb 24, 2013

i'm on apex.oracle.com creating a mobile application. When creating a new region of type report -> Listview it results in an error if the query is too big (or returns too many columns).The error is: Error during rendering of region "Add Javascript code for Plugins". ORA-06502: PL/SQL: numeric or value error: character string buffer too small

The query i used: SELECT * FROM APEX_APPLICATION_PAGE_ITEMS

get Syntax Highlighting for the Application Builder: URL....

View 1 Replies View Related

Application Express :: Create A Global Region In Page 0 And Then Access It From Other Pages?

Apr 26, 2013

I have a number of pages containing charts and gantts. I want the user to be able to filter the data shown in these various charts. More than that, I want the user's filters to persist between pages. So, if they select "Key project = 'Y'" on the gantt page, the gantt will filter - and if they then navigate to a report (bar chart) page, that will also be filtered for Key projects only.

To make this happen, I plan to have an identical sidebar on all these pages. This will contain maybe 8 dropdowns and tickboxes allowing the user to create or remove these filters. Eventually some users might save preferences for certain choices within these dropdowns.

Since the sidebar will almost always be identical from page to page, the smartest approach would seem to be to create one sidebar (as html region) and access that sidebar from all pages rather than copying the code from page to page. Then I thought I'd create application-level items in order to create global variables for each of the dropdowns.

My question is: is this approach possible? And can I create a "global" region in Page 0 and then access it from other pages? (This is how I thought it would work but I have tried and can't see how to do it.)

View 7 Replies View Related

Application Express :: How To Pass Parameter / Create New Region / Set Display Point

May 3, 2013

On package application "Customer Tracking", there is good example about Modal Page. Quite simple but it work quite nicely.The step to create this Modal Page:

- Create new region, set display point: After Header and use region template: Modal Region and set the Static ID (eg. ActivityModal)
- Create the page item and put it on the above region (eyample: Name, Company etc.)
- Create a button, set the action to "Redirect to URL" and enter the URL target to: javascript:openModal('ActivityModal');

Now when you click on the button, the modal page will be display.How can I pass a parameter to the modal page, example: I want to pass text 'Johnny' to the Name page item which is on the modal region.

View 2 Replies View Related

Application Express :: Show Region After Running Dynamic Action Plsql?

May 1, 2013

i have a hidden region at the page top i want to show only after clicking my button which is running DA plsql code. This region is like a prompt message container/div at the top of the page so after few seconds like 10 secs i want to hide it again. I tried to use JQUERY but never hide it back, also i tried another TRUE CONDITION within my dynamic action but it doesnt reset it back the region is always shown...

View 2 Replies View Related

Application Express :: Possible To Display Null Item Value As All In Blank HTML Region

Jul 2, 2012

Apex 4.1
Theme 21

I have select list which has null and other values. I have created a blank HTML region with the following text

Report for the year &P2_YEAR. and for geography &P2_GEOG.

Now P2_YEAR works fine because, it is always populated with a year. However, &P2_GEOG has 'All' as null value since we can see the report for all geographies. However, if the all option is selected, the above &P2_GEOG. shows as null. Since its not a PL/SQL proc, I cannot put in a NVL. I am guessing one possible way is to write a PL/SQL code before region and then check if its null and then try to populate a new hidden field and show, something like that. Wondering if there is a way to do it directly in the HTML region?

View 0 Replies View Related

Application Express :: Set Hidden Or Expanded Mode Of (Hide And Show Region) In 4.2

Sep 12, 2013

I just created a "Hide and Show Region" from a template in APEX4.2, and would like to control the behaviour of this region, i.e. 

1. At the page load, this region should be in "Hidden" mode
2. Once the user Opens the region, it should stay as "Expanded" mode ( even the page gets submitted), until the user chooses the "Hidden" mode again. 

So I tried the following

1. Chose the Hide and Show Region(expanded) template for the APEX region
2. uses Dynamic action to force the "Hidden" mode by setting Style as style="display: none;"  at the page load event. 

But it still shows the region in  "Expanded" mode after the page gets loaded.

View 0 Replies View Related

Application Express :: Turned Out By Disabling Javascript Whole Login Region Disappeared

Nov 8, 2012

Application Express 4.1.1.00.23
Internet Explorer - 8
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

I am about to embark on my first APEX development and have got far as the login screen. I disabled JavaScript just to see what would happen if someone had it disable, it turned out by disabling javascript the whole login region dissapeared. I am wondering how to develop the application so it works when javascript is disabled. I am using the cloudy theme. Not sure how to develop the application as its got to work with JavaScript disabled.

View 11 Replies View Related

Application Express :: How To Present A Report From BI Publisher To Inside HTML Region

Feb 12, 2013

how to present a report from BI publisher to inside a HTML region ?

View 1 Replies View Related

Application Express :: Button Placement On APEX Application Page?

Mar 6, 2013

How do I center a button within a region? I tried 'align="center"' but this seemed to be ignored. The button is at the left of the screen. Also, what are the 'display points' (Page Template Region Position 1-8) used for, and why is there a specification for column position of 1-9? Could these be attributes that will allow my button to be centered on the window instead of on the left?

View 3 Replies View Related

Application Express :: Setting Foreign Key Value In Detail Tabular Form Region On Submit

Feb 27, 2013

I have a master detail screen where the detail region is a tabular form. I want to create a new master and detail records at the same time. The master uses a get PK process on submit that gets the PK from a sequence.

Obviously I need to set this value in the FK column on the new detail records on submit also, but I just cannot see how this is done. Fine for updates etc, but this is when the master is new as well. A two stage process is not an option here.

View 0 Replies View Related

Application Express :: Image Stored In Table Is Not Showing In HTML Or Report Region

Aug 22, 2012

I am using apex 4.1 and database as oracle 11g. I uploaded images and stored in table structure as shown below

>>CREATE TABLE "HR_EMPLOYEE_DETAILS"
>> (     "ID" NUMBER,
>>     "HR_ID" NUMBER NOT NULL ENABLE,
>>     "PHOTO_BLOB" BLOB,
>>     "MIME_TYPE" VARCHAR2(64),
>>     PRIMARY KEY ("ID") ENABLE
>> )

My Requirement is to show the image in a report region as well as in a html region. I followed the methods in the URL links mentioned below.

[URL].......

[URL]........

But the image is not getting populated in the region, I tried with display_item with image i am able to view the image using this item.

View 19 Replies View Related

Application Express :: Color HTML Region Header Depending On SQL Query Result

Jul 24, 2013

How to color HTML region header depending on SQL query result ?

View 9 Replies View Related







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