Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2010-03-15 : 08:50:05
|
| Can I put different dataset results into one graph? A line per dataset?Must ANY one, single dataset be the only data that can be displyed on one graph??Big Thanks!! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-15 : 10:29:44
|
| is there a way by which you can merge datasets to one?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2010-03-15 : 11:12:19
|
| why does SSRS rely on one dataset? That's a closed mind! Made by Bill Gates. All monkeys. Crystal Reports gets any field from any query, SP, view, anything - anywhere. Crystal does it's grouping for itself at application level. Fields from any SERVER - Oracle, PostgreSQL...Everything we do is restricted by Microsoft's sad software. We have to put all our eggs in one basket; one dataset per graph. Can you put more than one dataset in a report?Mummy, can I have a chocolate bar? Only if it's sold by Microsoft!Programmer, can I press this button? No, because I like to laugh at you |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-03-15 : 12:09:43
|
quote:
Originally posted by mikebird
why does SSRS rely on one dataset? That's a closed mind! Made by Bill Gates. All monkeys. Crystal Reports gets any field from any query, SP, view, anything - anywhere. Crystal does it's grouping for itself at application level. Fields from any SERVER - Oracle, PostgreSQL...Everything we do is restricted by Microsoft's sad software. We have to put all our eggs in one basket; one dataset per graph. Can you put more than one dataset in a report?Mummy, can I have a chocolate bar? Only if it's sold by Microsoft!Programmer, can I press this button? No, because I like to laugh at you
If you want to show values in a graph dont you need some kind of relation b/w them. If they are in different datasets how will you determined how they're related?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2010-03-16 : 07:56:33
|
| Sure. But I want to produce 4 graphs with conditions: missing data in DW, yes or no... then correct data in DW, yes or no. So four datasets, each running an individual query. Then put those four lines on ONE graph!!!! Why having to fiddle like a monkey to design a query with deeply nested group? Each dataset produces a final count which changes so much throughout the last 20 years - each so different - wiggly for particular periods... You wanna see that on four seperate charts? Uhhh... NO!! I want to COMPARE the lines on the SAME graph! Well done Bill Gates. Sell crap software and everyone buys it.I'm gonna try a new business. Selling to the Fast Food Market. Say it's such good quality in this land. They open the cardboard box to eat it, and what do you get to eat? Just cardboard. Ha ha. Lucrative business, based on Gates' method, buyers are all sheep. Did he intend that plan? It has worked beautifully. Or did his method of software development become so bad.... he's still laughing...Try Richard Branson's planes, trains, communications and the galaxy... All sheep.... my mate said it was good. I will go buy |
|
|
|
|
|
|
|
|
Datasets in Graphs / Guages