Creating a chart

Question

Creating a chart

the_justin

SSC Enthusiast

Points: 175
More actions
December 11, 2008 at 9:33 pm

#94612

Hi all,
I've a table which look like this:
id name team A B C D E F G H I J K L Total
1 greg A1 1 0 0 3 4 5 2 0 1 0 2 3 21
2 eric A2 0 2 3 1 0 2 1 0 2 0 1 3 15
i want to create a chart out of that table.
this is the cart i want it to be:
10
9
8 * = greg
7 ^ = eric
6
5 *
4 *
3 ^ * *
2 ^ ^ * *
1 * ^ ^ *
----^---*--*-----^-------*--^*--------------
A B C D E F G H I J K L
any idea of how to make this ? sorry if the graph is hard to understand.

Viewing 6 posts - 1 through 5 (of 5 total)

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

Mahesh Bote SSCrazy Eights Points: 9107 More actions · Answer 1

[font="Verdana"]Can't you use any reporting tools such as Crystal Report. I would suggest, queries should be to retrive data from DB and all the processing should be done at FE instead of BE.

Mahesh[/font]

MH-09-AM-8694

the_justin SSC Enthusiast Points: 175 More actions · Answer 2

Hi Mahesh, thanks for the reply.

Unfortunately, I can't use Cristal Report or any other technology. I have to do everything on the backend.

joao.rolo.sa Valued Member Points: 59 More actions · Answer 3

Can you use Reporting Services 2k5 or 2k8 ?

Or

do you want a TEXT BASED GRAF, with Prints 😉 :hehe:

Cheers

eicrd Grasshopper Points: 19 More actions · Answer 4

You can use FusionChart. It's easier to come out the chart but you should understand XML format.

the_justin SSC Enthusiast Points: 175 More actions · Answer 5

hi all, thanks for the replies.

I've managed to get around this problem by adding a new dataset (not really a solution, huh? ) that can easily be translated into a chart.

Thanks again for your time