Creating a chart

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » Creating a chart

Creating a chart

Rate Topic

Display Mode

Topic Options

Author

Message

the_justin

Posted Thursday, December 11, 2008 9:33 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:46 PM
Points: 17, Visits: 133

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.

Post #618363

Mahesh Bote

Posted Friday, December 12, 2008 6:44 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, February 21, 2013 6:22 AM
Points: 1,074, Visits: 1,205

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

MH-09-AM-8694

Post #618546

the_justin

Posted Sunday, December 14, 2008 5:24 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:46 PM
Points: 17, Visits: 133

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.

Post #619356

joao.rolo.sa

Posted Wednesday, December 17, 2008 5:32 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, September 23, 2010 11:24 AM
Points: 35, Visits: 55

Can you use Reporting Services 2k5 or 2k8 ?

Or

do you want a TEXT BASED GRAF, with Prints ;) Hehe

Cheers

Post #621110

eicrd

Posted Wednesday, December 17, 2008 10:34 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 17, 2008 10:31 AM
Points: 1, Visits: 2

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

Post #621448

the_justin

Posted Wednesday, December 17, 2008 4:33 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:46 PM
Points: 17, Visits: 133

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

Post #621706

« Prev Topic | Next Topic »

Permissions