SQL Reporting Services with Dynamic Column Reports

��/*This procedure is for Showing an example and You have to following your own standards and Author is

not giving any guarantee that this code will work*/





if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblDynamic]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[tblDynamic]

GO



CREATE TABLE [dbo].[tblDynamic] (

	[Col1] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

	[Col2] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

	[Col3] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

	[Col4] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

	[Col5] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 

) ON [PRIMARY]

GO