How to display only top 10 results in a chart format

Question

2.00/5 (1 vote)

See more:

SQL

Hi
I am looking for some assistance on how to display ONLY the TOP 10 results say by Revenue.

For example I am running a query for lets say 30 customers over a given date range. Which returns the values for all the customers as required. However on the last page of the report I am looking to display the grand totals for the report along with graphs displaying the TOP 10 results ONLY.
Presently the graph displays all the results which is not what I am looking to achieve - I would appreciate any assistance on this

Kind Regards

Jack

Posted 18-Feb-14 1:25am

jchander4

Updated 18-Feb-14 1:27am

v2

Add a Solution

Comments

thatraja 18-Feb-14 7:40am

Include screenshots of chart

jchander4 18-Feb-14 8:24am

sorry for the delay was in a meeting please find picture on http://i.imgur.com/kUpME8n.png

any assistance will be appreciated. As you will see the results of the graph are displaying all the customers on the results however I only was to display the top 10 on the graphs only the rest of the report needs to remain as it displaying the results for each customer which are broken down by customer and date and then grand total for the whole report on the last page with graphs displaying graphical results

Many Thanks

thatraja 18-Feb-14 8:46am

Probably you have to apply filter like limiting rows on db side or report side. I don't know how you're generating reports? what tool? any coding? In Crystal reports, you could use formulas in chart settings

jchander4 18-Feb-14 8:54am

Hithe report is building records on all movements with details against each movement and then I summarise at change of date for each customer id and then a summary at the end of each customer with a grand total for the whole report at the end of the report when the graphs are displayed.
the groups I am using are
date
customer id
movement id
all the data being displayed is correct and the summary totals along with the grand totals display correctly too;
However the graphs at the end of the report I just wanted to display the top 10 for the whole report. that is where I am having difficulties and not sure how to attack the issue

thatraja 18-Feb-14 9:01am

Ok but still you didn't mention about tools & coding :| Share the chart related portion, atleast I could guess something

jchander4 18-Feb-14 9:13am

would you like to look at the report I could send it to you if that would help I am just Interrogating the database and building the report from that using various tables the summary totals are either built by sum formula or running totals. I am happy to send the report across if that would help

thatraja 18-Feb-14 9:22am

Is there any code involves with charts(or reports)?

jchander4 18-Feb-14 9:24am

hi
No the charts are displaying the results. Was not too sure how to attack the results with formulas hence the post

thatraja 18-Feb-14 9:32am

OK but the thing is I need code from UI side OR settings/formulas from reports side OR query from db side to ~~spot~~ guess the issue

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)