Skip to Content
author's profile photo Former Member
Former Member

Can Report Sorting be changed via parameter?

Can the record sorting be changed/set by sending in parameters?

I am trying to give the user the option to sort by data Id vs. Description. My jsp parameters are being sent to the report just fine, but I don't see away to override the Record Sorting that is set on the report thru CR4E.

Is this possible or do I have to create a whole separate report for this solution?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 16, 2007 at 12:22 AM

    It looks like this would not be possible with the CR4E integrated report designer. If you have the CR Designer installed (full product), you could configure sorting based on some value you provide for a parameter field at runtime. If you do have the CR Designer, to make this work, you could create a formula field and a parameter field. The formula field uses the value from the Parameter field to sort the records. The value will simply be the field (ie: {table.field}) that you want to sort on.

    -MJ

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.