Embedding Code in Reporting Services

CREATE TABLE [dbo].[tblFilm](

[FilmID] [int] NOT NULL,

[FilmName] [nvarchar](255) NULL,

[FilmSynopsis] [nvarchar](max) NULL,

[FilmOscarNominations] [int] NULL,

[FilmOscarWins] [int] NULL

CONSTRAINT [PK_tblFilm] PRIMARY KEY CLUSTERED

(

[FilmID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

INSERT [dbo].[tblFilm] ([FilmID], [FilmName], [FilmSynopsis], [FilmOscarNominations], [FilmOscarWins]) VALUES (1, N'Jurassic Park', N'Scientists clone dinosaurs to populate a theme park which suffers a major security breakdown and releases the dinosaurs.', 3, 3)

INSERT [dbo].[tblFilm] ([FilmID], [FilmName], [FilmSynopsis], [FilmOscarNominations], [FilmOscarWins]) VALUES (2, N'Spider-Man', N'When bitten by a genetically modified spider, a nerdy, shy, and awkward high school student gains spider-like abilities that he eventually must use to fight evil as a superhero after tragedy befalls his family.', 2, 0)

INSERT [dbo].[tblFilm] ([FilmID], [FilmName], [FilmSynopsis], [FilmOscarNominations], [FilmOscarWins]) VALUES (3, N'King Kong', N'In 1933 New York, an overly ambitious movie producer coerces his cast and hired ship crew to travel to mysterious Skull Island, where they encounter Kong, a giant ape who is immediately smitten with leading lady Ann Darrow.', 4, 3)

INSERT [dbo].[tblFilm] ([FilmID], [FilmName], [FilmSynopsis], [FilmOscarNominations], [FilmOscarWins]) VALUES (5, N'Superman Returns', N'After a long visit to the lost remains of the planet Krypton, the Man of Steel returns to earth to become the peoples savior once again and reclaim the love of Lois Lane.', 1, 0)

INSERT [dbo].[tblFilm] ([FilmID], [FilmName], [FilmSynopsis], [FilmOscarNominations], [FilmOscarWins]) VALUES (6, N'Titanic', N'Fictional romantic tale of a rich girl and poor boy who meet on the ill-fated voyage of the ''unsinkable'' ship.', 14, 11)

INSERT [dbo].[tblFilm] ([FilmID], [FilmName], [FilmSynopsis], [FilmOscarNominations], [FilmOscarWins]) VALUES (7, N'Evan Almighty', N'God (Freeman) contacts Congressman Evan Baxter (Carell) and tells him to build an ark in preparation for a great flood.', 0, 0)

INSERT [dbo].[tblFilm] ([FilmID], [FilmName], [FilmSynopsis], [FilmOscarNominations], [FilmOscarWins]) VALUES (8, N'Waterworld', N'In a future where the polar ice caps have melted and most of Earth is underwater, a mutated mariner fights starvation and outlaw "smokers," and reluctantly helps a woman and a young girl find dry land.', 1, 0)

INSERT [dbo].[tblFilm] ([FilmID], [FilmName], [FilmSynopsis], [FilmOscarNominations], [FilmOscarWins]) VALUES (9, N'Pearl Harbor', N'Pearl Harbor follows the story of two best friends, Rafe and Danny, and their love lives as they go off to join the war.', 4, 1)