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 |
|
kullyg
Starting Member
6 Posts |
 Posted - 2012-08-28 : 05:46:39
|
hi i have a report that yields results like thisyear Week# month product2010 33 January chipsnow my problem i have to format the month to display just JAN, i am getting data from tables: please help i don't know how to do this kulgs |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-08-28 : 07:01:13
|
| What kind of reporting service are you using? If it is SSRS, you can change the expression to something like =Left(Fields!YourMonthCol.value,3).If you are doing this in SQL,you should be able to use the left function on the column. LEFT(YourMonthCol,3).If it is neither, can you post the query that you are currently using? |
 |
|
|
kullyg
Starting Member
6 Posts |
Posted - 2012-08-28 : 10:06:04
|
am using ssrs, thanx very much it worked.... now i have a problem with graphs i have to do 3 pie graphs 2012,2011, and 2010 i have no idea how its done, sorry guys i am new with sql .. i studied networking got an intern as a data analysit but am enjoying now only if i can just figure out sql... please help guys kulgs |
|
|
|
kullyg
Starting Member
6 Posts |
Posted - 2012-08-28 : 10:06:18
|
| am using ssrs, thanx very much it worked.... now i have a problem with graphs i have to do 3 pie graphs 2012,2011, and 2010 i have no idea how its done, sorry guys i am new with sql .. i studied networking got an intern as a data analysit but am enjoying now only if i can just figure out sql... please help guyskulgs |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-08-28 : 10:08:47
|
| If this is a presentation thing , why not do it at the presentation layer - or is Access your presentation layer?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-08-28 : 10:31:50
|
| MSDN has a few nice tutorials - take a look, and may be even work through the tutorial on pie charts. Once you are familiar with the mechanics of it, all you would really need to do is to change the query behind it to match your data. This is the link: http://msdn.microsoft.com/en-us/library/bb522859(v=sql.105).aspx |
|
|
|
kullyg
Starting Member
6 Posts |
Posted - 2012-08-29 : 03:09:08
|
| @jacky am using sql server 2005(ssrs). @ sunita thanx i will chheck it outkulgs |
|
|
|
|
|
|
|
|
sql 2005 month