I've got a report with two lov's, where the user is able to change the lov value and submit it. After submit the status of the item P100_status will be changed in Disable. Based on this value the lov's must be disables with apex_disabled. How can I disable these columns based on the value of P100_status?
View 11 RepliesI have a Select list which when null should disable a button and when not null should enable it. For which I tried the Advanced DA. Strangely, in the final page where we select the item that is going to be controlled, the button is not listed! I can see other display items etc which I can select but not the button.
View 0 Replies View Relatedi had an issue last week with enabling and disabling a column in a tabular view. and i have it working now.... when the page loads i disable the column in the 25 rows being displayed.
the problem i now have is when i use the pagination to move through the rows the columns are all now enabled.
so what i am trying to do is this:
i have a tabular view showing 25 rows at a time. there is one column with a code and one with a description. when the code is changed, via a popup LOV, the description is changed based on the valus in a lookup table in the database.
i need the description column disabled, so the user cannot simply just type in the column. but when the page is submitted, the column needs to be enabled so i have modified the sumbit button to respond to a dynamic action which runs some enabling code then submits the page.
SO....
this all seems to be working except for when you use the pagination, the description column is all enabled.
is there a way of running some javascript when the pagination is refreshed? some better way of doing it?
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.
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.
I have a classic report which has 4 rows with date values. The Row1 has Date1, Row2 has Date2 and so on.
The report is structured like this
DATE_COL COL1 COL2
Row1 Date1 100 101
Row2 Date2
I want to use the values of DATE_COL of ROW1 which is Date1 in the label of ITEM1 which can be on same page or different page.
Also I want to sue the value of DaTE_COL of ROW2 which is Date2 in the label of Column 1 of Report 2.
How to accomplish this?
1. On the Home Page, click the "Settings" wheel in the header of the Team Development region on the right side.
2. On the Home Page Preferences popup set "Show" to something else as "All" and click [Apply Changes]
3. Back on the Home Page, in the Team Development region on the right side, click the number next to "Bugs"
4. ERR-1002 Unable to find item ID for item "P3500_RELEASE" in application "4800".
In APEX I've always created form on report so as to have the list of records of a table and the possibility of inserting/updating every sinle record by means of the form on it, ok?I have an application concerning classic costumers, orders, ... with a table for every item.
The problem is that I have to gather all information ao as to produce a classic bill with a typical layout where you have on your left some descriptions and on your right an amount but of course the layout is not based on a classic table, do you mean?Do I have to create a table in which I'll add data and null values so as to get the layout desired
I am trying to branch a report in one page with a report in another page, the branching should occur when a field say version is clicked.
Now when version is clicked then i will pass the id of the column to another report which should use that id to show only that row with that id.
I have an interactive report which contains the columns like
<li>empno
<li>Name
In the above i have "empno" with a column alignment of left and a "Name" with a column alignment of left.
Whether it is possible to override the data alignment that we set in the report according to the value of the application item like
If my application item value is US, then i need the column alignment of both the column"empno" and "Name" to be left and if my application item value is AR, then i need the column alignment of both the column "empno" and "Name" to be right. Whether is it possible to achieve the dynamic alignment to the report data of both the columns "empno" and "Name" according to the application page item value.And also in the case of page item i have a page item with a name P1_NAME in which it has a Element Horizontal/Vertical alignment to left.
I need that element alignment of the page item to behave dynamically according to the application page item, like if the application page item is US then the element alignment of the page item has to be left and if the application page item is AR then the element alignment of the page item has to be right.
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?
I have a table with 5 columns: Region, Country, total number of visitors, language, popularity.
The table is populated with various regions, countries and values. I want to display this information in the form of report in the following format:
#Visitors Language Popularity
Region +Country Region will be Europe, when the plus sign (+) against the country, France is clicked, the list should be expanded and display the country names such as Switzerland, Dublin, France, Germany etc. At the same time, before the list is not expanded the #Visitors , Language and Popularity should display the total sum for Region, Europe, whereas when the country (+) is clicked the values should be split across.
Ex:
#Visitors Language Popularity
Europe 100 100 100
+France
#Visitors Language Popularity
Europe
- Swiss 30 30 30
- France 30 30 30
- Germany 40 40 40
How this can be done in APEX?
navigate from interactive report to different forms..
View 10 Replies View RelatedRe: Report Columns duplicated when region is copied.
When I copy a region which I have created via master-detail form, the report columns are duplicated. I'm actually copying the whole page but I have had other cases where I just copying the desired region and the columns were duplicated there as well. And, of course, there is no way that I know to delete columns from the form. But I doubt because -- in at least some cases I've tried -- the columns seems to be "linked" in that a change to one copy of the column was duplicated in the other when changes were applied.
In the example (below), there are three regions on the page and the problem occurs in region 2. (I think I will likely delete the first region.) It's been agonizing trying to get the report of region 2 and the tabular formish edits of region 3 on the same page. I made this in Oracle 11.2 in our APEX 4.1 and imported it to 4.2. You can see it here:
WS apex_examples_01
demo
demo
Appl. 991204
Page 57 is the original page created in 4.1 and imported
Page 58 is the page copied from 57 under 4.1 and imported
Page 59 is the page copied from 57 under 4.2 (Same result as in 4.1.)
If you want to try the page, select DSD01 from the DSD LOV, click "Query Process" and then click the edit icon. Ignore the region 1 errors -- I'll probably delete this region. The data is region 3 is for Run Date 12-May-13.
Is there some setting that allows this region to be copied without duplicating columns?
P.S. I think I know why it happens: APEX hates me!
I have few reports that I want to have totals at the bottom of the report.
Is there any way I could apply totals to all columns without doing it one by one?
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.
I created one collection report and in the report when i click on the next >> then the report will show the next columns to enter data in some columns but the data which i entered before going to next will not get retain (data is getting lost) when i come back by clicking << previous but i want the data to get retained even when i click on next >> or previous << in report so that i can enter large amount of data at a time in the report columns by clicking >> & << and click on submit button to save all the data.
View 3 Replies View RelatedWe have built an interactive report based on dynamic query. Normally, all the selected columns are shown in "Display" Section of the interactive report. We have a requirement to move some of the columns to the "Do not Display" when the search is done. Is it possible to do it programmatically ?
View 1 Replies View Relatedi want to disable my EDIT link in report if it satisfy my case condition.
i am using some code but using this i can unable and disable text link not a image link how can i disable image link like edit link in report.
select * from (
SELECT AP.*, CASE WHEN AP.INVOICE_STATUS='C' THEN
'<font color ="Red"></b>Modify Invoice</b></font>'ELSE
'<a href="f?p=&APP_ID.:58:&SESSION.:INV_ID:&DEBUG.:58:P58_INV_ID:'
||INV_ID||':">
[code]........
How i can disable column in tabular form.working with 4.1 and i have wizard based tabular form.If i have entered value in one column second column should disable and vice versa?
View 5 Replies View RelatedI am using APEX 4.2
I have created a form with a Date From and Date To fields.
I am using the Date Picker format (the new one, not the Classic), and have set the calendar to Show on Both (Focus and Icon Click).
I would like to restrict the field so that the user cannot enter any text - they can only use the Date picker/calendar to choose a date. This would them remove the clunky validations - so I can restrict the users so they can't enter the wrong format in the first place.
Is this possible?
Need to create a report based on date ranges and for this created a interactive report and two page item datepicker fields P15_fromdate and p15_todate. Report works fine with this criteria.But user wants one more field quarter(P15_quarter), When they select the quarter the range values has to get reset and as to get applied to report.
Issue here is unable to find a way to set the page range item values based on the quarter field selection
how to reset the page item fields.
I have an application item that receives a web service result. This result is like 'MARIA','JOSE','JESUS'. I'm using this string into the parameters of the interactive report, but this is not recognized. I'm showing the content of the application item into a pl sql region and the content is 'MARIA','JOSE','JESUS', when I include this application item into the query, the IR shows me 'MARIA','JOSE','JESUS'
View 1 Replies View RelatedI have 2 items in my form:
1) Text Item
2) Tlist
Upon form load, TList will be populated with predefined item. The behavior i am trying to achieve is to have a text item so user could entered specific text which will then filter the values in TList .
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".
How do I create Items context help editable report or report & form app?
what is its table?
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 RelatedI 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?
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!
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