Reports & Discoverer :: Multiple Columns In Param Form

Jun 4, 2012

I am adding a parameter to the parameter form of existing reports based on a select statement and has two columns. That part is fine. However, Oracle reports is adding a dash between the two values. Still fine, but I am also adding a UNION with ALL in case the user wants to run the report for all values. In the Parameter form it looks like this:

ALL -
RBC - 111
RRG - 234
TEB - 445

How do I get rid of the dash for "ALL" since I did not physically add it? Below is my select statement for the parameter I created:

SELECT code,
code_num
FROM codes
WHERE code_num <> 0
UNION
SELECT 'ALL', ' '
FROM dual
ORDER BY 1;

View 8 Replies


ADVERTISEMENT

Reports & Discoverer :: Create A Report By Using One Field / Text As Columns Name In Layout But Display All Columns

Jun 16, 2010

I want to create a report by using one field and one text as columns name in layout but display the all the columns. I mention the 5 column names in query.how can I write function in summary column.

View 4 Replies View Related

Reports & Discoverer :: How To Merge Multiple Reports In One Report In 6i

Aug 23, 2011

How to merge multiple reports in one report in reports 6i.

View 1 Replies View Related

Reports & Discoverer :: Averages Across The Columns

Jul 25, 2011

I have the following 6 columns in a report. And i need a 7th column which is a calculated field (average of the first 6 columns), the problem is some of the records have a '0' value in them so the aveage is not always (SUM)/6, If one of the fields have a 0 then the average is (SUM)/5, likewise if 2 fields have o's in them then the average will be (SUM)/4, see the sample data set.

A B C D E F G(Average)
83 83 33 0 0 100
83 83 33 0 0 100
0 67 67 100 17 92
83 83 100 67 50 100
83 83 100 83 50 100
67 0 83 100 17 100
83 83 83 67 67 100
83 83 83 50 50 90

[Code]....

View 7 Replies View Related

Reports & Discoverer :: Sorting On Different Columns

Sep 10, 2012

I have report where there are multiple columns and requirement is user may choose his own sorting order from form, any sample .rdf.

CREATE TABLE EMP (EMP_CODE VARCHAR2(12),EMP_NAME VARCHAR2(20),SAL NUMBER);
INSERT INTO EMP VALUES ('1','A',10);
INSERT INTO EMP VALUES ('2','C',3);
INSERT INTO EMP VALUES ('3','B',20);

[Code]..

--note order by is changing, how its doable in report 6i.

View 2 Replies View Related

Reports & Discoverer :: Dates As Columns

Feb 18, 2012

I have a small requirement for report, i want to develop a report based on dates and employee performance.Suppose i give the parameter from date as 01'st jan 2011 and end date as 31'st Jan 2011 then employee hrs will be as summary as rows distributed among days with the given date range as columns.How to make each day as column automatically.

View 5 Replies View Related

Reports & Discoverer :: Fake Columns In Matrix?

Aug 17, 2011

I have done a matrix group report which displays the department codes as columns and main account as rows for a month my problem is there are two groups and in one group there is data for 5 departments and in other group there is data for 4 departments and in display if there is no data for one department it should come as fixed columns in order to make it more readable

.Is there any way where i can fake some null data and bring it as column or any other way.

View 5 Replies View Related

Reports & Discoverer :: 10g Parameter Form Error?

Sep 26, 2012

While calling a report I am getting the following error.

REP-546: Warning: The value of restricted LOV parameter TOPROFIT is not among the selectable values.

When I call the same report through another PC it displays parameter form.

I am using Report Builder 10g.

View 3 Replies View Related

Reports & Discoverer :: How To Add Column In Oracle Form

Sep 12, 2010

I would like to know how can i add a column in existing report. I try to change SQL by doing this it does add that new column into group but when i try to run report i can not see that changes . then i try to do some changes in paper layout but i am not able to bring the changes in out put. i am new to this FORMS Reports . do i have to create a group again i am how can i change the layout in that report.

View 4 Replies View Related

Reports & Discoverer :: 10g - Parameter Form - Desname

Sep 3, 2010

