Free Tutorial in Indicators in SSRS 2008 R2
Part one of a four-part series of blogs

Indicators are one of the nicest new features of SSRS 2008 R2 (or SQL Server Reporting Services, to give the software its full name). This blog shows how to add indicators to a table, format them and set scaling correctly.

  1. Indicators in SQL Server in Reporting Services (this blog)
  2. Creating Indicators in Reporting Services
  3. Scaling of Indicators in Reporting Services
  4. Formatting Indicators (Gauge Panels)

Posted by Andy Brown on 25 July 2011 | 2 comments

Free Tutorial on SSRS Reporting Services Indicators

Indicators were introduced in SQL Server Reporting Services 2008 to provide visual representations of the relative size of data.  Here's an example:

Example of report using indicators

In this example, the longer the film, the more filled-in the star

 

For most of this blog we'll be creating the example report above, in which stars are shown as follows:

Length of film Star
Up to 2 hours (less than 120 minutes) Empty
2 to 3 hours (120-180 minutes) Half filled in
3 hours + (more than 180 minutes) Filled in

You can run the following script to create a new database called TopMovies in your SQL Server installation, containing a single table called tblMovie:

-- All code and data belongs to Wise Owl, and must not be reproduced or distributed

-- in any way without prior written permission. Use this code at your own risk.

--

USE Master

GO

-- drop database if exists

BEGIN TRY

DROP Database TopMovies

END TRY

BEGIN CATCH

-- database can't exist

END CATCH

-- create new database

CREATE DATABASE TopMovies

go

USE TopMovies

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET NOCOUNT ON

GO

CREATE TABLE [dbo].[tblMovie](

[MovieName] [nvarchar](255) NULL,

[ReleaseDate] [datetime] NULL,

[Length] [int] NULL,

[Oscars] [int] NULL,

[Director] [nvarchar](255) NULL

) ON [PRIMARY]

GO

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Jurassic Park', CAST(0x0000857400000000 AS DateTime), 127, 3, N'Steven Spielberg')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'War of the Worlds', CAST(0x0000968400000000 AS DateTime), 116, 0, N'Steven Spielberg')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Minority Report', CAST(0x0000923F00000000 AS DateTime), 145, 0, N'Steven Spielberg')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Munich', CAST(0x0000975600000000 AS DateTime), 164, 0, N'Steven Spielberg')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Saving Private Ryan', CAST(0x00008CCF00000000 AS DateTime), 170, 5, N'Steven Spielberg')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Indiana Jones and the Last Crusade', CAST(0x00007FAF00000000 AS DateTime), 127, 1, N'Steven Spielberg')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Indiana Jones and the Temple of Doom', CAST(0x0000787E00000000 AS DateTime), 118, 1, N'Steven Spielberg')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Schindler''s List', CAST(0x0000864D00000000 AS DateTime), 195, 7, N'Steven Spielberg')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Raiders of the Lost Ark', CAST(0x0000746300000000 AS DateTime), 115, 4, N'Steven Spielberg')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'E.T.: The Extra-Terrestrial', CAST(0x0000765400000000 AS DateTime), 115, 4, N'Steven Spielberg')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Fargo', CAST(0x0000898E00000000 AS DateTime), 98, 2, N'Joel Coen')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'O Brother, Where Art Thou?', CAST(0x00008FAE00000000 AS DateTime), 107, 0, N'Joel Coen')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Intolerable Cruelty', CAST(0x0000941C00000000 AS DateTime), 100, 0, N'Joel Coen')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Star Wars: Episode I - The Phantom Menace', CAST(0x00008E0300000000 AS DateTime), 133, 0, N'George Lucas')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Star Wars: Episode III - Revenge of the Sith', CAST(0x0000965900000000 AS DateTime), 140, 0, N'George Lucas')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Star Wars: Episode II - Attack of the Clones', CAST(0x0000920E00000000 AS DateTime), 142, 0, N'George Lucas')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Star Wars: Episode IV - A New Hope', CAST(0x00006F4400000000 AS DateTime), 121, 6, N'George Lucas')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Crouching Tiger, Hidden Dragon', CAST(0x0000901E00000000 AS DateTime), 120, 4, N'Ang Lee')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Brokeback Mountain', CAST(0x0000974800000000 AS DateTime), 134, 3, N'Ang Lee')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Hulk', CAST(0x000093BA00000000 AS DateTime), 138, 0, N'Ang Lee')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Sense and Sensibility', CAST(0x0000892C00000000 AS DateTime), 136, 1, N'Ang Lee')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Ride with the Devil', CAST(0x00008E7300000000 AS DateTime), 138, 0, N'Ang Lee')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Raging Bull', CAST(0x000073F400000000 AS DateTime), 129, 2, N'Martin Scorsese')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Goodfellas', CAST(0x0000816D00000000 AS DateTime), 145, 1, N'Martin Scorsese')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Aviator', CAST(0x000095D400000000 AS DateTime), 170, 5, N'Martin Scorsese')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Gangs of New York', CAST(0x000092FC00000000 AS DateTime), 167, 0, N'Martin Scorsese')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Departed', CAST(0x0000985200000000 AS DateTime), 151, 4, N'Martin Scorsese')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Casino', CAST(0x0000892C00000000 AS DateTime), 178, 0, N'Martin Scorsese')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Million Dollar Baby', CAST(0x000095DC00000000 AS DateTime), 132, 4, N'Clint Eastwood')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Flags of our Fathers', CAST(0x0000989F00000000 AS DateTime), 132, 0, N'Clint Eastwood')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'High Plains Drifter', CAST(0x0000691000000000 AS DateTime), 105, 0, N'Clint Eastwood')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Letters from Iwo Jima', CAST(0x000098DE00000000 AS DateTime), 141, 1, N'Clint Eastwood')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Pale Rider', CAST(0x000079F800000000 AS DateTime), 116, 0, N'Clint Eastwood')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Spider-Man 3', CAST(0x0000992400000000 AS DateTime), 139, 0, N'Sam Raimi')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Spider-Man 2', CAST(0x0000952600000000 AS DateTime), 127, 1, N'Sam Raimi')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Spider-Man', CAST(0x0000922B00000000 AS DateTime), 121, 0, N'Sam Raimi')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'King Kong', CAST(0x0000972B00000000 AS DateTime), 187, 3, N'Peter Jackson')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Lord of the Rings: Return of the King', CAST(0x0000945200000000 AS DateTime), 201, 11, N'Peter Jackson')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Lord of the Rings: The Two Towers', CAST(0x000092E600000000 AS DateTime), 179, 2, N'Peter Jackson')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Lord of the Rings: Fellowship of the Ring', CAST(0x0000917A00000000 AS DateTime), 178, 4, N'Peter Jackson')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Superman Returns', CAST(0x0000980000000000 AS DateTime), 154, 0, N'Bryan Singer')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'X-Men', CAST(0x00008F9200000000 AS DateTime), 104, 0, N'Bryan Singer')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'X2', CAST(0x0000936C00000000 AS DateTime), 133, 0, N'Bryan Singer')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Usual Suspects', CAST(0x0000887600000000 AS DateTime), 106, 2, N'Bryan Singer')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Terminator', CAST(0x0000795000000000 AS DateTime), 108, 0, N'James Cameron')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Aliens', CAST(0x00007BA300000000 AS DateTime), 137, 2, N'James Cameron')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Abyss', CAST(0x0000801800000000 AS DateTime), 138, 1, N'James Cameron')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Titanic', CAST(0x00008BE800000000 AS DateTime), 194, 11, N'James Cameron')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'True Lies', CAST(0x000086FC00000000 AS DateTime), 141, 0, N'James Cameron')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Terminator 2: Judgement Day', CAST(0x000082B800000000 AS DateTime), 137, 6, N'James Cameron')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Evan Almighty', CAST(0x0000997F00000000 AS DateTime), 95, 0, N'Tom Shadyac')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Bruce Almighty', CAST(0x000093A500000000 AS DateTime), 101, 0, N'Tom Shadyac')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Robin Hood: Prince of Thieves', CAST(0x0000829C00000000 AS DateTime), 143, 0, N'Kevin Reynolds')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Waterworld', CAST(0x0000886800000000 AS DateTime), 136, 0, N'Kevin Reynolds')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Pearl Harbor', CAST(0x000090B100000000 AS DateTime), 183, 1, N'Michael Bay')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Transformers', CAST(0x0000997800000000 AS DateTime), 144, 0, N'Michael Bay')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Armageddon', CAST(0x00008CAC00000000 AS DateTime), 150, 0, N'Michael Bay')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Rock', CAST(0x000089A300000000 AS DateTime), 136, 0, N'Michael Bay')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Harry Potter and the Order of the Phoenix', CAST(0x0000996900000000 AS DateTime), 138, 0, N'David Yates')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Beowulf', CAST(0x000099E800000000 AS DateTime), 113, 0, N'Robert Zemeckis')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Cast Away', CAST(0x0000902500000000 AS DateTime), 143, 0, N'Robert Zemeckis')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Who Framed Roger Rabbit?', CAST(0x00007EDD00000000 AS DateTime), 104, 0, N'Robert Zemeckis')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Back to the Future', CAST(0x00007A9700000000 AS DateTime), 117, 1, N'Robert Zemeckis')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Back to the Future Part III', CAST(0x0000812700000000 AS DateTime), 118, 0, N'Robert Zemeckis')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Back to the Future Part II', CAST(0x0000804200000000 AS DateTime), 108, 0, N'Robert Zemeckis')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Bee Movie', CAST(0x00009A0400000000 AS DateTime), 90, 0, N'Steve Hickner')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Pirates of the Caribbean: At World''s End', CAST(0x0000993800000000 AS DateTime), 168, 0, N'Gore Verbinski')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Pirates of the Caribbean: Dead Man''s Chest', CAST(0x000097F600000000 AS DateTime), 150, 1, N'Gore Verbinski')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Pirates of the Caribbean: Curse of the Black Pearl', CAST(0x000093CF00000000 AS DateTime), 143, 0, N'Gore Verbinski')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'I am Legend', CAST(0x00009A1000000000 AS DateTime), 101, 0, N'Francis Lawrence')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Constantine', CAST(0x0000961B00000000 AS DateTime), 121, 0, N'Francis Lawrence')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Ratatouille', CAST(0x000099C500000000 AS DateTime), 106, 1, N'Brad Bird')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Troy', CAST(0x000094EE00000000 AS DateTime), 163, 0, N'Wolfgang Peterson')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Perfect Storm', CAST(0x00008F7D00000000 AS DateTime), 130, 0, N'Wolfgang Peterson')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Das Boot', CAST(0x0000752600000000 AS DateTime), 149, 0, N'Wolfgang Peterson')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Four Weddings and a Funeral', CAST(0x000086A100000000 AS DateTime), 117, 0, N'Mike Newell')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Harry Potter and the Goblet of Fire', CAST(0x0000971000000000 AS DateTime), 157, 0, N'Mike Newell')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Batman Begins', CAST(0x0000967500000000 AS DateTime), 140, 0, N'Christopher Nolan')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Prestige', CAST(0x0000987500000000 AS DateTime), 130, 0, N'Christopher Nolan')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Memento', CAST(0x00008FD100000000 AS DateTime), 113, 0, N'Christopher Nolan')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Sleepy Hollow', CAST(0x00008EB200000000 AS DateTime), 105, 1, N'Tim Burton')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Charlie and the Chocolate Factory', CAST(0x000096A000000000 AS DateTime), 115, 0, N'Tim Burton')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Die Another Day', CAST(0x000092CA00000000 AS DateTime), 133, 0, N'Lee Tamahori')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Once Were Warriors', CAST(0x000087F100000000 AS DateTime), 99, 0, N'Lee Tamahori')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Lethal Weapon 3', CAST(0x0000842400000000 AS DateTime), 118, 0, N'Richard Donner')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Lethal Weapon', CAST(0x00007D0F00000000 AS DateTime), 110, 0, N'Richard Donner')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Lethal Weapon 2', CAST(0x00007FFC00000000 AS DateTime), 114, 0, N'Richard Donner')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Lethal Weapon 4', CAST(0x00008CD600000000 AS DateTime), 127, 0, N'Richard Donner')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Superman', CAST(0x000070AB00000000 AS DateTime), 143, 0, N'Richard Donner')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Men in Black 2', CAST(0x0000925C00000000 AS DateTime), 88, 0, N'Barry Sonnenfeld')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Men in Black', CAST(0x00008B3900000000 AS DateTime), 98, 1, N'Barry Sonnenfeld')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Get Shorty', CAST(0x0000894100000000 AS DateTime), 105, 0, N'Barry Sonnenfeld')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Stealth', CAST(0x000096A700000000 AS DateTime), 121, 0, N'Rob Cohen')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'xXx', CAST(0x000092A800000000 AS DateTime), 124, 0, N'Rob Cohen')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Final Fantasy: The Spirits Within', CAST(0x000090F000000000 AS DateTime), 106, 0, N'Hironobu Sakaguchi')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Miami Vice', CAST(0x0000981300000000 AS DateTime), 134, 0, N'Michael Mann')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Ali', CAST(0x000091BB00000000 AS DateTime), 157, 0, N'Michael Mann')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Last of the Mohicans', CAST(0x0000847800000000 AS DateTime), 112, 1, N'Michael Mann')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Collateral', CAST(0x0000956500000000 AS DateTime), 120, 0, N'Michael Mann')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The World Is Not Enough', CAST(0x00008E8800000000 AS DateTime), 128, 0, N'Michael Apted')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Master and Commander: The Far Side of the World', CAST(0x0000943F00000000 AS DateTime), 138, 2, N'Peter Weir')

GO

print 'Processed 100 total records'

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Truman Show', CAST(0x00008CEB00000000 AS DateTime), 103, 0, N'Peter Weir')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Bourne Supremacy', CAST(0x0000954200000000 AS DateTime), 108, 0, N'Paul Greengrass')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Bourne Ultimatum', CAST(0x0000998D00000000 AS DateTime), 115, 3, N'Paul Greengrass')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Harry Potter and the Prisoner of Azkaban', CAST(0x000094F800000000 AS DateTime), 141, 0, N'Alfonso Cuaron')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Children of Men', CAST(0x0000984400000000 AS DateTime), 109, 0, N'Alfonso Cuaron')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Matrix', CAST(0x00008DE000000000 AS DateTime), 136, 4, N'Andy Wachowski')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Matrix Reloaded', CAST(0x0000938000000000 AS DateTime), 138, 0, N'Andy Wachowski')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Matrix Revolutions', CAST(0x0000942800000000 AS DateTime), 129, 0, N'Andy Wachowski')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Da Vinci Code', CAST(0x000097C600000000 AS DateTime), 149, 0, N'Ron Howard')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Apollo 13', CAST(0x0000889200000000 AS DateTime), 140, 2, N'Ron Howard')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Cinderella Man', CAST(0x000096CA00000000 AS DateTime), 144, 0, N'Ron Howard')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'A Beautiful Mind', CAST(0x000091BB00000000 AS DateTime), 135, 4, N'Ron Howard')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Harry Potter and the Philosopher''s Stone', CAST(0x0000915900000000 AS DateTime), 152, 0, N'Chris Columbus')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Harry Potter and the Chamber of Secrets', CAST(0x000092C500000000 AS DateTime), 161, 0, N'Chris Columbus')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Day After Tomorrow', CAST(0x000094F400000000 AS DateTime), 124, 0, N'Roland Emmerich')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Independence Day', CAST(0x000089D400000000 AS DateTime), 145, 1, N'Roland Emmerich')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Blood Diamond', CAST(0x000098C200000000 AS DateTime), 143, 0, N'Edward Zwick')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Last Samurai', CAST(0x0000946900000000 AS DateTime), 154, 0, N'Edward Zwick')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Mission: Impossible III', CAST(0x000097B700000000 AS DateTime), 126, 0, N'J. J. Abrams')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Mission: Impossible II', CAST(0x00008F6800000000 AS DateTime), 123, 0, N'John Woo')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Windtalkers', CAST(0x0000927800000000 AS DateTime), 134, 0, N'John Woo')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Monsters, Inc.', CAST(0x000091AD00000000 AS DateTime), 92, 1, N'Pete Docter')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Tomorrow Never Dies', CAST(0x00008BBE00000000 AS DateTime), 119, 0, N'Roger Spottiswoode')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Ocean''s Eleven', CAST(0x000091B400000000 AS DateTime), 116, 0, N'Steven Soderbergh')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Ocean''s Twelve', CAST(0x000095F100000000 AS DateTime), 125, 0, N'Steven Soderbergh')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Live Free or Die Hard', CAST(0x0000996100000000 AS DateTime), 130, 0, N'Len Wiseman')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Around the World in 80 Days', CAST(0x0000951F00000000 AS DateTime), 120, 0, N'Frank Coraci')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Click', CAST(0x0000984B00000000 AS DateTime), 107, 0, N'Frank Coraci')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Kingdom of Heaven', CAST(0x0000964C00000000 AS DateTime), 145, 0, N'Ridley Scott')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Gladiator', CAST(0x00008F3000000000 AS DateTime), 155, 5, N'Ridley Scott')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Black Hawk Down', CAST(0x0000919800000000 AS DateTime), 144, 2, N'Ridley Scott')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'American Gangster', CAST(0x000099E800000000 AS DateTime), 157, 0, N'Ridley Scott')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Blade Runner', CAST(0x000075F900000000 AS DateTime), 117, 0, N'Ridley Scott')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Alien', CAST(0x000071AE00000000 AS DateTime), 117, 1, N'Ridley Scott')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Mr. and Mrs. Smith', CAST(0x0000966F00000000 AS DateTime), 120, 0, N'Doug Liman')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Bourne Identity', CAST(0x0000927F00000000 AS DateTime), 119, 0, N'Doug Liman')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'I, Robot', CAST(0x0000953B00000000 AS DateTime), 115, 0, N'Alex Proyas')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Casino Royale', CAST(0x0000987B00000000 AS DateTime), 144, 0, N'Martin Campbell')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'GoldenEye', CAST(0x000088D100000000 AS DateTime), 130, 0, N'Martin Campbell')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Catwoman', CAST(0x0000954200000000 AS DateTime), 104, 0, N'Jean-Christophe Comar')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Fifth Element', CAST(0x00008B0100000000 AS DateTime), 126, 0, N'Luc Besson')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Leon', CAST(0x000087AB00000000 AS DateTime), 110, 0, N'Luc Besson')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Rush Hour', CAST(0x00008D2300000000 AS DateTime), 97, 0, N'Brett Ratner')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Rush Hour 3', CAST(0x0000998600000000 AS DateTime), 91, 0, N'Brett Ratner')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Rush Hour 2', CAST(0x000090F000000000 AS DateTime), 90, 0, N'Brett Ratner')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Die Hard: With A Vengeance', CAST(0x0000886F00000000 AS DateTime), 131, 0, N'John McTiernan')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Last Action Hero', CAST(0x0000858200000000 AS DateTime), 130, 0, N'John McTiernan')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Die Hard', CAST(0x00007F1C00000000 AS DateTime), 131, 0, N'John McTiernan')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Hunt For Red October', CAST(0x000080D500000000 AS DateTime), 134, 1, N'John McTiernan')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Scarface', CAST(0x000077C100000000 AS DateTime), 170, 0, N'Brian De Palma')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Untouchables', CAST(0x00007D2400000000 AS DateTime), 119, 1, N'Brian De Palma')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Mission: Impossible', CAST(0x000089B100000000 AS DateTime), 110, 0, N'Brian De Palma')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Black Dahlia', CAST(0x0000983D00000000 AS DateTime), 121, 0, N'Brian De Palma')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Deep Impact', CAST(0x00008C5800000000 AS DateTime), 120, 0, N'Mimi Leder')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Road to Perdition', CAST(0x0000929400000000 AS DateTime), 117, 1, N'Sam Mendes')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Jarhead', CAST(0x0000974800000000 AS DateTime), 125, 0, N'Sam Mendes')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'American Beauty', CAST(0x00008ECE00000000 AS DateTime), 122, 5, N'Sam Mendes')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Village', CAST(0x0000954900000000 AS DateTime), 108, 0, N'M. Night Shyamalan')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Unbreakable', CAST(0x0000901700000000 AS DateTime), 106, 0, N'M. Night Shyamalan')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Talladega Nights: The Ballad of Ricky Bobby', CAST(0x0000983D00000000 AS DateTime), 108, 0, N'Adam McKay')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Anchorman: The Legend of Ron Burgundy', CAST(0x0000955E00000000 AS DateTime), 94, 0, N'Adam McKay')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Simpsons Movie', CAST(0x0000997600000000 AS DateTime), 87, 0, N'David Silverman')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Braveheart', CAST(0x0000888400000000 AS DateTime), 177, 5, N'Mel Gibson')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Apocalypto', CAST(0x000098AD00000000 AS DateTime), 139, 0, N'Mel Gibson')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Passion of the Christ', CAST(0x000094B600000000 AS DateTime), 127, 0, N'Mel Gibson')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Shrek the Third', CAST(0x0000995C00000000 AS DateTime), 92, 0, N'Chris Miller')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Shrek 2', CAST(0x0000951800000000 AS DateTime), 93, 0, N'Andrew Adamson')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Shrek', CAST(0x000090CD00000000 AS DateTime), 90, 1, N'Andrew Adamson')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Star Trek: First Contact', CAST(0x00008A5200000000 AS DateTime), 111, 0, N'Jonathon Frakes')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Star Trek: Insurrection', CAST(0x00008D3F00000000 AS DateTime), 103, 0, N'Jonathon Frakes')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Die Hard 2', CAST(0x0000814C00000000 AS DateTime), 124, 0, N'Renny Harlin')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Long Kiss Goodnight', CAST(0x00008A4400000000 AS DateTime), 120, 0, N'Renny Harlin')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Cliffhanger', CAST(0x0000855F00000000 AS DateTime), 113, 0, N'Renny Harlin')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Fight Club', CAST(0x00008E7A00000000 AS DateTime), 139, 0, N'David Fincher')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Alien 3', CAST(0x0000842B00000000 AS DateTime), 114, 0, N'David Fincher')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Se7en', CAST(0x000088FB00000000 AS DateTime), 127, 0, N'David Fincher')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Blade II', CAST(0x000091DE00000000 AS DateTime), 117, 0, N'Guillermo del Toro')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Hellboy', CAST(0x0000955600000000 AS DateTime), 122, 0, N'Guillermo del Toro')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Total Recall', CAST(0x0000813700000000 AS DateTime), 113, 0, N'Paul Verhoeven')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Clear and Present Danger', CAST(0x000086F300000000 AS DateTime), 141, 0, N'Phillip Noyce')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Patriot Games', CAST(0x0000844E00000000 AS DateTime), 117, 0, N'Phillip Noyce')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Event Horizon', CAST(0x00008B4E00000000 AS DateTime), 96, 0, N'Paul Anderson')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Starsky & Hutch', CAST(0x000094AF00000000 AS DateTime), 101, 0, N'Todd Phillips')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'300', CAST(0x000098FA00000000 AS DateTime), 117, 0, N'Zack Snyder')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Star Trek: Nemesis', CAST(0x000092F600000000 AS DateTime), 116, 0, N'Stuart Baird')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Crimson Tide', CAST(0x000088BC00000000 AS DateTime), 116, 0, N'Tony Scott')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Deja Vu', CAST(0x0000989800000000 AS DateTime), 126, 0, N'Tony Scott')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Man On Fire', CAST(0x0000957A00000000 AS DateTime), 146, 0, N'Tony Scott')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Enemy of the State', CAST(0x00008D3900000000 AS DateTime), 132, 0, N'Tony Scott')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Kill Bill: Vol. 1', CAST(0x0000941500000000 AS DateTime), 111, 0, N'Quentin Tarantino')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Kill Bill: Vol. 2', CAST(0x000094D200000000 AS DateTime), 136, 0, N'Quentin Tarantino')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Pulp Fiction', CAST(0x0000874200000000 AS DateTime), 154, 1, N'Quentin Tarantino')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Reservoir Dogs', CAST(0x000084BE00000000 AS DateTime), 99, 0, N'Quentin Tarantino')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Shanghai Noon', CAST(0x00008F9900000000 AS DateTime), 110, 0, N'Tom Dey')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Shanghai Knights', CAST(0x0000935100000000 AS DateTime), 114, 0, N'David Dobkin')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Wedding Crashers', CAST(0x0000969100000000 AS DateTime), 119, 0, N'David Dobkin')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Blade', CAST(0x00008D0E00000000 AS DateTime), 120, 0, N'Stephen Norrington')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Fugitive', CAST(0x000085BA00000000 AS DateTime), 130, 1, N'Andrew Davis')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Licence to Kill', CAST(0x00007FBD00000000 AS DateTime), 133, 0, N'John Glen')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Living Daylights', CAST(0x00007CD400000000 AS DateTime), 130, 0, N'John Glen')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'For Your Eyes Only', CAST(0x0000744100000000 AS DateTime), 127, 0, N'John Glen')

GO

print 'Processed 200 total records'

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Octopussy', CAST(0x0000770B00000000 AS DateTime), 131, 0, N'John Glen')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Sin City', CAST(0x0000966800000000 AS DateTime), 124, 0, N'Frank Miller')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Serenity', CAST(0x000096E600000000 AS DateTime), 119, 0, N'Joss Whedon')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Star Trek: Generations', CAST(0x0000875E00000000 AS DateTime), 118, 0, N'David Carson')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Never Say Never Again', CAST(0x000077C700000000 AS DateTime), 134, 0, N'Irvin Kershner')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Star Wars: Episode V - The Empire Strikes Back', CAST(0x000072B000000000 AS DateTime), 124, 1, N'Irvin Kershner')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Star Trek: The Motion Picture', CAST(0x0000721700000000 AS DateTime), 132, 0, N'Robert Wise')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Star Wars: Episode IV - Return of the Jedi', CAST(0x000076FB00000000 AS DateTime), 134, 0, N'Richard Marquand')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'A History of Violence', CAST(0x000096DF00000000 AS DateTime), 96, 0, N'David Cronenberg')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Moonraker', CAST(0x0000716900000000 AS DateTime), 126, 0, N'Lewis Gilbert')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Spy Who Loved Me', CAST(0x00006EB200000000 AS DateTime), 125, 0, N'Lewis Gilbert')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'You Only Live Twice', CAST(0x0000603A00000000 AS DateTime), 117, 0, N'Lewis Gilbert')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Assassination of Jesse James by the Coward Robert Ford', CAST(0x000099F600000000 AS DateTime), 160, 0, N'Andrew Dominik')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Ghost Busters', CAST(0x0000792D00000000 AS DateTime), 105, 0, N'Ivan Reitman')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Twins', CAST(0x00007F4600000000 AS DateTime), 105, 0, N'Ivan Reitman')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Kindergarten Cop', CAST(0x000081F400000000 AS DateTime), 111, 0, N'Ivan Reitman')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Star Trek V: The Final Frontier', CAST(0x0000801F00000000 AS DateTime), 107, 0, N'William Shatner')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Star Trek VI: The Undiscovered Country', CAST(0x0000836E00000000 AS DateTime), 113, 0, N'Nicholas Meyer')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Star Trek II: The Wrath of Khan', CAST(0x000075C200000000 AS DateTime), 113, 0, N'Nicholas Meyer')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Running Man', CAST(0x00007EB300000000 AS DateTime), 101, 0, N'Paul Michael Glaser')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Open Range', CAST(0x000094AF00000000 AS DateTime), 139, 0, N'Kevin Costner')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Dances With Wolves', CAST(0x000081FB00000000 AS DateTime), 180, 7, N'Kevin Costner')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Star Trek III: The Search For Spock', CAST(0x000078A800000000 AS DateTime), 105, 0, N'Leonard Nimoy')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Star Trek IV: The Voyage Home', CAST(0x00007C8300000000 AS DateTime), 119, 0, N'Leonard Nimoy')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'King Kong', CAST(0x00006DCD00000000 AS DateTime), 134, 0, N'John Guillermin')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Gandhi', CAST(0x0000765300000000 AS DateTime), 188, 8, N'Richard Attenborough')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Equilibrium', CAST(0x0000933C00000000 AS DateTime), 107, 0, N'Kurt Wimmer')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'From Dusk Till Dawn', CAST(0x0000898E00000000 AS DateTime), 108, 0, N'Robert Rodriguez')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Borat: Cultural Learnings of America for Make Benefit Glorious Nation of Kazakhstan', CAST(0x0000986D00000000 AS DateTime), 84, 0, N'Larry Charles')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Hero', CAST(0x0000956C00000000 AS DateTime), 99, 0, N'Yimou Zhang')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'House of Flying Daggers', CAST(0x000095DC00000000 AS DateTime), 119, 0, N'Yimou Zhang')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Shaun of the Dead', CAST(0x000094C400000000 AS DateTime), 99, 0, N'Edgar Wright')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Hot Fuzz', CAST(0x000098D500000000 AS DateTime), 121, 0, N'Edgar Wright')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'28 Days Later…', CAST(0x000092B700000000 AS DateTime), 113, 0, N'Danny Boyle')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Beach', CAST(0x00008ED500000000 AS DateTime), 119, 0, N'Danny Boyle')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Trainspotting', CAST(0x0000892C00000000 AS DateTime), 94, 0, N'Danny Boyle')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Sunshine', CAST(0x0000990700000000 AS DateTime), 107, 0, N'Danny Boyle')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Downfall', CAST(0x0000962900000000 AS DateTime), 156, 0, N'Oliver Hirschbiegel')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Casino Royale', CAST(0x0000600C00000000 AS DateTime), 131, 0, N'Val Guest')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Amelie', CAST(0x0000912F00000000 AS DateTime), 122, 0, N'Jean-Pierre Jeunet')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Thunderball', CAST(0x00005E2700000000 AS DateTime), 130, 1, N'Terence Young')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Dr. No', CAST(0x00005A6100000000 AS DateTime), 110, 0, N'Terence Young')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'From Russia with Love', CAST(0x00005BE200000000 AS DateTime), 110, 0, N'Terence Young')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'On Her Majesty''s Secret Service', CAST(0x000063D100000000 AS DateTime), 140, 0, N'Peter R. Hunt')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Rumble in the Bronx', CAST(0x00008B1D00000000 AS DateTime), 104, 0, N'Stanley Tong')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Diamonds are Forever', CAST(0x000066B700000000 AS DateTime), 120, 0, N'Guy Hamilton')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Goldfinger', CAST(0x00005CC500000000 AS DateTime), 110, 1, N'Guy Hamilton')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Live and Let Die', CAST(0x000068E100000000 AS DateTime), 121, 0, N'Guy Hamilton')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Man with the Golden Gun', CAST(0x00006AF500000000 AS DateTime), 125, 0, N'Guy Hamilton')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Good Night, and Good Luck', CAST(0x0000976B00000000 AS DateTime), 93, 0, N'George Clooney')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Around the World in 80 Days', CAST(0x0000510700000000 AS DateTime), 167, 5, N'Michael Anderson')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Night Watch', CAST(0x000096E600000000 AS DateTime), 114, 0, N'Timur Bekmambetov')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'The Lives of Others', CAST(0x0000990F00000000 AS DateTime), 137, 1, N'Florian Henckel von Donnersmarck')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'King Kong', CAST(0x00002F7500000000 AS DateTime), 100, 0, N'Merian C. Cooper')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Seven Samurai', CAST(0x0000512800000000 AS DateTime), 190, 0, N'Akira Kurosawa')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Kagemusha', CAST(0x0000733A00000000 AS DateTime), 179, 0, N'Akira Kurosawa')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Ran', CAST(0x000079DD00000000 AS DateTime), 160, 1, N'Akira Kurosawa')

