Application Express :: Source Of Interactive Report

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


ADVERTISEMENT

Application Express :: Saving Private Interactive Report Overwrites The Primary Report

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

Application Express :: Interactive Report Functionality For Classic Report?

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

Application Express :: Updateable Interactive Report

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

Application Express :: Region Of Interactive Report

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

Application Express :: Customizing Interactive Report?

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

Application Express :: Column In Interactive Report?

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

Application Express :: Display State Of Interactive Report?

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

Application Express :: Interactive Report - Aggregate Sum Color

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

Application Express :: Hide Column In Interactive Report In 3.2?

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

Application Express :: To Fix The Width Of A Column In Interactive Report

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

Application Express :: Interactive Report - How To Get Item Values

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

Application Express :: Interactive Report / Edit Option

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

Application Express :: Interactive Report Get Where Clause And Change It

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

Application Express :: Filter In Interactive Report Is Not Working

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

Application Express :: Cancel Search In Interactive Report

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

Application Express :: Translate All Of Interactive Report Messages On 4.2

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

Application Express :: Compute Action In Interactive Report

Mar 13, 2013

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 Related

Application Express :: Drag And Drop Interactive Report

Oct 8, 2013

i 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 &amp; Drop tabular form rows.

View 4 Replies View Related

Application Express :: 4.1 - Interactive Report Column Width

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

Application Express :: Report With Links To External Source Files

Mar 25, 2013

Application which I`m creating would work only inside domain. In the report I would like to have a link to files that stored outside from oracle server ( so apex cannot see the file but knows the absolute path to the file ).

And when I click in the report on the link to the file I would like to have this file opened in the application controlled from my OS ( naturally if I have rights to the path specified given from domain level).

I have been trying with column link ( a href, file:// ) and none of them works. I want to avoid APEX from copying files to local path or opening using java or creating directory.

View 2 Replies View Related

Application Express :: Interactive Report - Return No Data On First Load

Sep 6, 2012

I 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.

View 2 Replies View Related

Application Express :: How To Change Column Order In Interactive Report

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

Application Express :: Dynamic Action Call From An Interactive Report?

Jul 6, 2012

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?

View 2 Replies View Related

Application Express :: Interactive Report Based On Dynamic Query

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

Application Express :: How To Add Select List In Interactive Report Search Bar

Apr 16, 2013

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

Application Express :: Using A Variable Database Link For Interactive Report

Nov 5, 2013

I have a requirement where users will select an instance (db link) from an apex LOV and the data in an interactive report will query based on the db link selected. I can use a db link in an interactive report query but only if I provide the exact name of the link. If I do something link select * from foo@:P12_ DBLINK it doesn't work. It seems my only option is to use something like apex_collection.create_collection_from_query and then I can build my query with dynamic sql and use a variable for the dblink name. Then I just create an IRR based on my collection. Does that sound like that correct approach and/or am I missing anything?

View 8 Replies View Related

Application Express :: Remove HTML From Interactive Report Download?

Sep 27, 2012

I have interactive reports where the column link on a specific column has to be dynamic, that means, it cannot be hard coded in the column link attributes. The following is an example of one such report query:

case when d.object_type_description ='Business Service' then

'< href="f?p='||:app_id||':183:'||:app_session||'::::P183_OBJECT_ID:'||d.id||'">'||d.object_name||'</>'

when d.object_type_description = 'Real Time Event' then

'< href="f?p='||:app_id||':162:'||:app_session||'::::P162_OBJECT_ID:'||d.id||'">'||d.object_name||'</>'
else
null
end

as "OBJECT NAME"As you see in the above example, the link on the "Object Name" column could either redirect to page 183 or to page 162 based on the "Object Type Description" column.

The column attribute of the "Object Name" column has "Display Type" set to "Standard Report Column". That works perfectly fine in the UI of the report. However, if I download the IR data (in any format) from the Actions -> Download menu, the object name column values are downloaded with the HTML characters as:

< href="f?p=15548:183:6072319179284::::P183_OBJECT_ID:255245470513999672860510787772603748464">JP010000</>where JP010000 is the object name.

Is there a way I can strip the HTML from the column values in the downloaded files?I am using Apex 4.1.

View 4 Replies View Related

Application Express :: Interactive Report Search Not Working Properly?

Jun 12, 2013

I 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 Related

Application Express :: Interactive Report - Break Formatting Style?

Nov 14, 2013

,Is there a way to make Interactive reports break format work/look like classic reports break format? i.e.1st,2nd,3rd column option. The way IR breaks is that is reserves a whole row for the column used in the break, which is not what I want, I want the report to look like the following:

 city               emp           sal 
Chicago     John Miller  1500                
Mark Horton 2000
Denver       Rob Martino 1200 

I tried to use rollup queries which work fine except that it does not do exactly what I want when I sort columns through the front end , I am basically displaying a check box for grouped records ( and I want it to display at the first record of each group), so the order is important. for example: 

checkbox   City               emp           sal[ ]              
Chicago     John Miller    1500         
Mark Horton  2000[ ]             
Denver       Rob Martino  1200 

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved