Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 570
  • Last Modified:

RDLC Report with a Function Control Drop Down with "ascending or descending" option

I have a Microsoft Report that I am doing a value Count of the TOP 20 Agents.
I need to be able to do a "ascending or descending" type control option selection.

I know that Microsoft Report Tool has an option to add "ascending or descending" to each column, but I only want to do TOP 20 and Bottom 20 search. The current  option will sort all the Data. All i want to see is the TOP 20 and Bottom 20 Agent Count.
0
fjalbert
Asked:
fjalbert
1 Solution
 
dannygonzalez09Commented:
I'm afraid that's not possible unless you define a parameter filter in the report one for top 20 and other for bottom 20 and use that in the SQL where clause
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now