Yep, even have a parameter for TOP clause SELECT TOP(@par) FROM tbl ORDER BY .......Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

you can try putting a filter on your data set, for TOP N records.Gaurav Gupta http://sqlservermsbiblog.blogspot.com/ Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Hi, A 100% stacked bar chart compares the percentage each value contributes to a total across categories, this chart where multiple series are stacked vertically to fit 100% of the chart area, the x-axis shows a value of 0 to 100. When you set the minimum and maximum value is 0 to 1 (100%), the x-axis will show a value of 0 to 1, other category percent values are larger than this maximum value, so we can’t see all the data. I recommend that you set 100 to the maximum value or configure auto for the maximum value. When we set 100 to the maximum value, it means that the maximum value is 100 percent. For more information, please see: Bar Charts (Report Builder) http://msdn.microsoft.com/en-us/library/aa337331(v=SQL.90).aspx Thanks, Ai-Hua QiuAi-hua Qiu[MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi, I don’t think there is solution to show the label like 100%.I recommend that you add the description for these values. Thanks, Ai-Hua QiuAi-hua Qiu[MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi, Thanks for the reply @Uri Dimant i am filtering report with top n values @Ai-hua Qiu i want to show the label like 100%. all the values should display with in this 100% is there any way to do it? i tried but i can not able to find the solution Best Regards, C.Gnanadurai ----------------------- Please mark the post as answer if it is helpfull to you

Hi, I want to show TOP N records in 100% Stack bar chart.if i set the min and max value is 0 to 100% i can not see all the data in the stak bar.if i set min and max value auto then the max value become 10000% all data visible in the stack bar .but i want to show all the records with in 0 to 100% hope you under stand. Best Regards, C.Gnanadurai ----------------------- Please mark the post as answer if it is helpfull to you

Hi, did you try out the problem what i am posted.i can able to get the top n record when the max value is set to auto.but when i changed to 100% i can not able to get all the data.hope u under standBest Regards, C.Gnanadurai ----------------------- Please mark the post as answer if it is helpfull to you