Lexical Parameter in Oracle Reports . . .

Advertisement

Hi all,
I am trying to pass a value to a query in oracle reports . . .
the use of the parameter is to add 2 additional columns to an existing query, if a bind parameter is set to 'Yes' else the parameter carries a value NULL;
Here is the code I have written in After Parameter Form:
if :P_ROLL_DETAIL_PRN='Yes' then
:P_CUSTOM_CODE:=NULL;
:P_CUSTOM_CODE:=:P_CUSTOM_CODE||'wdd.LOT_NUMBER' ||','||'wdd.SUBLOT_NUMBER';
else
:P_CUSTOM_CODE:='';
end if;
P_Roll_detail is the bind parameter . . and P_CUSTOM_CODE is the Lexical Parameter . ..
It works for value 'No' of P_ROLL_DETAIL .. . but for Value 'Yes' I get an error . . .
REP-0499: Column '' selected by the query is incompatible with report defination
Kindly help...
Regards
Jagan

Advertisement

Lexical parameters can not be used to change the number of selected columns. Consider selecting max number of columns always, but populating last two columns with either NULL values or table columns based on the parameter. Also, manipulations can be done in the layout model using format triggers.

October 11, 2015

Lexical Parameter in Oracle Reports . . .

Hi all, I am trying to pass a value to a query in oracle reports . . . the use of the parameter is to add 2 additional columns to an existing query, if a bind parameter is set to 'Yes' else the parameter carries a value NULL; Here is the code I have

Pass a ViewObject as a data parameter into Oracle Reports

Can I pass a ViewObject as a data parameter in an Oracle Reports jsp Report?you can use impliment this script to your query get data from file function AfterPForm return boolean is infile text_io.file_type; linebuf varchar2(3000) := ''; filename varc

How to is lexical paramter in oracle reports

I have a query like, select * from t1 where &c1=:v_srep; where t1 is tablename c1 is column name How do I create &c1 and how should I populate it ? Thanks,Pl see How to use lexical paramter in oracle reportsRead other 2 answers

I am unable to get order by column name in oracle report parameter form

i created query like following in query builder SELECT CASE_NO, COURT_ID, CASE_TYPE, INITCAP(PLAINTIFF) PLAINTIFF,INITCAP( DEFENDENT) DEFENDENT, INITCAP(COUNSEL) COUNSEL, START_DATE, PREVIOUS_HEARING_DATE, NEXT_HEARING_DATE,INITCAP( DESCRIPTION) DESC

Oracle Report Parameter LOV

Hi hussein, I have a customized Oracle Report for EBS 11i. My report sa "static" LOV and have static list of value 1 2 3 4 5 How do I register this LOV in the EBS 11i? I also have "select table" LOV. I know how to register this paramet

Dynamic table in Oracle report data model using laxical parameter is giving error Ora-00936: missing expression

Hi , I am using Oracle report 10G And trying to create report with dynamic table SELECT &COL1, &COL2 FROM &TAB If I put this on data model it gives below error ORA-00936: missing expression ==> from Can anybody advise to solve this issue. R

Lexical Parameter in report 10g

i want to call a report with few fields on my form. i create 2 user parameter which works fine. now i want to create a lexical parameter so that if null no problem report should appear with 2 user parameters but if has values then report should be ca

Changing Database Oracle Reports Connection.

Hi Fellows. I would like to know if it is possible to Change Oracle Reports Connection (Ver2.5) after the end user fill in the Parameter Form. I have about 21 agencies with a Database in each one and the end user have to choose the agency what he wan

Oracle report-how to change report layout to landscape?

Hi, I am using Oracle report 6i. I want to change the report layout to Landscape. I had tried to go to 'page setup' and changed to 'landscape', but when I print, I still got portait layout. Can anyone help me? Thanks. JunHi, Easiest method for changi

Lexical parameter in select statement showing null or column name in xml tag instead of value

Hi, i am using lexical parameter in report select statement as Select &order value from oe_order_headers_all a where order_number ='7889' and setting  : order:='a.order_number';  in after parameter form trigger. lexical parameter intial value set to

How to use dynamic parameter when a report is created using Stored Procedures

Hi all, any one have the idea of how to use dynamic parameter in crystal report XI R2 when report is created using Stored Procedure. Regards shashi kant chauhanHi You can create an SQL command in Database Expert > Expand your datasource > Add comman

Unable to start Oracle Reports Server for 10g version 10.1.2.3.0

Attention Oracle Reports Team or anyone else: I am unable to start the Oracle Reports Server for 10g version 10.1.2.3.0 of the Application Server. I have included the trace files see below. I marked the text in bold that might indicate the issues. An

Oracle Reports - Distributing Multiple Reports in a Management Report

Hi, I am new to Oracle Reports and would sincerely appreciate some guidance. Requirement. I plan on using Oracle Reports to write multiple reports containing Text, Graphs, Crosstabs, Tables etc. There are 3 developers and each will be developing a nu

Oracle Reports Download to Excel

Can my users download an Oracle report under 6.0 to MSExcel? Do I need to specify a particular report file format to facilitate this?hi there is a way to download to csv (comma seperated) file and that is by specifying the file format as DELIMITED an

Data Source for Oracle reports

Hi, Can Oracle Reports support anyother data source. I am using Reports Server to invoke reports. The requirement is client passing the dat that have to come in the report. (The size of data can be high).So is there any method other than sending the

HOW TO USE LEXICAL PARAMETER IN FORMS9I

CAN I USE LEXICAL PARAMETER IN FORMS9I I WANT TO CREATE QUERY LIKE THIS SELECT * FROM &TABLE_NAME WHERE &CHOICE WHERE &TABLE_NAME = EMP, AND &CHOICE EMPNO=12344 PLS HELPNo, you can do it in sqlplus or reports but not in forms. If this is a

Oracle Reports setup in Portal

Hey I just have a couple of questions about Oracle reports being run through Portal that I was looking for some help on. Here they are: I am using the Reports Portlet Parameter Form (which includes the 'Parameters' and 'Schedule' tabs) build into Por

How can i change the source code of current date in oracle reports

Hi All, How can i change the source of the current date to the sysdate of the database in oracle reports. I have more than 300 reports. is there any way to change quickly with opening each reports. I am working on reports11g on windows enviornment. T

Oracle Report Server Engine is getting stopped after starting.

Hello, Reports Engine is shutting down after starting. OS = Solaris 10 Application Server = Oracle 10gr2 *** 2011/1/4 3:59:34:723 -- Shutting down engine rwEng-0 *** 2011/1/4 3:59:34:726 -- Reports Server shut down engine rwEng-0 *** 2011/1/4 3:59:34

JAVA Application & Oracle Reports

How can I call a Report writen with Oracle Reports from a JAVA application? In C++ I create a process and call for excample r30run32.exe with a parameter. Thanks Martin nullMartin Leiacker (guest) wrote: : How can I call a Report writen with Oracle R