Sorting by parameter 1

[fhurmuzlu]

I want to create parameter called Division sorted by Action date and Disposition date?
can we craete drop-down parameter?

Thanks

 

[lbass]

Please explain more specifically what you are trying to do. You can't sort on a parameter. You can use a parameter to limit records used for sorting though.

-LB

 

[kray4660]

You also can group by a formula (i.e. choose a field to group by) that is controlled by a parameter. It may not work for what you need. But it is a thought.

 

[fhurmuzlu]

I want to create a parameter that the user can see the report by division or Action Date or Disposition Date (user option)

 

[lbass]

Create a string parameter with the three options. Then create a formula like this:

select (?Parameter}
case "Division" : {table.division}
case "Action Date" : totext({table.actiondate},"yyyy/MM/dd")
case "Disposition Date" : totext({table.dispositiondate},"yyyy/MM/dd")

You can either use this as a sort field or use it as a group field. If you want the dates to display in a different format, use the above formula just for sorting or grouping, but add the actual field in the desired format to the group header or body of the report.

-LB