Oracle APEX Interactive Report - CSV Export Limitations?

I have an interactive report generated for some users.The issue I'm having right now is that the results that the users need is over 100k and the export to csv option caps out at 65,535 rows. Is this a limitation on APEX Interactive Report's side and is there anyway to get around it so we can send 1 ...

Oracle Apex Interactive Report - How to set default # of records?

How can I set the default records of an Apex Interactive report? It's always 15. ...

Oracle APEX Interactive Report PDF Format to look same as screen

HiI have scoured the forum but cant find an answer to my problem. So I am sorry if its already been answered.I would like to know how does one go about getting the PDF/Excel/RTF document that you are able to download from an interactive report to look like the report the user has just created on scr ...

Oracle Configuring Interactive Report Download formats

APEX lets a user download an Interactive report output in 4 formatsCSV,EXCEL, WORD, PDFDoes Anyone know where and how to configure them?Our installation only shows 2 CSV and PDF ...

Oracle Apex Interactive Report question

I have a problem with an Interactive Report in Apex and, despite much searching of docs, cannot seem to resolve it.My problem is quite simple really, I have a query for the report:select firstName, lastname, lanid, f_has_team(lanid), f_has_c4s(lanid), f_cdm_link(lanid) from table(account01.LDAP.getE ...

Oracle Apex Interactive report

I have created an application in APEX using a spreadsheet. It contains column like Customer, Opp_Id, OPP_Value, REP and some other column, but it has repeating rows. eg Sc , Oppty Id , Hours , Customer , Opp Value , Rep Oppty Owner , Create Date Are the collumn names steen 3-J4T-2564 4 Society 25292 ...

Oracle APEX Interactive Report "security settings ...ActiveX"

this sounds trivial but i have been banging my head since last 12 hrs, so here i am...Problem: the interactive report chart is not getting displayed and i get a IE warning your security settings do not allow websites to use activex controls installed on your computer. This page may not display corre ...

Oracle APEX Interactive Report <Procedure/Function to create the dynamic SQL>

I want to save certain report definitions/filters and then use the inbuilt APEX views and procedures along with ORACLE utilities(UTL_FILE) to generate CSV reports. The application I am developing will make use of APEX fully, but not in the current phase. By reusing the APEX PL/SQL objects, I can avo ...

Oracle apex interactive report pagination

Can any body help me in providing the pagination in interactive reports other than those two default paginations provided by apex.I want some thing like pagination in classic reports.any help please ...

Oracle apex xls report download error

i have a report region with download link to xls format.when the report display few rows, it works normally.but when i download about 40.000 rows,the xls file become blank with note 500 Internal Server Error Servlet error: An exception occurred. The current application deployment descriptors do not ...

Oracle Interactive Report Download and Session State Protection

I have created an Interactive Report in an APEX application that I have enabledsession state protection for. The issue I am having is with the "Download"functionality of the interactive report to a .csv file.The URL created by selecting Download from the drop down (javascript:gReport.controls.downlo ...

Oracle Interactive Report Download Options

I am running APEX 3.2 on Fedora. I was going thru some of the interactive report tutorial samples available online. It seems that under the Report Attribute there are only 2 of the 4 download options available namely csv and pdf formats. From the tutorial instructions I had expected to see CSV, XLS, ...

Oracle Interactive report download activity

I am using Apex 3.1.2,I have a requirement to track the downloads (either CSV/PDF) from the built in option provided by the Interactive report.Can I run a process before download or after download?Is there a way to track the download activity from the Interactive report?Any suggestion would be helpf ...

Oracle Interactive Report Download CSV header footer from item

I want to include a header/footer to the csv file that you can download from an interactive report based on the text of an apex item? Is it possible in apex 3.2 or 4? ...

Oracle Interactive Report download

I have an interactive report which is taking a very long time to be displayed on an APEX page. Is there any way I can download this report directly to a CSV file without showing it on UI page? Please share your expertise. ...

Oracle Interactive Report download not matching displayed data

HiI have an interactive report with a simple where clause in:select * from table etcwhere a.entry_date > :P2_DATEP2_DATE is a select list with redirect, with 2 options. Selecting the first option (the default) should return ~200 rows, the second should return ~800 rows. This functionality works c ...

Oracle Interactive Report Download Warning

I am looking for a way to produce a javascript alert when the download button is clicked in an interactive report. It's defeated the best minds here, but perhaps we've missed a trick. ...

Oracle Interactive Report Download Link Question

I have an interactive report where I have outer joined to a table that contain blobs that I want the user to be able to click a link to download. I have a custom procedure that works with the download link. However I can't figure out how to get the download link to only appear for the records that a ...

Oracle Interactive Report Download CSV file Issue (output includes separator BR)

I have a Interactive Report and displaying the column values (multiple values in same ROW) as mentioned below.SQL Queryselect deptno, function1(empno) empno from emp IR OutputDept Employee No 10 AAA,BBB,CCC, ... // - Row 1 20 XXX,YYY,ZZZ, ... // - Row 2 Now I want to display each employee in a new L ...

Oracle Interactive Report download

On of my interactive report displays many rows (more than 15K rows). The page is taking a lot of time to be able to load.This report query has to go against many main tables and history tables. We have put indexing to the history tables. But it still takes around 2-3 minutes to display the report on ...

Oracle Dynamic interactive report

I have a requirement to create pivot financial report using interactive report. I have managed to create a function retutning the dynamic query for the pivot report as follows:CREATE OR REPLACE FUNCTIONfnc_pivotRETURN VARCHAR2 ASCURSOR cur_qry ISSELECT DISTINCT ', SUM (CASE WHEN financial_year = ''' ...

Oracle BUG / Interactive Report - Advanced Attributes - Page Items to Submit

Yesterday, I had to use a nice feature of the interactive reports. But quickly, I faced a problem.Here's the situation1) The components (let's say we are on Page 1):- items: P1_FILTER_ACTIVITIES = Select ListP1_FILTER_EMPLOYEES = Popup Key LOV (Displays description, returns key value) Important: the ...

Oracle Customize Interactive Report

I am using Oracle Apex 4. I am trying to customize the interactive report, can you let me know how can I do it.For example, I want to add additiona link(image links) to filter the search results below the search box that comes out of box. I want to make the filter action to show always on the page. ...

Oracle Reuse Interactive Report Filtering components

everyone! I wanted to create a change notification application with APEX. I'm planning to use the Interactive Report to enable the users build their own saved query using the filtering function of IR. I will provide an option for the user to subscribe (via email) for every query they want when their ...

Oracle Non-Interactive Report Break Formatting

I have a non-interactive report that is very large and I am trying to use break formatting to provide subtotals. It works, but is quite ugly. Can anyone tell me where I might find a list of the various substitution strings that can be used for controlling the appearance of the breaks? For example, r ...

Oracle IRR (Interactive report) auto refresh

I want to refresh my interactive report automatically after x seconds. I thought about the following example:<script type="text/javascript"> // automatic reload IRR function fnc_reloadIRR () { gReport.search('SEARCH'); window.setTimeout(fnc_reloadIRR, 5000); }; fnc_reloadIRR(); </ ...

Oracle Make Interactive Report not immediately execute

I have an Interactive Report that is displaying info from some very large tables. I don't want the report to run as soon as the page is opened. I did the following:Create Item: P100_NUM_ROWSCreated a Before Header Process to set P100_NUM_ROWS = 0In my SQL I added a where condition: where rownum < ...

Oracle Filtering Interactive Report which has combo box

I am a rookie in apex.I have an interactive report in which I have a column which contain's only combo box's. Let me say for example that the display values are Yes and No and the return values are Y and N and the name of the column as "required". When I try to filter the report, I can do so for all ...

Oracle Capturing Interactive Report Filter Fields

I've a requirement where in a user can view data, apply filters to it, and then invoke an Oracle API by passing in the data set currently visible on the report.If I can some how capture currently applied filters on an Interactive report, I should be able to recreate the same data on the server side ...

Oracle customise interactive report add spatial filter operations

I am currently doing a project in APEX involving spatial data. I am interested to know if it is possible to extend the existing interactive reports to include spatial filters / operators. I have seen on this page: http://dpeake.blogspot.com/2008/03/advanced-interactive-reports.html that you can make ...

Oracle Apex calendar report url problems

im having problems with the "day link" attribute in an apex calendar report.i have the calendar set up so that when you click the date in the calendar it sends the date formatted correctly to the date picker field in my create a new appointment page. so pre-populating the field as the page is loaded ...

Oracle Resetting interactive report

I have created an interactive report that is displayed when a certain condition is met (its displayed when a SEARCH button is pressed). I also have a CLEAR button that hides the report when the button is pressed.Is there a way to remove any filters that may have been applied to the report when the C ...

Oracle Bug? Interactive Report - Help not Translated

I translated all Text Messages regarding Interactive Report, but Help (popup window) is still in English. Everything else is translated.Is this a Bug, or am I missing something?Best ...

Oracle updateable interactive report

is there a way to use an interactive report as an updateable report?I think of page with a combination of a tabular form with the filter, sort and group-functions of an interactive report.Is that possible? ...

Oracle filtering interactive report question

i created an interactive report that uses a query like this..SELECT i.issue_id "ID", i.title "TITLE", i.module "MODULE", u1.last_name || ', ' || u1.first_name || ' ' || SUBSTR(u1.middle_name, 1, 1) || '.' "OWNER", u2.last_name || ', ' || u2.first_name || ' ' | ...

Oracle Use Interactive Report Template for Classic Report

I want to replace the classic report template with the interactive report template so that all reports in the application have same look feel.Please let me know how this can be done. ...

Oracle Modifying Interactive Report - Tabs

Hiis it possible to change the colour of the tabs that are generated when you save an Interactive Report?As an example, I have created an interactive report added some filters and then saved the report. I now get two tabs in my interactive report:Working ReportNew Reportthe background colour of thes ...

Oracle Make Interactive Report column header span two columns

How can I modify the header on an interactive report so that one column title can span two columns? I.E. column A and column B have different values but have the same column header of "A plus B" ...

Oracle Avoiding Interactive Report Page Refresh when linking to same page

I have searched the forum and haven't found an answer:I have an interactive report #1 with a link in a column that points to the same page, so that other report area in that same page gets a value needed for running a second report #2.It's a kind of master detail...This works fine, except that when ...

Oracle Unfriendly Interactive Report behaviour

When you're on the second page (pagination) an interactive report and search for a term that only has one page of results, the following message is displayed: "Invalid set of rows requested, the source data of the report has been modified. reset pagination". It would seem more sensible (and usable) ...

Oracle Need Interactive Report EBiz 11.5.9 inventory tables and views over DB Link

I need to create an Interactive report on this SQL: select glcc.segment4 as ENTITY_CODE, glcc.segment2 as DEPARTMENT_NUMBER, glcc.segment1 as Account, ai.VENDOR_NUMBER as VENDOR_NUMBER, ai.VENDOR_NAME as VENDOR_NAME, aiv.DESCRIPTION as DESCRIPTION-- , aiv.period_name, aiv.AMOUNT as INVOICE_DISTRIBUT ...

Oracle Vertical interactive report?

How can I make a vertical interactive report? ...

Oracle Basic Interactive Report missing value on Filter.

All,I have a basic interactive report based on a view joining two tables. On a Status column we are missing one status value from the fliter drop down. This problem only exists in the Production database. The issue does not exist in Development.Any suggestions would be welcome. ...

Oracle Regarding Interactive Report

I created the Interactive Report, then i remove the add/delete/modified function within it, because i put my function all in plsql package. I able to managed the add and modified function, however, the delete function is totally give me a headache. I create a PL/SQL anonymous block (proccess) when t ...

Oracle Refreshing interactive report on a table

If we were to update/delete/add data to a table from the backend, how can we refresh the corresponding interactive report?Is there a way to set it for each time such a change happens?I have also noticed, that when data is added from backend, the table in the object browser does not reflect the new l ...

Oracle Using Interactive Report Selection In A Procedure

I want someone to be able to select a set of rows using the interactive report filtering capabilities. Then I want to use the data from the selected rows in a procedure. Is there some way to obtain the query being used by the report; or, in some other way obtain the rows that are selected? ...

Oracle Accessing Interactive Report Fields

I have an interactive report with a SQL query to generate data for the region. I want to hide the region and search for records using the interactive search fields.Is this possible? ...

Oracle LOV - interactive Report

In the interactive Report, I founded” List of values definition (Enter a SQL query that returns one column)”I would like to know any clue. ...

Oracle Variable interactive report

I have a select list on my page in which each item returns a different table name. Now I want to make an interactive report which returns all the rows of the table that was returned by the select list.I did this using apex_collection and this works. In this case the items can't be changed, deleted, ...

Oracle Using Interactive Report with SQL query accessing tables via db link

Is there a known issue with using the interactive report in version 3.1.2.00.02 with SQL that is accessing tables via a database link? I get the error 'not all variables bound', I do not get this error when using the standard report for the same SQL?Thanks,Edited by: mlodaya@mfps.com on May 26, 2009 ...