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 RepliesI 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 RelatedApex 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]....
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
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 RelatedI would like to display the row number in the report region at the beginning of each row for each page (based on the number of rows to display per page).
So if the number of rows per page is 15, I would want to show each row from 1 to 15. When going to the next page (16 - 31) I would like to show row 1 to 15 again next to each row. And if the number of rows per page is 20, I want to see row numbers 1 to 20 on each page.
Since I believe an Update button only processes the current page, I would like to then use this row numbers (1 - 15) to get the values of the displayed column for each row to perform an insert to another table.
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 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.
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 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 RelatedMy 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'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.
Does version 4.2 create a new db session for each report run on a page?
The reason I ask is we have a page with 4 report regions, each querying a global temporary table that is populated in a 'Before Regions' page process. The first report displays the correct data, but the others return 'No Data Found' and it is because the Global Temporary Table has been cleared out following the first report. This did not happen in 4.1.
I know we should be using Apex Collections, and we will in future, but time is at a premium to get this live
I have an interactive report with two columns timestamp type. I want to use the compute action in order to get the difference between those dates. Nevertheless I got values like this: +000000008 00:00:00.000000.
View 1 Replies View Relatedi would like to implement drag and drop for ordering the rows.It is a quit complex query behind the report (joins, ect.) I need a hidden item like this
apex_item.hidden(1, rowid)
AS Sort The problem is, that rowid is not allowed here (ORA-00918: column ambiguously defined).Because of that article I am sure the joins in my query are the problems ORA-00918: column ambiguously defined But I need this rowid for the sorting process.How to implement Drag and Drop I have learned from here:Read Article - Drag & Drop tabular form rows.
I have what I hope is a simple question. I have a SQL Report region and I want to add more padding to the left and right sides of the table cell. I don't want to change the style sheet because I don't want to affect other pages. But I tried adding style attributes on the "Region HTML table cell attributes" field but I still can't get it to work. give me an example of how I can do this?
View 9 Replies View RelatedHow 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 starting to use the interactive reports in version Apex 4.1.1 but I am unable to get the report to show null records on the first load. Is there a setting that would stop the data from loaded on first load or would I have to customize that option.
Some of the columns have a lot of data and therefore take a long time to load so I would like to avoid that.
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?
Re: 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’m on APEX 4.1, 11gR2, Windows 7 and the latest version of Firefox. I have an interactive report. I want the end user to have the ability to click on a row level link and launch a modal pop up view of another page. Ideally, I'd like to be able to use the Skillbuilders plug-in. I can get it to work if I just go the full page route but I cannot figure out a way to get it to work as a modal pop up. I’ve tried various methods, none of which work, but the one I believe I should be following is by using a page level Dynamic action that fires when a JQuery Selector found item is clicked. The problem I’m having is that I cannot find the correct JQuery Selector syntax for the column. My report has a static ID of IDN and my column a header of PARTS. The best I can manage is not to see anything happen other than a page refresh (when the link is set to the same page). I do not see and firebug console errors.
I’ve replaced the dynamic action modal page call with an alert, which is not showing, to make sure that it's not the plug-in configuration that is causing the problem.
what I should be filling in in the JQuery Selector field of the DA and what the link attributes should be? Given that I wish to redirect from page 1 to page 2, what do I put in the other link fields?
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 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 Related