InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 23:19:08 GMT20http://www.sqlservercentral.com/Forums/Topic1153997-2668-1.aspxI Love the SIGN function...CASE WHEN fsq.SalesAmountQuota &gt; frs.SalesAmount THEN 1 ELSE CASE WHEN fsq.SalesAmountQuota = frs.SalesAmount THEN 0 ELSE -1 END END as TrendCan be replaced with:SIGN(fsq.SalesAmountQuota - frs.SalesAmount) as TrendIMNSOH, I think it is simpler :)Mon, 25 Mar 2013 15:54:45 GMTJohn_Phttp://www.sqlservercentral.com/Forums/Topic1153997-2668-1.aspxThere is a program (adventureworks2008_sr4.exe) that creates theDW database. I do not remember where I found it, but perhaps an internet search will help.Mon, 18 Mar 2013 09:55:12 GMTJAMESC2003http://www.sqlservercentral.com/Forums/Topic1153997-2668-1.aspxWonderful.Share a website with you ,( http://www.ccdeal.net/ )Believe you will love it.We accept any form of payment.Mon, 18 Mar 2013 09:47:48 GMTccdeal26http://www.sqlservercentral.com/Forums/Topic1153997-2668-1.aspxWonderful.Share a website with you ,( http://www.ccdeal.net/ )Believe you will love it.We accept any form of payment.Mon, 18 Mar 2013 09:47:33 GMTccdeal26http://www.sqlservercentral.com/Forums/Topic1153997-2668-1.aspxSo far so good, but now I have a problem with the Dashboard. I do not get the expandable groups. They are all expanded without the +/– control to expand/collapse the groups. It is just a static report with grid lines.Mon, 29 Oct 2012 12:34:04 GMTJediSQLhttp://www.sqlservercentral.com/Forums/Topic1153997-2668-1.aspxHi,I got the same thing, but then I read carefully. She says to use "AdventureWorksDW" not "AdventureWorksDW2008R2".Mon, 29 Oct 2012 12:28:42 GMTJediSQLhttp://www.sqlservercentral.com/Forums/Topic1153997-2668-1.aspxHiI had the same issue and replaced the line in the scriptinner join dbo.DimTime t on f.DueDateKey = t.TimeKey with INNER JOIN dbo.DimDate AS t ON f.DueDateKey = t.DateKeyhope this helpsWed, 12 Sep 2012 03:14:25 GMTsteve robertshttp://www.sqlservercentral.com/Forums/Topic1153997-2668-1.aspxHi. I've just done the Microsoft SSRS training course, and now that I'm back an work I'm trying to put a few things into practice.I've downloaded the Adventureworks2008R2 and AdventureWorkDW2008R2 databases and have been trying to work through your example. (It looks great BTW.)However, I haven't got very far... Your SQL in Figure 3, refers to a table that doesn't exist in the AdventureworksDW2008R2 database: dbo.DimTime. Exercises in SSRS training course Mod 4 refer to it, but none of the supplied scripts create it. Is this just a version difference? between 2008 and 2008R2 sample db's. Is there a script I need to run? Any help or suggestions would be greatly appreciated. CheersPeteWed, 15 Aug 2012 17:51:31 GMTthepotplantshttp://www.sqlservercentral.com/Forums/Topic1153997-2668-1.aspxGreat information and nice tutorial.Thu, 04 Aug 2011 09:38:43 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1153997-2668-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Stairway+Series/72651/">Designing a Dashboard - Level 6 in the Stairway to Reporting Services</A>[/B]Wed, 03 Aug 2011 22:55:34 GMTJessica M. Moss