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

  • Hi Team,

    Thanks for giving reply.It is executing properly through procedure but as per my new requirement i am doing grouping for the one of the column to data set then it is giving result wrong .

    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 of sum of total ticketed by grouping of vendor names for Descending order of the data .

    If i select Top in that , then i was not entered any value then i checked check box is null it should returns for of sum of total ticketed by grouping of vendor names 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 of sum of total ticketed by grouping of vendor names for Ascending order of the data.

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

    If i select both top and bottom then it should returns of sum of total ticketed by grouping of vendor names for Descending order of the data

    How to give filter Bottom and Top operators in Group properties.

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

    Please refer to the attachments.

    I am looking for favorable reply from your side..

  • Please don't cross-post.

    No replies here please. Replies to http://www.sqlservercentral.com/Forums/Topic1606251-1632-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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