Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Designing a Dashboard - Level 6 in the Stairway to Reporting Services Expand / Collapse
Author
Message
Posted Wednesday, August 3, 2011 10:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 23, 2014 12:40 PM
Points: 8, Visits: 357
Comments posted to this topic are about the item Designing a Dashboard - Level 6 in the Stairway to Reporting Services
Post #1153997
Posted Thursday, August 4, 2011 9:38 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 4:13 PM
Points: 17,940, Visits: 15,929
Great information and nice tutorial.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1154352
Posted Wednesday, August 15, 2012 5:51 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, November 3, 2014 5:40 PM
Points: 64, Visits: 324
Hi.

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.

Cheers

Pete
Post #1345614
Posted Wednesday, September 12, 2012 3:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 15, 2013 4:40 AM
Points: 49, Visits: 167
Hi
I had the same issue and replaced the line in the script

inner join dbo.DimTime t on f.DueDateKey = t.TimeKey

with

INNER JOIN dbo.DimDate AS t ON f.DueDateKey = t.DateKey

hope this helps
Post #1357851
Posted Monday, October 29, 2012 12:28 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 3, 2014 10:43 PM
Points: 49, Visits: 145
Hi,

I got the same thing, but then I read carefully. She says to use "AdventureWorksDW" not "AdventureWorksDW2008R2".


Sincerely,
Daniel
Post #1378404
Posted Monday, October 29, 2012 12:34 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, November 3, 2014 10:43 PM
Points: 49, Visits: 145
So 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.

Sincerely,
Daniel
Post #1378407
Posted Monday, March 18, 2013 9:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 18, 2013 9:45 AM
Points: 2, Visits: 0

Wonderful.

Share a website with you ,

( http://www.ccdeal.net/ )

Believe you will love it.

We accept any form of payment.
Post #1432236
Posted Monday, March 18, 2013 9:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 18, 2013 9:45 AM
Points: 2, Visits: 0
Wonderful.

Share a website with you ,

( http://www.ccdeal.net/ )

Believe you will love it.

We accept any form of payment.
Post #1432237
Posted Monday, March 18, 2013 9:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, July 7, 2013 3:58 PM
Points: 6, Visits: 68
There is a program (adventureworks2008_sr4.exe) that creates the
DW database. I do not remember where I found it, but perhaps
an internet search will help.
Post #1432240
Posted Monday, March 25, 2013 3:54 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 8, 2014 7:58 AM
Points: 13, Visits: 52
I Love the SIGN function...

CASE WHEN fsq.SalesAmountQuota > frs.SalesAmount
THEN 1 ELSE CASE WHEN fsq.SalesAmountQuota = frs.SalesAmount
THEN 0 ELSE -1 END
END as Trend

Can be replaced with:

SIGN(fsq.SalesAmountQuota - frs.SalesAmount) as Trend

IMNSOH, I think it is simpler :)
Post #1435194
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse