3 Replies Latest reply: Aug 28, 2013 4:39 AM by Priyasagi RSS

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

    851528

      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