How to display ten 10 records in a 3D bar graph using SSRS 2008?

Hello,

   I have a dataset that contains records for counts by a deferral rate. I'm sorting the report by deferral rate in ascending order (smallest to largest). At the top of the report, I have a 3D bar graph. The category group for the bar graph is the deferral rate in ascending order. I have a end-user requesting to display only the top ten deferral rates in the bar graph. Is that possible? If so how is that done?  I'm using Microsoft reporting services 2008.

    I'm a beginner at SSRS so if you can explain in detail how to do that, I would appreciate it.

    If you have any questions jsut let me know.

Thanks for your help,
Ting
pensiongeniusAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Tony303Commented:
Are you able to do a "TOP 10" clause in your query with an order by?

This will show only the top 10 highest Deferral Rate entries.

So

SELECT Top 10 *
FROM YourTable
ORDER BY DEFERRAL RATE DESC
0
pensiongeniusAuthor Commented:
HI Tony303,

   I could but I wish it was that simple.

   I need all the records returned in the dataset to be used by the SSRS report to be displayed in the body of the report.  The end-user is requesting if possible to display the top 10 highest deferral rate entries in the 3D bar graph that displays at the top of the report. The category group for the bar graph is the deferral rate in ascending order. Is there a way for me to specify in the bar graph properties to display only the top 10 highest deferral rates? If so how would I do that? If not then is there another way to do this so that the bar graph only displays the 10 highest deferral rates?

     If you have more questions just let me know.

Thanks for your help,
Ting
0
Tony303Commented:
I think you should add a derived column in your query.
It is the Ranking of all the rows.

Use the RANK or DENSE RANK function...

http://www.sqlservercurry.com/2009/04/rank-vs-denserank-with-example-using.html


That way you can then filter your 3D Bar Graph by filtering the Ranking column <= 10.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Tony303Commented:
If you can't make changes to the source query as I suggested above, how about making a new dataset in your report that has the Top 10 records.

SELECT Top 10 *
FROM YourTable
ORDER BY DEFERRAL RATE DESC

Then use that dataset to feed your 3D Bar Graph.

Let me know how you get on.
0
Tony303Commented:
Hey,

I just had to do this for one of my own reports.
The secret is to filter the 3D Bar Graph.

You can choose your field Deferral Date and then in the operator use "Top N" and in the value put "10".

It works a treat...I love it.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pensiongeniusAuthor Commented:
Hi Tony303,

    Thanks for your most recent recommendation of filtering the 3D Bar Graph by choosing Deferral Rate then using 'Top N' for the operator and value of 10 and your previous recommendations.

    Before you posted your recent recommendation, I was trying different things with the 3D bar graph. I discovered the Top N operator for the filtering option and it worked. That is a great secret we both discovered.

    Thanks so much for all your help. Have a great day.

Regards,
Ting
0
pensiongeniusAuthor Commented:
Thanks Tony303,

   Great recommendation. It works perfectly.

Ting
0
Tony303Commented:
We're all learning every day!! Thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.