Application Express :: How To Use The Result Of A Sum In A Classic Report

Sep 20, 2013

I've created a classic report that sums a couple of columns in two different regions:(Why can't I insert an image?)This is a simple example:

Region1col1     col2     col3     col4     col5    a          b          20          5          25%c          d          40          4          10%e          f          120         6            5%report total:     180          15          x Region 2col1     col2     col3     col4     col5    g          h          30          6        20%i          j            70         14       20%report total:     100        20          yMy

How do I access the values generated by APEX (in bold) so that I can use them in further calculations? e.g. create a grand total from both regions

2) Having calculated a value, assuming 1 above is possible, how do I insert it at position x or y? e.g I want to calculate a % so that x would be 8.33% and y 20%

3) How do I change the words report total

View 2 Replies


ADVERTISEMENT

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 :: 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 :: Checkbox In Classic Report

Jul 16, 2012

I have question about checkbox in classic report. I need to choose only one checkbox in every row, hot to ensure that only one checkbox can be checked at same time?

Checkboxes are defined in SQL query as:

apex_item.checkbox(1,msisdn,'UNCHECKED') as clear,
apex_item.checkbox(2,msisdn,'UNCHECKED') as to_analysis,
apex_item.checkbox(3,msisdn,'UNCHECKED') as to_barring

here is the picture:

[URL]........

View 9 Replies View Related

Application Express :: Conditional HTML Expression In A Classic Report

Sep 6, 2013

Apex 4.2I currently have a report column in a classic report that has a Column Formatting Attribute as below. This works fine it shows a map icon that when you click on it goes off to google maps and put 2 geo points on a map. However I need to change this report column so that the HTML expression will be different dependent on the value returned so if the column returns 1 then the HTML Expression will be slightly different. 

HTML EXPRESSION <span class="map_#BROKE_GEO#_#VALID_GEO_CODES#"><a target=_blank href="f?p=&APP_ID.:323:&SESSION.::::P323_PARCEL_ID,P323_SCAN_ID,P323_PROP_ADDR1,P323_PROP_POSTCODE,P323_PROP_LAT,P323_PROP_LONG,P323_SCAN_LAT,P323_SCAN_LONG:&P341_PARCEL_ID.,#SCAN_ID#,#LINE_1#,#POST_CODE#,#PROPERTY_GEO_LAT#,#PROPERTY_GEO_LONG#,#SCAN_GEO_LAT#,#SCAN_GEO_LONG#"><img src="#WORKSPACE_IMAGES#&P341_IMG_MAP_#BROKE_GEO#." alt="Google Maps" title="Google Maps"></a></span>  

I think I can do this in the report source directly with a case statement and include the HTML in that for the column but how do you handle all the quotes within the SQL statement. e.g.

Original Query SELECT     parcel_id    ,status    ,LOCATION    ,scan_date    ,scan_id    ,driver_comments    ,card_id    ,valid_geo_codes -- this is my html column    ,property_geo_lat    ,property_geo_long    ,scan_geo_lat    ,scan_geo_long    ,broke_geo    ,line_1    ,post_code    FROM vw_parcel_history_details  WHERE parcel_id = :p341_parcel_id  ORDER BY scan_date  New Query SELECT     parcel_id    ,status    ,LOCATION 
[code].....

various iterations of that large html string but I do not know how to format it because off all the quotes?

View 3 Replies View Related

Application Express :: How To Highlight Entire Classic Report Column To Red

Sep 20, 2012

We have a requirement, to highlight an entire column of a classic report based on a query to red. So if the search of the report returns column1, column2 as the output. Column 2 (text) should be highlighted in red across all results rows.

In some forum responses, I see using some id format, one can try to highlight a single column in a row. Not sure how can this be done across the whole column of multiple rows.

View 9 Replies View Related

Application Express :: How To Get Checkbox Value When List Value Changed In Classic Report

Dec 26, 2012

I worked with apex 4.2 and i create normal classic report with one checkbox column and one column change it to select list(named loved) now i want when user change list take value of checkbox item and show it in message .

SQL for report

{
SELECT
'<INPUT TYPE="checkbox" NAME="f01" VALUE="'
||SEQ
||'">' SEQ,
ID,
DEPT_NO,
EMP_NAME}

i change the column attributes of Dept_NO to Display as Select list of department name (named lov). Now i want when user change name of department the value of SEQ SHOW IN ALERT MESSAGE

