dynamic table in report

hi,

i have a dataset which returns me a dynamic set of data ie. number of columns can be different....say 14 columns for some dates...and just 12 for some other...(pivot table is being used in the backend)...how can i present this in the table...also my column names are best suited to be the column headers in the table.....is it possible to create a table at runtime...?

Are your field names and the max # of fields returned in the dataset fixed? If so, you can define a table with N (N=max# of fields) columns (one field per column). Then set the visibility property on the table column to be based on the IsMissing property on the field http://msdn2.microsoft.com/en-us/library/ms157274.aspx|||it was..but the client wants it dynamic...columns r the active schemes..they can vary with time...though i am getting the number of schemes and their names..... its like...select activeschemes where date between report start date and end date ........pivot it and get other details..and return the dataset....|||i got it, made the columns into rows and used matrix in report....|||Just create a dataset and Mark visiability of column by =IIf(Fields!Collection.IsMissing=True,True,False) so ur report becomes dynamic.Column which is not there will gets hidden