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 ...
How can I set the default records of an Apex Interactive report? It's always 15. ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
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? ...
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. ...
HiI have created an interactive report,but for the download formats I can only see csv and pdf.I know there is options for word and one more download format.DO we have to configure them somehwere and if yes, where? ...
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 ...
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. ...
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 ...
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 ...
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 ...
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 = ''' ...
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 ...
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. ...
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 ...
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 ...
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, ...
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(); </ ...
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 < ...
I have an Interactive Report that is selecting a hidden field.select apex_item.hidden(1,A.PK_ID) as "HOLD_PK_ID",A.STUDENT_ID as "STUDENT_ID", A.LAST_NAME as "LAST_NAME" Is there a way in javascript to loop thru all the rows currently displayed so I can access all the values of the hidden field?I kn ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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? ...
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 || ' ' | ...
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. ...
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 ...
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" ...
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 ...
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) ...
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 ...
How can I make a vertical interactive report? ...
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. ...
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 ...
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 ...
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? ...
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? ...