i create JavaScript on the page

function test(pThis) {
var f01_value = $('select[name="f01"]').value;
alert('#SEQ : '+ f01_value);
}
</script>

I call this javascript function when list change but the value undefined..

My Question :

How can get this value Or any value of item in reports ?

View 6 Replies View Related

Application Express :: How To Create A Dynamic Action From Link Column In Classic Report

Feb 23, 2013

I Have an apex page that display a modal window utilizing jquery. In the modal window I have a classic report with a link column that I want to capture its click event.

I was thinking I could create a dynamic action with selection type=jquery selector. Not for sure if I need to do anything on link column and do not know the syntax jquery selector.

View 5 Replies View Related

Application Express :: Resize IFrame Generated On-the-fly Inside APEX Classic Report

Jun 25, 2012

I have a classic report generated by Oracle Apex 4.0. I have customized it to have a hyperlink on each record, which when clicked opens a detail report in an iframe right under the current record. This, I am doing by using the Javascript insertRow method on the html table element (Condensed Javascript code below)

var pTable= html_CascadeUpTill(t,'TABLE');
var myNewRow = pTable.insertRow(pTR.rowIndex+1);
var myNewCell = myNewRow.insertCell(0);
myNewCell.innerHTML = '<iframe src="detail report url" height="0"></iframe>';In order to resize the height of the iFrame that is different for different detail records, I have the following code in the "Execute when Page Loads" section of the report
[code]........           

Without the setTimeout call to iResize function, the iframe resize is not happening. But this setTimeout is adding a delay in the resized iframe to appear which I want to avoid. Is there a way to do this? All the related posts/articles I have seen online deal with iframes that are built into the page but not generated on-the-fly as in my case.

View 3 Replies View Related

Application Express :: No Data Found When Adding Column Link To Classic Report

Jul 16, 2012

Oracle 11g r2, APEX 4.1.1.00.23.

I have some classic reports.

I go to Report Attributes, then I click Add Column Link in the "Tasks" right menu, it adds me a column link, I just add some text for the link and a page to go to. Then I run the report and I get :

report error: ORA-01403: no data foundTested with several classic reports on multiple pages.

Debug mode shows me :

0.43816     0.00240     ...Execute Statement: select distinct [...] order by 3,11 ,4
0.44056     0.00162     print column headings
0.44218     0.04816     rows loop: 25 row(s)
0.49037     0.00141     report error: ORA-01403: aucune donnée trouvée
0.49175     0.00078     Computation point: After Box BodyWhen I run the query in my favorite tool, I get expected results.

Did I missed something ?

View 9 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 :: How To Pass A Cursor Result To Javascript Code

Jun 15, 2012

what document I should look for to pass a cursor generated by PL/SQL to java script code in APEX?

View 15 Replies View Related

Application Express :: Get Nested Case Statement To Evaluate One Result / Instead Of Multiple?

Mar 26, 2013

OK, Now that the syntax has been corrected with "Chanchal Wankhade" I have an entirely new issue. I am sure this issue has to do with my case statement logic. I am getting multiple rows, when I am only looking for one. Here is my code:

SELECT
  CASE
    WHEN EP.PHYSICAL_DATE IS NULL
    THEN
      CASE
        WHEN EC.ORIGINAL_CONTRACT_START < ((SYSDATE) - 365)
        THEN 'NEEDS PHYSICAL'
 [code].....     

However, only one of these rows should be the output, which is "No". How do you get a nested case statement to evaluate to one result, instead of multiple? I'm quite sure it is in the logic. To spell it out, this is what I am trying to accomplish with the above code: If the "EP.PHYSICAL_DATE" is null, then use these sets of formula's to evaluate the output, BUT if the "EP.PHYSICAL_DATE" is not null, then use these set's of formula's to evaluate the output.

As it stands now, it appears as if my nested case statement is doing exactly what I told it to do, which is to evaluate both conditions, and output both.

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

Application Express :: Script Output Reached Maximum Workspace Result Size Limit

Oct 18, 2013

I have created a workspace to use oracle apex, after a while I tried to run a script, the following message has been displayed to me,  The script output reached the maximum workspace result size limit. Delete existing results or contact your administrator to increase the maximum workspace result size.

View 3 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 :: 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 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







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