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

Advertisement

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) DESCRIPTION,
INITCAP(RELIEF) RELIEF,INITCAP(EXTENT) EXTENT,
DECREE_DATE,INITCAP(STATUS) STATUS,INITCAP( LOCATION) LOCATION,
LEGAL_FILE_NO, MSNO
FROM L_CASE_MASTER_MAIN
WHERE to_char(NEXT_HEARING_DATE,'DD-MON-YYYY')=:P_NHD ORDER BY :P_COL
and i created parameter form for these two bind variables :P_NHD,:P_COL
in,:P_COL i wrote lov as Select trim(COLUMN_NAME) from user_tab_columns where table_name='L_CASE_MASTER_MAIN'  to get all the columns.
in parameter form i am able to get all the columns but when i am generating report it is not giving results as per my ordered column.
kindly let me know the solution
Report Version :Oracle Reports 11g
Db Version:Oracle  11g

Advertisement

Hi,
Ordering the column first takes place from the Data Model Itself.
Please Check your column ordering in the report data model. If it is not ordered in a right way then Rearrange it.
Remove your order by in query...
If any issues... let me know
Regards,
Soofi

October 11, 2015

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

Not getting Reports Parameter Form in web-forms environ

I am not able to get a report parameter form to appear for a report called from forms via a 'run_product' command. It works fine in client/server mode. In web-forms the report just goes ahead and runs without the needed parameters. I have tried expli

PAM-KRB5: account:  unable to get host based service name for realm

I want a custom service to authenticate via PAM with Microsoft Active Directory Services on Windows 2003. kinit appears to work: Myserver% klist Ticket cache: /tmp/krb5cc_200 Default principal: [email protected] Valid starting Expires Service princip

How to get the field row name of database from a form?

Hello experts, I am newer in OIM and developments with the API's. I have this environment, one resource that have the attribute department relationship with the database row UD_RESOURCE1_DEPARTMENT and other resource with the same attribute in, UD_RE

Getting the system generated column name for xmltype column

Hello, how i can get the internal column name (p.a. SYS_NC00001$) for a xmltype column? I cannot find a correct dictionary view . I need that for moving a xmltype lob partition to another tablespace. Thanks, MaikRDoes the following help: http://www.i

XL Reporter error"'Report initialize:unable to get document"

Does excel 2010 compatible on XL Reporter? If yes, can some give me idea on how work on it? coz we install office 2010,I already enabled the macros and check the 'trust access to the vba project oblect model on the trust center of excel. When we trie

I need the "Real" Table / Table Column names from a sql view

Firstly, we have a system with ~1000 tables and ~250 views.  We have field level security on the table columns (in our code) Now we have a lot of views which select data from the tables, but I need to get the "Table Column Name" that is linked i

Order by in Parameter form for a formula col

Hi, I have made a report for fast moving products and have ordered by on a formula column. Is there any way to select the order by (ascending or descending) in the parameter form at runtime for the same formula column. Instead of making two different

Detecting column name and value from a xml

Dear all, I need to create a procedure to get a xml file. The xml file may contain a table data or procedure parameter value. Off course it will also contain a flag if the data is of a procedure or table nnd then it's table or procedure name, column

Invalid column name in query string - using Format function

In my post just before this one the problem was solved for writing a query string using a date range. The rest of the query string includes the same date field (Call_Date) but formatted as 'MMM-YY'. I get an invalid column name error when I add this

Invalid column name in WLS 6.1 sp4

We have been using WLS 6.1 sp2 with toplink and never had any problems. Recently we migrated to sp4 and get a invalid column name exception while updating records. For select queries there is no error. The SQL generated by toplink is - UPDATE PR_SUPP

How to get required tags and name spaces in the output File?

Hello, I am doing IDOC to File sceanrio and I am able to get the file but the problem is that I am unable to get the required tag names. Out put file is having  ns0 ns1 and so on.. Eg: ns2:MaterialDefinitionProperty><ns2:MaterialDefinitionProperty&g

Column name in user_ind_columns, all_ind_columns

The oracle data dictionary seems to assign a new system generated name (for example 'SYS_NC00008$') to index columns where the descend value = 'DESC'; SQL> select index_name, index_owner, column_name, descend from all_ind_columns where descend = 'DES

JAVA-SAX-Xml how to get simple tag element names to a list

i need to get the simple tag names(here it is name,price,aname,city) in to a list i have heard about SAX parser event driven it walks throgh the xml step by step when a new tag occurs it will parse etc.... but i am unable to get the only sampletag na

Dynamically Using  XML Element name as column names

I have a requirement where I need to show data for 31 days or days of the month based on the data in the xml result. Based on the month you are running the report, some may have 28 elements and some may have 31 elements in the data for days. How do I

My company ordered my iPhone 6 Plus on 9/25 and I am unable to get an order number. Is it possible to get an estimated shipping date?

My company ordered my iPhone 6 Plus 16GB on my behalf on 9/25. I am unable to get an order # from them so I can't track it. Is it possible to get an estimated shipping date? I see that today for orders being made it's 11/13, but hopefully since it wa

Unable to get the "Alerts" in the bi dashboard

Hi experts, I am using Oracle business intelligence standard edition one version, I am using Delivers to send Email. I did all the configuration successfully and I am able send the email. But unable to get the "Alerts" anywhere in the dashboard

PLEASE HELP ME??? Lost itunes trying to downgrade back from 11.0 & unable to get itunes to work at all now..

New Itunes setup is the worst one yet!!! I couldn't stand it, so I tried uninstalling it and reinstalling older versions, but now I am unable to get it to work in any version. I have uninstalled & reinstalled several times (trying this with multiple

EA2 - strange column order in "Columns" tab

Hi, when I click on a table in the left panel, I'd expect the columns in the "Columns" tab appear in the same order as the table has been defined (i.e. ordered by column id). But instead the columns are ordered by primary key. Of course I can do

Unable to get Material No and Description from VBAP

Hi Gurus Can anyone please help me to get material number and description from vbap table, The report is fine but I am unable to get material no and description. regards report ZCHGDOC_BY_SALES no standard page heading                           line-