In the parameter form in my report I want to give user the facility of browsing the location where he/she wants to store the report. how can I accomodate the same?

View 1 Replies View Related

Reports & Discoverer :: Error On Creating PDF File From A Form?

Oct 14, 2010

When a creating a pdf report in reports 6, under oracle 10g, the error message displayed is: The file is damaged and could not be repaired. If I change the report definition from a pdf to a txt file, the error does not display, but the output has the margings distorted.. It only happens when using reports 6

View 2 Replies View Related

Reports & Discoverer :: Calling Report From A Form (both 6i) On 11g Database

May 28, 2011

i am facing another problem with 11g database. i am using 6i forms and reports and recently shifted database to 11g 64 bit version. as its 6i forms so i use run_product to call reports. suppose my code for runproduct is in a button, once i press the button to get the print i am getting the logon_screen. if i enter login data again its giving the report.

View 1 Replies View Related

Reports & Discoverer :: Ordering Columns And Rows In A Matrix Report

Jun 20, 2012

I am having a matrix report, which has its column cells from table A and row cells from table B when I run the report the columns and rows are not ordered I wrote the order by statement in the report query but there was no defference.

I also wrot a subquery like

select column1, column2, (select column3 from table1 order by code)
from .... but it seems I can not order in a subquery

Is there any way to do that

View 5 Replies View Related

Reports & Discoverer :: How To Skip Columns With Space Based On Parameters

Jan 10, 2011

I have Two Parameters like 'YES' & 'NO'

when parameter is YES, column having values
when Parameter is NO, column having no values

In this scenario, how can i skip the column with space when parameter is NO because the column exist in middle of columns in report and Present with space when parameter is YES.

View 9 Replies View Related

Reports & Discoverer :: Select List Of Values From Parameter Form?

Jun 9, 2012

I am trying to select multiple values from a parameter form based on a select statement.

I created the parameter and write the select statement under list-of-value property However what I want is to let users choose multiple values from the select statement not only one value.

View 1 Replies View Related

Reports & Discoverer :: How To Create Parameter Form In Descriptive Format

Jan 28, 2013

I have developed report in reports9i and executing this report at application server but the parameter form is not displaying as its displayed in report builder.

parameter form isn't in descriptive format like you can check the department field. how to create parameter form in descriptive format or I am doing any mistake?

View 3 Replies View Related

Reports & Discoverer :: Calling Report From Form Asking Enter Password

Nov 28, 2010

I am calling a report from Form 6i by using RUN_PRODUCT.After pressing the call button from Form 6i, report is showing box for enterning user id and password.

View 5 Replies View Related

Reports & Discoverer :: Changing Lov Font Face To Parameter Form

Apr 11, 2012

I need to change the font face from following lov value for parameter form, How?

SELECT DISTINCT CODE_ENTRY.VILLAGE_NAME, CODE_ENTRY.UNIONN_NAME
FROM CODE_ENTRY

View 4 Replies View Related

Reports & Discoverer :: Link Two Forms And Pass Employee Name To Next Form

Jul 31, 2010

if i have two reports one of them is that you enter the office name and it will show you list of employee. the second one i want to show the information that is related to that employee by putting beside each employee button that if pressed i will go to other report that show me information about that employee.How i could link the two form and pass the employee name to the next form

View 4 Replies View Related

Reports & Discoverer :: Access To Multiple Business Areas?

May 5, 2011

I have been asked to see why a sister company cannot access multiple business areas through a single responsibility. At present, if they log in through a GL responsibility they can see all GL folders, items and the returned data. If they then go to the AP business area, they can see the folders and items, but when they run a report they get an error message 'Query returned no data' - but if they run the same query using an AP responsibility they get the correct results. I have looked at their user set up, and it seems fine i.e. has access to all business areas and required priveledges.

View 4 Replies View Related

Reports & Discoverer :: Multiple Copies Of Report With Different Footer?

Apr 10, 2012

i am using reports 6i .

i want to Print Multiple copies of report

1 - Customer copy
2- Department copy
3- Finance Copy