INSERT [dbo].[tblMovie] ([MovieName], [ReleaseDate], [Length], [Oscars], [Director]) VALUES (N'Super Size Me', CAST(0x0000955E00000000 AS DateTime), 100, 0, N'Morgan Spurlock')

Print 'Database generated'

SET NOCOUNT OFF

Now that you have a database set up, it's time to learn how to create indicators!

This blog assumes that you know how to create reports in SSRS (Reporting Services).

This blog has 2 comments

Comment added on 12 March 2012 at 14:05 GMT

Your documentation is quite good.  I do have a simple question for you though rearding how to float the indicator when it and the gauge pannel is in a report where the height of the row changes.  Your example shows a single line of text and mulitple line text.  The indicator remains "centered" in both situations.  How do you make that occur?  This would solve my only question regarding the use of indicators.

Thank you so very much.

Reply from Andy Brown
Part 2 of the blog shows how to add a rectangle into a table, then add your indicator into the rectangle. You can set horizontal and vertical alignment for the rectangle. Does this not solve the problem? Andy
Comment added on 19 February 2013 at 12:52 GMT
I can"t find the component indicator. Can you help?.
I can not see the component in Visual Studio

Thanks.
Reply from Andy Brown
You're almost certainly using SSRS 2008, not 2008 R2; the earlier version didn't include indicators and gauges.

A full-blown discussion forum is being built for this site, which will allow you once more to add comments and discussion threads.