Reports & Discoverer :: Pass Parameters In Table Section?

May 31, 2012

I have a problem here.Normally, we use &p_where inside a sql script in condition sectione.g :
select name from member where name like 'a%' &p_where order by name;

may i use this kind of parameter in table section?e.g :
select name from &p_table where name like 'a%' and status = 'a' order by name;

the reason i need to do is there are 2 different server. but i need retrieve same info.server ABC have table A but don't have table B and server DEF have table B but don't have table A.

Is there any other method to solve this problem?

View 4 Replies


ADVERTISEMENT

Reports & Discoverer :: Footer Layout In Main Section?

Oct 8, 2010

I have test in the main section of the layout in forms. I want to print the footer on the first page only. If I go to properties and select print object on first page, it still prints the footer in all pages. How can I force the footer on the first page only.

View 1 Replies View Related

Reports & Discoverer :: How To Join Head / Main And Trailer Section

Feb 10, 2012

i have generate a report using report wizard but i want to know how join main section and head section , what ever you do in report wizard impact in main section ,i have done some head section ,when i run report, head section run first and main section in next page .. how to join both sections in single page output..

View 2 Replies View Related

Reports & Discoverer :: Any Way To Pass Delimiter In Builder

Dec 15, 2010

I need to produce Excel spreadsheet from report builder.currently I am getting a format like,

ProductID;Count;CountUnique;
1001;12;16;
1002;11;6;
1004;16;666;
1006;60;86;

This format when opened in Excel does not group in separate columns resulting in all getting mixed up.I am looking a format like,

ProductID,Count,CountUnique,
1001,12,16,
1002,11,6,
1004,16,666,
1006,60,86,

This opens up clearly on excel. items like Product,Count are shown on separate columns along with the value.I am still looking into delimited formatting.

View 2 Replies View Related

Reports & Discoverer :: Pass Parameter From Forms To Report

Oct 5, 2013

I can not Pass parameter from forms to Report.

I use three parameter for report. I want to show the employee who has been hired between from_date to_date,it work well in report builder. but I want to pass parameter from forms to report and pdf format. I upload my work (this is actually a zip File, change file type txt to zip just before open).

View 5 Replies View Related

Reports & Discoverer :: Getting Parameters From Formula

Mar 19, 2012

I'm using a tabular kind of report. I've made about 4 formula (function)columns in my report. I want to make a calculation columns which will get parameters from values returned by these functions.

View 5 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 :: Passing Parameters With Cgicmd.dat?

Feb 14, 2013

i try this url: [URL]

with this key in my cgicmd.dat :

url_config: server=ed_url2 report=%1 userid=user/passxd@base destype=file desformat=pdf

and i have this error:

Unable to open file 'my_parameter='.

The rwservlet converts the value of my parameter to 'my_parameter='. It adds a '=' systematically at the end of my parameter.

View 2 Replies View Related

Reports & Discoverer :: Report Not Reading The Parameters Passed?

Jul 15, 2011

I have developed a RDF report which when linked to my application called OTM, it returns data which are not expected.

My report has two lexical parameters which are of date variables.

When i run the report from my application it asks for the parameter valeus and when i specify it, the report is not returnign the data within the date range i specified. it returns me all the data.

View 3 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 :: 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

SQL & PL/SQL :: How To Pass Timestamp Parameters

Sep 13, 2013

In my task I am trying to pass a timestamp datatype as one of the input parameter to a procedure in the package.But I am not sure how to give data for it while executing and testing it from anonymous block.

CREATE OR REPLACE
PACKAGE body ac
IS
PROCEDURE ac_ex_wbdb_keycats(
In_Sale_Location_Id IN NUMBER,
In_Start_Datatime IN TIMESTAMP,
In_Stop_Datatime IN TIMESTAMP,
v_refcur OUT sys_refcursor)

[code]....

View 2 Replies View Related

Forms :: How To Pass Menu Parameters In 10g

Aug 5, 2013

I'm migrating forms 6i to forms 10g. I have a mune which has parameters ,which are working in forms 6i. But when i try to comile in forms 10g its poping up error's.

View 3 Replies View Related

Pass The Parameters And Run The Nohup Command?

Mar 30, 2012

I had a requirement to execute a long running sql query. But the sql query had some parameters to be passed in and at some places i need to press "Enter" . I want to use nohup command and run the sql script using shell script concept. How can i pass the parameters and run the nohup command.

[URL]

I want to keep the sql script in a shell script and run it through nohup command.

how can i keep the above sql in a shell script and run through nohup command

View 1 Replies View Related

PL/SQL :: How To Pass Changeable Actual Parameters Into Procedure

Mar 29, 2013

I am writing a procedure for the front-end. The end-users need to insert multiple rows of data into history tables in the database (11G). My problem is: the multiple actually parameters is not a fix amount, this time, the amount could be 5, next time, it could be 12. I currently used one string and pass the actual parameter (P_id, number) as '2, 4, 5, 7, 8', the procedure was executed successfully, but cannot insert any data into history table.

See my procedure below (the base table has clob data, I have to consider insert ... select *), I tried to use to_number (CONTACT_MSG_ID), it doesn't work well:

PROCEDURE ARCHIVE_XREF_CONT_EMAIL(P_ID IN VARCHAR2) IS
BEGIN
INSERT INTO TRC_XREF_CONT_EMAIL_MSGS_HIST
SELECT *
FROM TRC_XREF_CONT_EMAIL_MSGS
[code].......

View 10 Replies View Related

Client Tools :: Pass Parameters To Oracle SQL Query?

Oct 9, 2012

I am trying to pass the parameters to query and I need to pass few parameters to query. Can I make it like like then I run it, then it come up and ask the parameter like this:

SQL> @text
para1 XXXXX
para2 XXXXX

And then the result of query will come up. I would like to put label for each parameter( likepara1).

View 11 Replies View Related

Windows :: How To Pass Null Values In OracleCommand As Parameters

Jul 19, 2012

How to pass null values in OracleCommand as a parameters

i am doing like this

((OracleCommand)cmdMySql).Parameters.Add(":1" ,Varchar2).Value = DBNull.Value;

Its giving error when dataadapter is going to fill.

View 3 Replies View Related

Reports & Discoverer :: How To Capture Runtime Reports In A Table

Jun 16, 2011

i have created a report in dis report i created bind parameters..how to capture these parameters into a table(for this i hav created a new table) means if i pass delivery_id at runtime

i need to insert this value into what ever i hav created table next time if i pass same value i need to update that record where should i write dis code in a report and can any one send script for this.

View 23 Replies View Related

SQL & PL/SQL :: Collections Fetch - Pass List As Input Parameters To Procedure

May 11, 2012

I have a record type and table of records as follows

type rec is record
(
empid employee.empid%type,
ename employee.ename%type
);

type tab_rec is table of rec;

Suppose data from employee table is fetched into this collection

Can you pls clarify if we can refer to all the rows of empid in the above collection ?

something like tab_rec.empid without using the subscript for referring to the nth row

My requirement isto pass this list as input parameters to a procedure(PL/SQL).

View 3 Replies View Related

Reports & Discoverer :: Generate Report To Database Table?

Aug 25, 2011

Is it possible to save a report directly in a table instead of the typically destination? (file, cache,...)

View 4 Replies View Related

Reports & Discoverer :: How To Convert Data From 6i To Oracle Table

Jul 10, 2011

How To Convert Data from Reports 6i to oracle Tables.

View 2 Replies View Related

Reports & Discoverer :: How To Run Discoverer Reports In A Forms Menu

Jul 5, 2010

how to Run a Discoverer Reports in a Forms Menu.

View 2 Replies View Related

Reports & Discoverer :: Launching Discoverer Viewer From Forms Menu

Dec 6, 2011

Is it possible to link to Discoverer Viewer from Forms without requiring the user to log in again. If so, can I then link to a specific Workbook within Discoverer?

View 2 Replies View Related

Reports & Discoverer :: Oracle Apps Data Does Not Show In Discoverer

Mar 19, 2012

When running my query in sql developer, I have to execute the command apps.fnd_global.apps_initialize(user_id, resp_id, resp_appl_id) in order to show the result of my query. Without this, the query returns nothing. The problem is I am using this query as a custom query for my Discoverer report and my report does not show any record.

View 3 Replies View Related

Reports & Discoverer :: Discoverer Admin - How To Copy Folder From One Instance To Another

Nov 9, 2011

I need to copy my discoverer report from dev to prod. How should I do this? Are the items created using calculation in the report can also be copied? These items are not present in the folder in discoverer admin.

View 1 Replies View Related

Reports & Discoverer :: During Open Report The Discoverer Application Frozen?

Jun 23, 2010

When I try to manage the report the Discoverer application frozen.

View 5 Replies View Related

Reports & Discoverer :: Provide Download Link To Blob In Database On Oracle Reports?

Aug 8, 2013

My user would like to have a way to attach files to database records. For simplicity, we'll say that each employee in the database could have 0-many file attachments associated with them. I know how to make this part work using Oracle Forms.

So that's the easy part for me. The tough part is that they want to be able to run an Oracle Report on our application server (displays as a PDF, also downloadable as a PDF) and have links on this report to the attachments that they uploaded using the forms process above.

For the idea of storing the files on a folder somewhere, I simply created a text object on the report that had it's hyperlink property pointing to the file location. Done.. opens fine.

However, I want to be able to have the option of storing these files in the database instead, just in case we can't go with the shared folder idea. I'm not sure how to make this work. I can store a blob in the database.. but how do I link to that blob on the report for them to be able to download it? Is this even possible?

how to create a download link on the Oracle Report that let's them download a file out of the database.

View 5 Replies View Related

Reports & Discoverer :: Text Bold - Format Particular Word In Oracle Reports At Runtime?

Nov 2, 2010

I have a doubt; can we format a particular word in oracle reports at runtime..?

Ex:-

A text filed contains data Quote:We request #BANK# to finance the same Bill as per agreed interest rate and other terms and conditions agreed on the above addendum and immediately remit the proceeds to our account A/c no. #ACCOUNTNO#, held with your Bank.

We need to make #BANK#, #ACCOUNTNO# are bold at runtime, Is there any method to format characters at runtime..?

View 10 Replies View Related

Reports & Discoverer :: How To Call Oracle Reports Inside A Stored Procedure

Oct 14, 2010

Currently some jobs created in WBT scripting need to converted into oracle,plsql.There is one job in WBT scripting, which will invoke the oracle reports inside and generate the PDF files in the destination path as follows:

a = runhide("c:Program FilesInternet Exploreriexplore.exe", "http://pscm9722:7778/reports/rwservlet?USERID=%LOGONINFO%+server=rep_pscm9722+destype=file+desname=D:ORACLE10G\%CCALLRptName%+desformat=PDF+PARAMFORM=no+report=PCCALL.RDF")
a = runhide("c:Program FilesInternet Exploreriexplore.exe", "http://pscm9722:7778/reports/rwservlet?

[code]...

Now, i want to convert this into oracle,plsql? Is it possible or not?

View 3 Replies View Related

Reports & Discoverer :: How To Create Aging Report In Discoverer

May 28, 2010

[Message #1] how to get a unapplied receipts for ageing report? and RMA(credit and debit note)columns ?

Which tables should be refered for Ageing reports.

[Message #2] How to create an ageing report in discoverer?

Which tables should be refered for a Ageing reports.

Ageing report colums customer name, customer id,location,segment, credit note and debit note in different column,unapplied amount and applied amount in a different colum.Already i got a due remaning date and total amount I want a linked table names.

View 1 Replies View Related







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