I have created a IR report and I set the default search column using the suggestion found in the thread URL....but how can I keep this default even after the research was done?Now it is resetted !
View 1 RepliesI am on APEX 4.1.1, db 11g and I have a report which is quite slow to retrieve results from its query. The page has some filter fields (e.g. store code, dept code) in addition to the generic search field.
When the user lands on this page (from a menu page), the query runs before the page displays and this typically takes 1-2 mins without any filters yet set. The usual browser loading indicators are not obvious to the user and they might not be aware that it is working on the request.
I want it so that it will only run the query AFTER allowing the user to get to the page, let the user fill in some filter criteria and then click on the GO button. Therefore the query will run after the page is submitted. When you hit the GO button on the interactive report, a nice rotating apex_loader.gif appears, making it obvious to the user that it is working on the request.
I would prefer NOT to create 2 pages, one for user filter, and a second for the actual report as I have many reports/inquiries which fit this category and I would prefer NOT to have to create pairs of pages for each.
My Interactive Report will run for a minute or for a long time like 5 to to 10 minutes depending upon given parameters to the report. Now I would like to cancel the report search when I made a mistake like searching on a value which willtake more time. how to achieve the same.
View 1 Replies View RelatedI am using Oracle Apex 4.2 and theme 25. I want to add select list in IR search bar. I am able to add buttons but i am unable to add items.
View 4 Replies View RelatedI am using Apex 4.2, The Interactive report Search is not working properly, when i am entering complete date or time it is not showing any results...how to increase performance of the search...
View 5 Replies View RelatedI have a region where I have 3 textfields and a Submit button. Then, another report region where I have a query with the where condition that makes reference to the 3 texfields. This is:
Select * from ANYTABLE
where column1 = :P1_TEXTFIELD1
and column2 = :P1_TEXTFIELD2
and column3 = :P1_TEXTFIELD3
When I click the submit button, the report is reloaded (in fact, all the page) with all the conditions (in textfields) correctly. Now, what I need is that when I click the submit button, the filter appears in the screen; I mean, show the funnel with the filter conditions as if I made it since the search bar.
when receiving the output of a report subscription in Apex 4.1.1, the search Box is missing, only the Text string 'Suche:' is displayed.If i download the report as Email or html, the search box is there and usable.
Maybe i'm wrong, but this was not under Apex 4.0.2.
I am developing a Catalog style application and displaying pictures in an Interactive Report; I can get the Interactive Report to display the Icon view when users visit the report the first time, the report works pretty simply. It has a series of buttons for the Sections of the Catalog and when the user presses the button it fills a hidden item which is in the where criteria of the Catalog, all of this works great with one exception:
When the user clicks the Catalog button and the data in the Interactive Report Changes; the Report changes to "Report View" I would like to maintain the report in "Icon View" only is there a way how I could have the interactive report only show "Icon View".
I have created a JQuery mobile template for APEX which at the moment is just returning data from my database in a reports region. Is it possible to include a search bar before the user sees any data so they can search for records in the database and return them to the results page I have already created?
If so what is the best approach with the mobile template?
Since I'd rather not do it directly in the SQL used to populate the report, any clean way to style all cells of a given column from an interactive report? Perhaps all cells of interest can be addressed through jquey using the "headers" attribute they share?
View 5 Replies View RelatedIn Apex version 4.2 in interactive reports, you can stop users from hiding columns by unchecking a check box under column definition.Is there a way to stop users from hiding a specific column in version 3.2.
View 1 Replies View RelatedI have a column named 'Comment'. Its have a huge data due to which the length of that column in interactive report get increased.
I need to fix the length to a desired value.I used following code in Region Footer:
<style> table.apexir_WORKSHEET_DATA td[headers=COMMENTS] { _width: 300px; min-width: 50px; max-width: 300px }</style>
Its solved the problem by fixing the width of the column but the column is not showing the full data now. It is hiding most of its part to fit it in that column.
How to control the column width on an interactive report. I can force it by making the column header really long but that is a crazy solution. How can I get control over this? I have columns that contain memo entries and if I use the header memo the report has tall skinny columns which makes reading very difficult.
View 1 Replies View RelatedI am trying to change the column order in an Interactive Report. Run the report as a developer then use the action menu.
However, I am not sure how one can run the the report as a developer. Do you just login and run the page? Then if I do that, I don't see the action menu there. If I go to page attributes "Save Report" tab, I do see the action menu but "Select Columns" only gives me "Report Type", "Report Name" etc as columns. Or we don't have enough privileges to run the report as a developer?
I have a sample report at this url:
workspace: homeworldusername: test_reportpassword: test_report APEX version is 4.2.3, database 11g release 2... Application #: 202 : IR REPORTS TEST Page in question is page #2
I have the report setup and need to make the following change... I have 2 columns: Comm and bonus,
if the bonus > comm, I need to change the text color of the bonus color to Red if the bonus < comm
I need to change the text color of the bonus color to Green if the bonus = comm, I need to change the text color of the bonus color to Black I have tried using code with the select and am NOT wanting that since it will be bundled with the data when downloaded as CSV or Excel.. Had thought about using the built in highlighting but that doesn't allow comparing a column to another.. Was thinking of a dynamic action, but not clear as to HOW to do it.
if on an interactive report, you try and filter on a date column, then the "=" operator disappears.You get other (not so useful) operators like "in the next", "not in the next" ">", ">=" etc. - but no "=" to be found.
View 6 Replies View RelatedI 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.
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".
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 RelatedI'm using Apex 4.2.1 against Oracle 11gR2 and mod_plsql.I've created a page containing two classical reports and an editable tabular form, with the form needing to be positioned at the page bottom.
The tabular form contains the usual buttons Apex creates by default such as "Add Row", "Save", and "Delete". Whenever users click any of these buttons, the entire page "jumps" and the mouse cursor goes to the very top of the page. Very disconcerting as well as frustrating since users must constantly scroll down to where the form is to see if a row was added or deleted.
I have set the tabular form region to "Partial Page Refresh". No effect.I have also created a dynamic action triggered on a button click (say the "Add Row" button) and whose action is to refresh the specific tabular form region. Again, no effect.
Even with both of these interventions, implemented individually as well as in combination, still has my page jumping and the mouse cursor at the top of the page whenever users click any of these form buttons.
how to prevent such screen "jumping"?
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.
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]....
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 Relatedcustomizing the interactive report.for example: my report IR shows the data as below:
Department Name Department Number
sales 10
service 20
HR 30
Finance 40
I would like to customize the report such that the report shows the data as follows:
Total count of Sales Department: 1 Total Count of Service Department: 1
Total Count of HR Department: 1 Total Count of Finance Department :1
I've got an interactive report with detail and icon view enabled. How do I get the current display state (user looks at report, detail or icon view) out of the apex dictionary ?Is there any place in APEX_APPLICATION_PAGE_IR_... where I can find it ? I'm on APEX 4.0.2. Upgrade to APEX 4.2.2 is planned this fall.
View 3 Replies View RelatedIn Interactive report, I want the sum of the column to be displayed in different colours if total is negative.
View 1 Replies View RelatedI have created a workflow which is going through 12 pages. At each page the user needs to choose his variables.
This could be the y-axes, x-axes, amount, surname ... etc. The variables are given to the next page via branch to next page process. Everything works well until I need to create an interactive report out of the chosen variables.
Lets say I have a variable called :P7_XAXIS with static LOV :
Amount,Amount;Date,Date;quantity,quantity
Page 8 is my IR. If I try :
Select :P7_XAXIS from mytable This will not work.
But if I try
Select Date from mytable This will work. Why? In my workflow there are several variables that can be used in a where condition. This also works. But I need to access the values before the condition and I also need to get a chart out of it.
I have created interactive report
--------------------
SELECT EMPNO,
ENAME ,
JOB,
MGR,
HIREDATE,
SAL,
COMM,
DEPTNO
---------------------------------
and Report Attributes=>Link Column have given Link to custom <img src="#IMAGE_PREFIX#e2.gif" border="0"> for P9_EMPNO...the editable displaying fine.
MY Requirement was ..in the editable link...i need to control with DISBALE/ENALE with if EMPNO=100 then all 100 id records need to editable link disable and if EMPNO=120 then All 120 records editable link need to be enable..this kind of thing need in the report..
If it is possible in Apex 4.2 get interactive report where clause and change it before displaying result e.g. We have an report and for some of columns we should do exact match and for some partial match.And business requirement is that they should not add additional % at the and of search string. It should be added automatically for some fields.
View 4 Replies View RelatedI am facing very strange situation. In one of my Interactive report, Filter option is not working (Processing symbol is appearing on top of the page, but nothing happens.). Is there any setting or something like that?
View 1 Replies View Related