Results 1 to 5 of 5
  1. #1
    Join Date
    May 2003
    Posts
    45

    Unanswered: Sort order in Reports

    Can we change the sort order in reports during run time.

  2. #2
    Join Date
    Mar 2004
    Location
    Concord, MA
    Posts
    27

    Arrow Re: Sort order in Reports

    Originally posted by itsmanyam
    Can we change the sort order in reports during run time.
    you can if you add one parameter as 'Sort By' and then capture a value entered by the user during submission of th ereport. You can use a lexical parameter to pass the sort to your query in the report.
    ~bagchi

  3. #3
    Join Date
    May 2003
    Posts
    45
    I tried to create to Report parameter(:feild1) which a list which has all the column names related to the table used in the query....but it does not sort according to the way i selected ...i dont no why


    and what do u mean by lexical parameter

  4. #4
    Join Date
    Mar 2004
    Location
    Concord, MA
    Posts
    27
    define one place holder field in your report as l_order_by_clause and in your before report trigger do the following thing...

    let say the parameter that capturs the order by field is p_order_by

    l_order_by_clause := 'ORDER BY '|| p_order_by

    and add one line at the end of your report query as

    &l_order_by_clause

    hope this will work... not in touch with report for a while so not totally is the syntax given heer is absoutelu perfect or not....
    ~bagchi

  5. #5
    Join Date
    May 2003
    Posts
    45

    Thumbs up

    It just worked....thank you so much bagchi !!!!!!!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •