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-19 : 07:01:18
|
| I have 4 seperate charts with a line on each, using 4 seperate dataset queries.But this is useless because you can't compare the interesting trends, if the 4 lines on the same chart!How do get those 4 datasets onto one place, each with subtly different conditions?I tried UNION / UNION ALL same columns - Year, Month, COUNT. Union is the incorrect syntax!Why can't I put each dataset as their own line on one chart?! That's what it's for!!! |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-03-19 : 07:08:40
|
| I am curious Mike, if you have any training in SS 2008, and business intelligence with this software. It seems you are shooting from the hip and implementing tasks with software you have no training in.In this example, you should be creating your dataset that includes all the data to place on one chart, rather than four. What is the distinguishing element for each line?______________________________________________Talk sense to a fool and he calls you foolish. |
 |
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2010-03-19 : 07:59:29
|
| 10 years with ORACLE and UNIX, Crystal Reports... no training - NO PROBLEMS!!! SQL Server and in Jan 2010, BIDS Training - SSIS, SSAS and SSRS. Wondering why anyone uses this stuff. Took me to learn ORACLE, UNIX & Crystal in < a month.You're suggesting you need training and experience to accomplish anything with Microsoft - at least 15 years? You're correct. The roots of this software is to return: error:aisuefhblaorfjkasebflkahsbeflksf. error:erbfhglkanblkalskfnh.. on and on.Put 4 lines on one chart. You need to be a rocket scientist first. I am - Cybernetics & Control Systems got me into engineering got me into producing hardware & software for results. Not software based on errors... "no, you can't do that"So do you have the solution to put 4 lines on a chart, once simply unioning 4 queries with the same columns together, and the result is:Msg 156, Level 15, State 1, Line 11Incorrect syntax near the keyword 'union'.Crystal. Just drag 4 results into a chart. 100, if you like |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-03-19 : 09:04:01
|
| If you think you have impressed me with your background, you have not. You clearly, by your numerous posts here, indicate you have no training(or read any documentation) in MS SS 2008 BI.The Sql Server 2008 Books online, has documentation on Reporting Services using Charts. I checked prior to leaving for the office this morning. Creating charts in Report Designer is quite easy. Go to Books online and read the section on Charts. A chart takes a single data source and plots the data. If you require multiple catagories of elements to chart, you need to retrieve this data in your query. This would be readily apparent.As a side point, Gartner Consulting recently released their annual report on Business Intelligence software and Microsoft's BI suite is highly rated software suite. If you are not aware who Gartner is, they are a highly respected management consulting group that has been around for over thirty years.http://www.gartner.com/technology/about.jspHere is a link to a web site call SQL Share that is hosted by a SQL Server consulting group. They have archives of instructional videos that are very good. Most are 2 to 5 minutes, some longer. If you hover your pointer over "Channels", you will see a "BI" selection.http://www.sqlshare.com/Default.aspxIf you are interested in Analysis Services another very informative web site is: http://www.ssas-info.com/Microsoft also hosts community forums where you can post questions. The forums are covered by MS technical staff and other non-MS experts. Here is a link to these forums. This link is in Visual Studio, but you should be able to navigate to find SS 2008 help/assistance:http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/1836ad6d-006b-4118-85ff-24b27f35ee02/______________________________________________Talk sense to a fool and he calls you foolish. |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2010-03-19 : 09:32:17
|
| I'll read yours after lunch. ThanksIt's the little things, when under pressure, than you can't union if each have ORDER BY in there. I knew that in '98, but sometimes it catches me out. All lovely. All in on chart! |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2010-03-19 : 09:34:09
|
| The posts are to test if any advice is available, and it seems not. I give Crystal Forum advice. I'll delete posts |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-03-19 : 09:37:37
|
| Good luck.______________________________________________Talk sense to a fool and he calls you foolish. |
|
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2010-03-19 : 11:00:08
|
| Anyway, it's very nice when I get more than 1 reply, and get to have a discussion.I unioned all 4 queries together, and all I get, as I'm wanting a count value, depending on Year / Month, as in a cross-tab, I see a wiggly line from 1989 to 2010, peaks and troughs. Interesting. But it's no good summing counts with a union, is it?I need the specific 4 counts - red, green, black and yellow lines all on ONE chart, so you can show the differences. So why doesn't RS allow more than one dataset in a chart? I've done this in gauges before (NOT SSRS) where each needle point at a different count per dataset. A gauge is an aggregated aggregation, isn't it - one overall value, as your mph in the car, changes over time? Need more time detail in a line on a 2D chart. Ahhh...! What if I label each count labelled differently... 1, 2 ,3, 4 ? Any ideas. Please? Anyone? |
|
|
|
|
|
|
|
|
Chart