Application Express :: Message Box With Report?

Nov 1, 2012

I created a report and in this report there is a likeable colummn and when its been cliked I need its show a message box containing a text that cames from field on a tables in my database.

View 1 Replies


ADVERTISEMENT

Application Express :: Display Custom Message For Report When Record Count Returned

Nov 8, 2012

Our application has a homepage that displays results of several SQL statements that are defined as reports. One report in particular should only display a custom message when Count of Invoices having a particular status > 0, and not the actual invoice count itself.

I have gotten the layout to not display the count but I need to be able to display a custom message that says "Problem Invoices exist. Please see Invoices Report for more information." I've looked over the Report Attributes definition page but I cannot find how to display this custom message.

View 2 Replies View Related

Application Express :: Showing A Message From A Button?

May 22, 2013

I have a button with an dynamic action , with sql:

declare
errors varchar2(100);
begin
apex_application.g_print_success_message := 'test message';
errors:=package.function_some_process_returning_varchar100_with_errors_or_sucess;
HTP.p ('<script language="JavaScript"> alert('''||errors||'''); </script>');
end;

The first "test message" is not shown.and after the function (it is executed fine) i get the next error:

Error:Parsererror - SysntaxError: Unexpected token <

i i only leve the first line (g_print_sucess) nothing occurs clicking the button.

I only want to show on a popup the result from the function, but g_print_sucess seems not to work for some reason.

View 1 Replies View Related

Application Express :: How To Make Error Message Red

May 20, 2013

A page has a display-only text item that is populated when a rare exceptional condition arises. I'd like for the text to be colored red. While editing the item, in the Element region,

I populated the item "HTML Form Element Attributes" by selecting 'style="font-color:red"' from the drop-down list. When the text displays, however, the color is still the default black. What do I need to do to turn the text red?

View 2 Replies View Related

Application Express :: Message Display Before Submit To Record

Nov 5, 2012

I have created two page process with two buttons "APPROVE" AND "CANCEL" button. first page process running approve invoice procedure on approve button and second page process running cancel invoice procedure on cancel button. i want to display massage before approve invoice and cancel invoice (DO you want to approve invoice) on approve button and (Do you want to cancel invoice on ) cancel button.

Working with apex4.1.

View 4 Replies View Related

Application Express :: Delete Message Not Displaying When Upgrade To 4.1

Jul 31, 2012

I am in the middle of upgrading my application to Apex 4.1 from 3.2.1. I have been using the default delete message and now it won't work.

<script langues="javascript" type ="text/javascript"
<!--
htmldb_delete_message='"DELETE_CONFRIM_MSG"';
//-->
</script>
button action

redirect to url ----> javascript:confirmDelete(htmldb_delete_message,'DELETE_RATING');

now all I receive is a message from the webpage, instead of the message.

View 4 Replies View Related

Application Express :: 4.1.1 - Tabular Form Updated Row Message

Oct 31, 2012

In my Application I have a tabular form and they other I edited 1 row & 1 entry and clicked on the update button. The message on the top says:

16 rows updated, 0 rows inserted (the standard message).

I do not have any page processes before or after applyMRU and its one of those freaky one-off issue that I can't reproduce again. Update 1 row and shows 15 updates.

Here are some info regarding my tabular form:

8 columns, pagination enabled for 20+ rows, no insert or delete functionailty, just updates.

View 0 Replies View Related

Application Express :: How To Show Alert Message In Home Page

Jun 11, 2012

I have leave application form based on the LEAVE table, it has the following columns,

leave_id(primary key)
emp_name
from_date
to_date
no_of_days

Statuswhen they entered the details and submitted the form the data will be stored in LEAVE table. later on the applied leave will be approved or rejected and the STATUS column will be updated. Is this possible to show the last leave applied status as a alert message when they are logging in ?

View 5 Replies View Related

Application Express :: Display Success Message Without Reloading Page

Feb 22, 2013

I have the following problem.

By clicking on a button on my page, I execute a Dynamic Action. That Dynamic Action consists of several True Actions, one of which is Execute PL/SQL code where I execute a procedure. I'm doing this without submitting the page, and that works fine.

However, I would like to display an error message on the top of the page, in case my procedure returns an error, and I would like to do that without submitting the page.

Is this possible?

View 6 Replies View Related

Application Express :: Saving Private Interactive Report Overwrites The Primary Report

Dec 10, 2012

Having this issue in Apex 4.1.1 and 4.2 (haven't tried it in versions prior to 4.1.1 yet). So I got my standard IR, and trying to create a private report with control breaks, aggregations.

Once I save it as a private report, It applies the same on my primary report.

It's no big issue as I can flip back to Primary report and delete the control breaks, aggregations but is some kind of bug? Ideally it shouldn't modify my primary report unless I try to save it as "Default Report Setting".

View 1 Replies View Related

Application Express :: Create Items Context Help Editable Report Or Report And Form App

May 9, 2013

How do I create Items context help editable report or report & form app?

what is its table?

View 2 Replies View Related

Application Express :: Re-execute Single SQL Report On Multi-Report Page

Oct 25, 2013

I have a Page containing 3 reports and I was wondering if it is possible to re-execute only one of the these reports using a button or preferably a Select List which allows me to choose which of the 3 reports I wish to 'refresh/re-execute'. I may be totally wrong here but I assumed that choosing the option to submit a Page will cause all regions to refresh i.e. re-execute the SQL queries they are 'based on'.

View 6 Replies View Related

Application Express :: Report Not Initially Sorted As Defined By Report Attributes Sort Sequence

Nov 1, 2012

I have a Report Region with Type SQL Query and Source "SELECT * FROM <table>" where <table> has a primary key from a sequence. Under Report Attributes, I have Report Column "ST_NM" with Show and Sort checked and having a Sort Sequence of "1". I assume this is to set the iniital display sequence but regardless, the report rows display in Primary key order initially.

To try it: [URL]

1) How do I set the initial display sequence to be other than the primary key sequence?

View 4 Replies View Related

Application Express :: Test Report Button On Report Queries?

Jul 20, 2012

What is the code/javascript/url behind the test report button on report queries component?

We are having DSN problems using the print url given on the report query. The URL works for some of our developers and not for others.

The test report button on the report query appears to work for everyone but I do not know what is behind the "Test Report" button. If I could recreate the test report button on our page this would be GREAT!

View 0 Replies View Related

Application Express :: Interactive Report Functionality For Classic Report?

Jun 27, 2012

I have to implement IR report search functionality (*when ever we click on column header it will display all the values in that particular column , once we click on particular value , the report will filter based on that particular value * ) in classic report .

View 8 Replies View Related

Application Express :: Classic Report - Logo In PDF Report

Apr 12, 2013

I have created a classic report in Apex. Have enabled the print PDF link on the report for the business users to download it in a PDF format. Is is possible to put a logo in a downloaded PDF from the report?

View 0 Replies View Related

Application Express :: Set Value From Report

Nov 8, 2012

I have tow report master - detail

select
"ID",
"NAME"
from #OWNER#.COUNTRYSELECT c.id
, c.country_id
, c.name
FROM city c
WHERE c.country_id = :P2_country_id
ORDER BY c.ID DESCP2_country_id it's a hidden item

i create dynamic action event click ,

type item (P2_country_id) ,
condition equal to country_id
true action refresh region (city report)

i want when click on row in country report , set values that related with city , how can i do that ?

View 2 Replies View Related

Application Express :: Editing A Row In Report

Jun 17, 2012

I have a problem when I want to edit a row in a report. I have created a form with report, and now when I click on the edit icon on the report page, it navigates me to the form page but without the row data .

View 6 Replies View Related

Application Express :: Report ID For Different Applications

Jul 12, 2013

I have a javascript code, which refreshes a report on a page.The problem is, that the report ID is hard coded. If I import this page to a different application, the report won't be refreshed anymore.

Following code is used:

[...]var v_get = new htmldb_Get(null, $v('pFlowId'),   'APPLICATION_PROCESS=AP_RECALC', 0);v_get.addParam('x01', Segment);v_Return = v_get.get(); $a_report('734879922768742332', '1', '5000', '5000');[...] 

Is there a possibility to change the '734879922768742332' to a variable, constant or static id (which does not cause a endless loop)

View 2 Replies View Related

Application Express :: Copy One Row To Another In Report

Jun 6, 2013

I am using APEX 4.2, DB 11.2

I have a Classic Report with Link item and Copy item and the other columns from the table. Copy item should appear in each record like the edit item link. When copy item is clicked the current row should be copied and a new duplicate row should be visible in the report.

The PL/SQL process written for this Copy item works fine (when executed alone).... but when Copy item is clicked, the PL/SQL process is not getting triggered.
PL/SQL process in not conditional.

View 2 Replies View Related

Application Express :: How To Add Row Number To IR Report

Oct 19, 2013

I would like to display a leading row number to my IR.  I cannot use rownum as I would like to allow users to sort queries.

Use something like:SELECT '#ROWNUM#' However I am not getting a number displaed only: #ROWNUM#

View 2 Replies View Related

Application Express :: Updateable Interactive Report

Sep 27, 2012

Apex 3.2

confirm whether I am right about this.

We have an interactive report (working report), which is updateable.

The user has created his own version of the report, with less columns.

Now when he changes a value it does not save.

Am I right to say that if one of the columns he has removed from the report is a required parameter for the update code, then the report will not save.

View 10 Replies View Related

Application Express :: IR Report Value From Function Error

Apr 11, 2013

i have ir report and one column value coming from function,when open the IR report its giving error..

IR report code
SELECT CS_ID ,CS_NAME, Util_func(PASS_ID) as "ALERT_DAYS"   from "CSD_MASTERS" Function code
FUNCTION  Util_func(PASS_ID NUMBER) RETURN number
IS
ALERT_DAYS NUMBER:=0;
BEGIN
[code]........  

View 8 Replies View Related

Application Express :: Source Of Interactive Report

Jul 31, 2012

I have an error why trying to update the source of my interactive report the error is : 1 error has occurred

The report query needs a unique key to identify each row. The supplied key cannot be used for this query. Please edit the report attributes to define a unique key column. ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc.

The SQL query is :

select l.code_lignebip, m.identifiant_mission, m.libelle_mission, SUM(b.nbr_jours),
SUM(c.nbr_jours_consome), c.nbr_jours_realise, c.nbr_jours_raf, c.nbr_jours_reestime, c.lundi, c.mardi, c.mercredi, c.jeudi, c.vendredi
FROM missions m, bip l, cra c, budgets b
[code]....

View 2 Replies View Related

Application Express :: Copy Cells In Report

Sep 27, 2012

It's possible to copy cells in report like excel sheet , like this example ? URL....

View 0 Replies View Related

Application Express :: How To Create Customize Report

May 10, 2013

I am having the table columns called

level1_name, level2_repemail, level2_name, level2_repemail, level3_name, level3_repemail,

using this columns i would like to create a report region as mentioned below.

------------------------------------------------------------------------------------------------------------------------------------------------------|
TITLE |
-----------------------------------------|---------------------------------------------------|--------------------------------------------------------|
Lvl 6 | Lvl 7 | Lvl 8 |
-------------|---------------------------|---------------------------------------------------|--------------------------------------------------------|
Name | Rep | Name Rep | Terr Name Rep |
-------------|---------------------------|-------------------|-------------------------------|--------------------------------------------------------|
AP | aaa@gmail.com | AAA | bbb@gmail.com | AAA bbb@gmail.com |
AP | aaa@gmail.com | BBB | bbb@gmail.com | BBB bbb@gmail.com |
AP | aaa@gmail.com | CCC | bbb@gmail.com | CCC bbb@gmail.com |
AP | aaa@gmail.com | DDD | bbb@gmail.com | DDD bbb@gmail.com |
-------------------------------------------------------------|-----------------------------------------------------------------------------------------|

how can i create this type of report.

I am using ORACLE 11G, and APEX 3.2 .

View 7 Replies View Related

Application Express :: Item Value In A Classic Report?

Oct 3, 2012

I have the release 4.1.1. I have this problem:

- i have a master-detail page

- in a detail there is a classic report

- some item of the row of report are the select list based on LOV

I need to get the value of item inside the select list.

View 1 Replies View Related

Application Express :: Getting Value Of Radio Group In A Report

Jan 8, 2013

i have multiple radio gropus(one group for each row) in my report. Each row can be identified either by my rownm or id. I am looping through my report rows once the page is submitted to get the values of each radio group but I am not able to make it work...

here is my code.

DECLARE
v_res number;
BEGIN
FOR i IN (SELECT q_id FROM svy_q)
LOOP
EXECUTE IMMEDIATE
[code]........

View 1 Replies View Related

Application Express :: Grab Row ID From Report Column?

Jun 3, 2013

I'm having an issue pulling an ID from a report column.

I have a report based on the query:

select Inspection_Name, Activation_Status, Activate, Deactivate, Activation_Date, Inspection_Sector_Id from Inspections

where Event_Id = :P0_Event_IdThis report is based on a select list at the top of the page. The user selects an event from the select list and the report is populated.

The query for the select list is: select event_name, event_id

from Water_EventsSimple enough so far. Each row is identified by the Inspection_Sector_Id. I want to be able to turn each row under the 'Activate' and the 'Deactivate' columns into links. I have accomplished this by turning this field into a link. The link needs to navigate to a page that has that rows Inspection_Sector_Id, but am not sure how to grab that Id. I am navigating via URL on the link, i.e. f?p=application_id:page_id:session......

View 1 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







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