I am a huge fan of SQLShare.com. The site publishes SQL server related videos. Easily go from ‘Zero to Hero’ with this site. Most videos range from 2-3 minutes. Topics range from advanced to beginners. The. It is easy to learn SSIS, SSAS, performance tuning, administration and other skills from top-tier presenters like Brian Knight, Andy Warren, Jessica Moss, Grant Fritchey and Devin Knight.
The complete searchable list of videos is here. The ‘Watch It later’ playlist is great. I would suggest subscribing to the site’s RSS feed for the latest videos. If you want to do more than watch, they have an open call for video authors. Submissions are reviewed prior to posting. If accepted, they will pay for the material. WIN!
Categories: Programming, Reporting/BI, SQL Server, SSRS, t-sql, Video Tags: Free, Learning, SQLServer, ssas, SSMS, SSRS, training, Video
Found this reference … JUST IN TIME!
Thanks Thavash
http://thavash.spaces.live.com/blog/cns!CF6232111374DFD2!155.entry
April 10
Working with Dates in Reporting Services
As with any other technology ( eg. SQL , C# ), you always find people running into problems with processing of dates. I was asked today by a colleague “How to I format dates when using the Date Picker and sending it through to a stored procedure” ? Let’s have a look ….
1) The FormatDateTime command
This is pretty easy to use, but maybe a bit limiting. You can specify 1 of 4 formats using the command arguments. Let’s say we have selected a date such as 10th April 2007 , our results will be as follows :
| Command |
Result |
| FormatDateTime(Parameters!Date.Value,1) |
Tuesday, April 10, 2007 |
| FormatDateTime(Parameters!Date.Value,2) |
4/10/2007 |
| FormatDateTime(Parameters!Date.Value,3) |
12:00:00 AM |
| FormatDateTime(Parameters!Date.Value,4) |
00:00 |
…but the better way to do it would be to use …
2) The Format command and specify the exact format you require. For example…
| Command |
Result |
| Format(Parameters!Date.Value,”dd-MM-yyyy”) |
10-04-2007 |
| Format(Parameters!Date.Value,”dd/MM/yyyy”) |
10/04/2007 |
| Format(Parameters!Date.Value,”MMM-dd-yyyy”) |
Apr-10-2007 |
| Format(Parameters!Date.Value,”MMM-dd-yy”) |
Apr-10-07 |
So 3 M’s give you “Apr” ….anyway this is quite useful if you’re looking for Day/Month/Year , since the system will default to MM/DD/YYYY.
Using this you should be able to display the date format you want , or send through a particular format to a Stored Proc.
EDITED 22/08/2007 : If the Format Command doesn’t work , try converting the value to a date , eg.
| Format(Cdate(Parameters!Date.Value),”dd-MM-yyyy”) |
Categories: DotNetNuke, OS, Programming, Reporting/BI, SQL Server, SSRS, t-sql Tags: Date format, DEVELOPER, How-to, Learning, SSRS
FROM Brian Knight @ pragmaticworks.com
Join SQL Server authors and MVPs for a week of warehousing and get the latest on Microsoft Business Intelligence inside your environment. If you are in any stage of a data warehouse design, administration or planning you won’t want to miss out on this free “week of warehousing” webinar series, free from SQLServerCentral.com and in partership with Wrox and Pragmatic Works. You may attend all five sessions if you wish or register for the sessions independently. Audio is provided either via a phone or over your computer speakers (voice over IP).
In this week of warehousing, you’ll learn how to design a data warehouse, load it using SSIS, place a cube on top of it using SSAS and report against it using SSRS. Finally, you’ll see how to performance tune and scale the data warehouse using common techniques. All speakers have authored many of your favorite books from Wrox (some speakers will be announced next week).
SQLServerCentral.com’s last webinar series had nearly 15,000 registered so register quick for one the morning or afternoon session to claim your spot!
Read more…
Found this link that give a deep-dive into fomat and functionality of charts in SSRS 2005. Adds a lot to making charts meaniningful and jumps to details.
TechNet Article:
More