Checkboxes In A Report

Mar 25, 2013

i have a table called "Employees" and based on that i have a report. When i select one of the employees, i created a report that shows all the inventory that that employee has. The source for report is this:

select
apex_item.checkbox(1,assetid,'UNCHECKED') " ",
apex_item.text(2,asset_tag) "Asset tag",
apex_item.text(3,shortdescription) "Short description",
apex_item.text(4,serial_number) "Serial number",
apex_item.text(5,service_tag) "Service tag"
from products
where id=:p26_id
[code]....

So all it suppose to do is to take whatever records I check from my initial report and to insert those records in a dummy table which i can use later.It's a bit obvious what's my mistake (if I select any 3 records in report, it will copy in the dummy table the first 3 records from my report).

View 1 Replies


ADVERTISEMENT

Add Checkboxes To A Report?

Dec 18, 2012

I have a simple classic report, it returns all 4 columns from a table. I need to be able to save the values of 2 of the columns from certain records from this report into another table. My supervisor wants me to add a checkbox to each row so that one or more records can be selected and the values of the 2 columns can be added into this second table.

View 6 Replies View Related

Forms :: Deselect All Checkboxes Except The One Which Has Been Selected

Jun 30, 2009

I have multi record block and a select checkbox in that block. My requirement is whenever I select any checkbox all other checkboxes should get deselected except the one which I have selected just now.

Example: I started from first item (checkbox).

I select first checkbox and when I will select second checkbox, then 2nd should get checked but all other checkboxes should get unchecked.

View 8 Replies View Related

Application Express :: Looping Checkboxes

Jun 15, 2012

How can I loop through unchecked checkboxes using this construction: FOR i IN 1 .. apex_application.g_f01.COUNT (its for checked)

View 5 Replies View Related

Forms :: Treeview With Images And Checkboxes With OLE Container?

Jun 4, 2009

I have an issue with an OLE-Container (ITreeView).

I have already a form with the treeview (database no necessary) with some nodes added manually.

All this nodes have checkbox and style properties, drag and drop (drag automatic and drop manual).

I added also to the form an OLE-Container for the listImage and put into the container the images that i need.

I put checked the father and when it is true then a variable into the declaration of the check of the childrens change and the child nodes are checked too, but when i do it manually nothing happened.

What I want to do is the next thing: I want to be able to drag and drop in every place of my tree to change the positition between the nodes of the node father and to change it also with childnodes of other parent. To Put an Image next to each node (how to call the images that are inside of my imagelist) When I checked the parent then check all the child nodes of it.

View 22 Replies View Related

Forms :: Enabling All Checkboxes When Block Is Loaded

Dec 6, 2012

My requirement is as below,

I have one main form and there is one button when i click on it, another form should be opened which should display multi records with check box for each record.

I have implemented so far. When the new form is opened by default all the records should be checked. if user does not want some of them then it can be unchecked(This can done manually)..

I have put below code in when-new-block instance trigger

set_item_property('LOCKBOX_DETAILS.CB_SUBMIT', ENABLED, PROPERTY_TRUE);

Unable to load the block with all the records checkboxes checked.

View 4 Replies View Related

Application Express :: Deselecting All Checkboxes In Tabular Form

Nov 8, 2012

I am using Apex 4.2 with Oracle 11g

I have a requirement where I need to create a tabular form with a check box column. I created one using Apex_item.checkbox() function.

I have a button, when clicked it has to deselect all the checkboxes. I know I can use javascript onclick function and call a javascript. But I dont know how to use the javascript for a tabular form.

View 0 Replies View Related

Forms :: How To Count Checked Checkboxes Along With Their Checked And Unchecked Condition

Nov 1, 2012

i want to count how many check boxes are chechked and if the check box is unchecked the count will decrease as soon as checkbox is check or uncheck.the number of chech boxes are depentdent on record set that are fetched from database.

View 2 Replies View Related

Reports & Discoverer :: How To Print A Report Name With Full Path At Left Bottom On Report

Sep 20, 2012

How can i print a report name with full path at left bottom on report.

View 3 Replies View Related

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 :: Create Items Context Help Editable Report Or Report And Form App

May 9, 2013

How do I create Items context help editable report or report & form app?

what is its table?

View 2 Replies View Related

Reports & Discoverer :: Can Create Drill Down Report With Parameter Form Of Report

Nov 29, 2011

I am trying to open report in parameter form in drill down report.

View 7 Replies View Related

Application Express :: Re-execute Single SQL Report On Multi-Report Page

Oct 25, 2013

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 Related

Reports & Discoverer :: Can Create Drill Down Report With Parameter Form For Report

Dec 19, 2011

I had report A which drill down to report B. While drilling down to report B, The parameter form of report B should be displayed which accept parameter code and then open the report B. My parameter form is displayed but not accepting the input. i am using the hyperlink to display the second report. Is there any cgimap.bat file to be configured for the parameter report? If yes then how to configure this file?

View 1 Replies View Related

Application Express :: Report Not Initially Sorted As Defined By Report Attributes Sort Sequence

Nov 1, 2012

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

View 4 Replies View Related

Application Express :: Test Report Button On Report Queries?

Jul 20, 2012

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!

View 0 Replies View Related

How To Export /convert Matrix Report Into Excel (using Report Builder 6i)

Sep 4, 2013

i made a matrix report using report builder 6ii want to export all report data into excel.

View 0 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

Reports & Discoverer :: Anyway To Stop Report In Before-Report Trigger

Jul 24, 2011

Is there any way of stopping the report from executing in Before-Report Trigger.

Actually what i am doing is to see whether some records are present there in the table in Before-Report Trigger on which the report is going to print. Because I am doing some updates in After-Report trigger. I want to stop if there is no records present in the table in Before-Report Trigger so the report will not go forward to After-Trigger of the report.

how to stop and by using which statement.the other way so that if report has no data then After-Report Trigger should not fired.

View 2 Replies View Related

Application Express :: Classic Report - Logo In PDF Report

Apr 12, 2013

I have created a classic report in Apex. Have enabled the print PDF link on the report for the business users to download it in a PDF format. Is is possible to put a logo in a downloaded PDF from the report?

View 0 Replies View Related

Reports & Discoverer :: Calling Report From Another Report

Aug 31, 2010

I created two reports separately.

1.pub.jsp
2.serc.jsp

what i need is i want to call the report serc.jsp from pub.jsp .

View 6 Replies View Related

Reports & Discoverer :: How To Call A Report From A Report

Aug 17, 2012

How to Call a Report from a Report?

Not from a form but a Report from a Report?

View 3 Replies View Related

SQL & PL/SQL :: Generate A CSV Report?

Feb 18, 2012

I have a requirement to generate a report in csv file, attached scripts, sql query and actual output and expected output.

In the query, I am hard-coding month&year, when I run in march 2012 it should include march 2012 in output (similarly for every month going forward), to do that I have to modify my query to include march 2012 & preceding months in every individual query, this report needs to be generated once every month.

I am looking for a generic solution which does not need to be modified every month, also in the output,under "Mail File" data should be in ascending order, in the "Total Mailed" all the months should have grand total.

oracle version : 10.2.0.1.0

View 25 Replies View Related

SQL & PL/SQL :: How To Make Report

May 2, 2010

How can I make report in below format ?

Month Apr-09 May-09 Jun-09 ...... Mar-10 Total

Basic 1000.00 1100.00 1300.00 ...... 1300.00 13260.00

HRA 500.00 600.00 650.00 ...... 600.00 6350.00

Conveyance 100.00 200.00 300.00 ...... 350.00 1300.00

Gross Amt 12350.00 13500.00 13200.00 ......14500.00 23456.00

View 9 Replies View Related

SQL & PL/SQL :: Privileges For AWR Report

Apr 24, 2012

I have a doubt, I wanted to set the AWR report in scheduler. So i have created the below procedure in SYS LOGING and working fine.

But when i trying to create in another user after grant required privileges, still it shows error message.

CREATE OR replace PROCEDURE Create a wr reports
AS
v_instance_number v$instance.instance_number%TYPE;
v_instance_name v$instance.instance_name%TYPE;
v_dbid v$database.dbid%TYPE;
v_file utl_file.file_type;
[code].........

View 7 Replies View Related

Forms :: Run Report From 10g?

Sep 21, 2011

Oracle 10g Developer suite / using OC4J run report from form with and without passing parameters.

View 5 Replies View Related

CPU Time In AWR Report

May 2, 2013

We are using Oracle 10g on Linux. Followings are some contents from the AWR report:

Elapsed:            60.26 (mins)           
DB Time:           437.27 (mins)Here why the DBTime is greater than Elapsed Time. Is it due to the fact that this is the total time spent in user calls by multiple sessions i.e. ( some sessions were on CPU, some were in IDLE state waiting for I/O)

The below statistics show that CPU was used only for 5,363 seconds. We have 8 CPU grid, so total CPU time is 60.26* 8= 482.08 Min. I want to know where does the remaining time was spent. Also there is 20.4% of Total Call Time. How does it is calculated.

CPU time 5,363  20.4. The below statistics for reference:

BUSY_TIME      1,218,675
IDLE_TIME      1,675,112
[code].....

View 2 Replies View Related

PL/SQL :: Getting Rate For Report?

Nov 8, 2012

This is my sample code:

create table myReport(
report_id integer,
product_class_id integer,
place_id integer,

[code]...

would like to get the rate for my report table base. The search for the rate first will be base on product_class_id, year and place_id, second if the report row match the product_class_id and year but not place_id it should get the default rate (in my rate table the place_id is null).

Last if the report row doesn't match any key the result should be zero.This is my result query, how can I do this query?
report_id     product_class_id     place_id     fy rate
1     1     1     2012   15
2     1     2     2011   6
3     1     3     2011   7
4     2     2     2012   18
5     2     5     2011   2
6     3     1     2012   0
7     4     1     2012   0

I try to do a function by don't know how to handle the default place_id (null)

View 2 Replies View Related

Statspack Analyzer Report

Mar 1, 2011

I would like to know about this Buzz around the High and Low parameter values in Statspack analyzer. How come you decide a particular parameter value is high or low. Is there any bench mark given by oracle on basis of which Statspack analyzer make any decision.

View 3 Replies View Related

Getting Different Values For Session Report

Sep 3, 2010

query for number of users connected to the database:

select count(*) "Number of users Connected" from v$session where type='USER'; it produces 125

The following query is used to describe where and when the users are connected to the database.

set pages 500
set linesize 750
column box format a20
column username format a7
column program format a20
column os_user format a20
[code]...

It should produce 125. But its showing only 119 users. so around 6 users missing in the list. find why 6 users are not listed..

View 6 Replies View Related







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