How to give top and bottom filter expressions in one data set

  • Hi Team,

    This is Naveen Maroju.I am trying to do but m not getting please help me on this scenario.

    I have a parameter called "VendorOrder", that parameter has two available values 1. Top 2. Bottom

    If I select Top in that , then i should enter "Limit to top parameter" parameter value is 10 or give any value then

    should display 10 or given value rows of Top or

    If i select Top in that , then i was not entered any value then i checked check box is null it should returns for Descending order of the data.

    If i select Bottom then i should enter "Limit to top parameter" parameter value is 10 or give any value then should display the Bottom 10 or given values rows of Bottom to the data set.

    If i select Bottom in that , then i was not entered any value then i checked check box is null it should returns for Ascending order of the data.

    If i select both top and bottom then it should returns for Descending order of the data

    How can i do this. any information will be helpful.

    Please refer to the attachment.

  • Duplicate post, please post answers here, http://www.sqlservercentral.com/Forums/Topic1606251-1632-1.aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply