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) DESCRIPTION,
INITCAP(RELIEF) RELIEF,INITCAP(EXTENT) EXTENT,
DECREE_DATE,INITCAP(STATUS) STATUS,INITCAP( LOCATION) LOCATION,
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
October 11, 2015
View Thread Other 4 Replies on community.oracle.com
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 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
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
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
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
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-