Setting the number of copies to 3 will print 3 copies of the report. But i want for each report , the footer should differ.

View 2 Replies View Related

Reports & Discoverer :: To Print One Report And Multiple Copies

Jan 3, 2011

I am generating a report/invoice. I want to print three copies of one report, one copy for consumer and one copy for bank and one copy for my official use. All three copies should have proper table,

e.g. consumer copy, bank copy and office copy.

how can it be done?

View 2 Replies View Related

Reports & Discoverer :: CASE Function With Multiple Criteria?

Jun 20, 2013

I am using: Desktop / Discoverer 4.1 / Windows XP.

I am attempting to add a new calculated column and have had some success with the CASE function but need to add additional criteria.

What I have that works is:

SUM(CASE WHEN Expenditure Type = 'Supplier Rebates' THEN Total Spend Plus Commit ELSE 0 END)

What I need to add are a few additional criteria. I attempted and failed with a few variants of this:

SUM(CASE WHEN Expenditure Type = 'Supplier Rebates' AND Capitalizable = 'Y' AND
Task Owing Company = '534' OR '915' THEN Total Spend Plus Commit ELSE 0 END)

The three criteria points that I am looking to includea are:

•Expenditure Type = 'Supplier Rebates'
•Capitalizable = 'Y'
•Task Owing Company = '534' OR '915'

View 8 Replies View Related

Reports & Discoverer :: SQL Union All - Query Block Has Incorrect Number Of Result Columns

Feb 1, 2012

I have the following Union All query. It throws the following error in SQL plus

ERROR at line 27: ORA-01789: query block has incorrect number of result columns

After doing some google for the above error it suggests there are incorrect number of columns in the Union All query.I could not figure out the exact location well SQl Plus says error is on line 27 at the first opening bracket like

(Select distinct c.contact_code

Following is the SQL query

Select
tbl_contact.contact_code,
contact_title
||'.'||contact_name contact_name,
contact_address,
[Code] ......

View 1 Replies View Related

Reports & Discoverer :: Multiple Record Printing On Same Line Number In Oracle 10g?

Jun 28, 2013

I want to print two record of emp table in same line number in tabular format report.

For example if i have emp table and I want to print empno,ename,sal columm only,In tabular format report, Two record should print per line. so If emp table have 14 record report should be printed on 7 rows.

so the output in print preview should be like this

EMPNO ENAME SAL EMPNO ENAME SAL
------ ---------- ----------------------------------------------
7369 SMITH 800 7499 ALLEN 1600
7521 WARD 1250 7566 JONES 2975
7654 MARTIN 1250 7698 BLAKE 2850
.
.
.
.

View 1 Replies View Related

Reports & Discoverer :: Lexical Parameters Are Used To Substitute Multiple Values At Run Time

Jan 15, 2012

I studied a document about lexical parameter in that it says "Lexical parameters are used to substitute multiple values at run time and are identified by a preceding '&'. Lexical s can consist of as little a one line where clause to an entire select statement"

Select * from emp, deptno &where.

and i know about substitution variables using & is this are same (lexical and substitution) or different.

View 14 Replies View Related

Reports & Discoverer :: Single Data Group Should Work For Multiple Type Of Conditions?

Jan 8, 2011

Actually I have one query which contains two parameters from_Date and To_date.

if user pass the values for the parameter like 1-dec-2010 to 30-dec-2010 query will works fine and it fetches the values according to the query selected. but now I am going to add one more parameter, the value is 01-apr-2010 now my query should run for 01-apr-2010 to 30-dec-2010.

Here my question is how should I make this scenario with only one query and at the same time the query should work for to scenarios.

View 6 Replies View Related

Reports & Discoverer :: Master-detail Report ( 3 / 4 Columns Detail To Be Printed)

Jul 19, 2013

my report is based on two tables.master and detail. i am using GROUP ABOVE style.displaying master tables columns up and detail table columns down.

my problem is ...i want 3 columns from master table (i.e)RECEIVER ID,RECEIVER NAME and RECEIVE DATE to be printed at the bottom of the page.

and also i want only 4 records from detail table to be printed on each page.

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

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







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