September 3, 2014 at 5:58 am
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..
September 3, 2014 at 6:31 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply