Application Express :: Interactive Report / Change Text Color Based Upon Value In Another Column
Nov 12, 2013
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.
View 10 Replies
ADVERTISEMENT
Oct 18, 2013
I 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?
View 7 Replies
View Related
Jul 19, 2012
In Interactive report, I want the sum of the column to be displayed in different colours if total is negative.
View 1 Replies
View Related
Sep 9, 2013
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 Related
Jul 10, 2012
it is possible in an Apex interactive report to sort text as number?
For example, a series of text rows:
4
10
2
would sort as:
10
2
4
if it were text. What I would like to see is:
2
4
10
View 4 Replies
View Related
Aug 29, 2012
I am using Apex 4.1 and have a requirement to create an interactive report based on a dynamic query. This option is available in Classic report but in Interactive this feature is not there. Tried using collections or just a view (thought of changing the view definition during "On load", but structure of the report is already defined based on the definition of the view at design time).
Is there any way of achieving this?
View 1 Replies
View Related
Nov 12, 2012
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 Related
May 31, 2013
I have a classical report with a column as "Affirmation Status". This column can take three value as "Affirmed, Rejected or NA". My requirement is I have to show all row in one color like red wherever it has value affirmed, and all row in color like green wherever it is rejected.
View 4 Replies
View Related
Feb 15, 2013
In 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 Related
Jul 16, 2013
I 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.
View 1 Replies
View Related
Jul 10, 2012
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 Related
Jul 19, 2013
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 Replies
View Related
Aug 17, 2012
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 Related
Oct 29, 2012
I have created report with the collections. Report query has been changing dynamically but i got problem with report header names and headers names has not been changing dynamically it is always showing like c001,c002....etc so, i have created global item(G_ITEM) in shared components--->Applications items after that I have created process(before headers) and assigning some value to G_ITEM and used &G_ITEM to column headres in IR Report but here &G_ITEM is not showing any value.
How can i achieve dynamic headers names by using *&G_ITEM(global items)*
View 1 Replies
View Related
Jun 21, 2012
I am using apex 4.1
I have a list on page 0 which is "Tabbed Navigation List" and there are three pages running on it.
I want to change the color of the button when i click on the specific button.
View 6 Replies
View Related
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
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
Feb 2, 2013
change the color of a row in APEX SQL report. Change Colour of Row - Oracle APEX SQL Report...It's a bit outdated, and trying to figure out how to get to this page: URL.....where I can conditionally set background color.
I am using theme 13 (legacy) and made a copy of the report region. Edited it but cannot find an equivalent section of that apex 3.1 screenshot.
View 4 Replies
View Related
Mar 13, 2012
i want to change the text background color as red ex: if desc is the field in the forms and when i type the word china in that field then that china backgroud color should change when i move to next item to red for that record alone..in the key_next_item trigger i wrote this
set_item_property('desc' backgroud_colour,'RED');
IS THIS RIGHT only that particular record should change
View 14 Replies
View Related
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
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
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
Jun 27, 2012
customizing 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
View 3 Replies
View Related
Feb 23, 2010
How can I change the color of a text item in Oracle forms using timer for every 500 milliseconds? The text must appear to be blinking.
View 3 Replies
View Related
Jul 15, 2013
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 Related
Mar 27, 2013
I 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.
View 1 Replies
View Related
Jan 28, 2013
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..
View 2 Replies
View Related
Dec 18, 2012
I 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
Feb 15, 2013
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 Related
Apr 22, 2013
I'm trying to translate all of the interactive report messages, on Apex 4.2. I'm using this [
[URL].........
As a reference. I have several problems translating the help section of the interactive report. First of all, I can't seem to find all of the message names. The ones I couldn't find were:
Sets the number of records to display per page.(regarding displaying certain number of rows per page)
Format enable you to customize the display of the report. Format contains the following sub menu:
Sort
Control Break
Highlight
Compute
Aggregate
Chart
Group By(regarding format)
You can define one Group By report per saved report. Once defined, you can switch between the group by and report views using links below the Search bar. To create a Group By report, you select:
the columns on which to group (up to 3 columns can be selected)
the columns to aggregate along with the function to be performed (average, sum, count, etc.)
the columns to use for sorting (up to 3 columns can be selected along with direction and null sorting options)(regarding group by)
And secondly, I have translated this message
Select columns icon enables you to identify which column to search (or all).
Text area enables you to enter case insensitive search criteria (wild card characters are implied).
Go button executes the search.
Reports displays alternate default and saved private or public reports.
Actions Menu enables you to customize a report. See the sections that follow.using this message name:
APEXIR_HELP_SEARCH_BAR.
However, now I have two messages shown in that section: the original one, in English, and the translated one.
View 1 Replies
View Related
