Dynamically Create Columns

Hi, i'm a newbie to reporting services. May i know if it is possible to dynamically create columns for a report?

I know that there's a way to hide the columns on the fly. However, for my case, i will only know the amount and the detail information (column name etc..) of columns while the report is running.

Thanks in advance.

I think i have posted the message in the wrong forum. I should post it in the SQL 2k forum. Sorry|||

Maybe a matrix could help...

|||

The only way to create columns on the fly is to use the matrix control. In this mode, the columns are groups in your data.

RS 2005 includes an 'execute on the fly' method on the execution web service so you could construct a dynamic report and pass it to the service to run.

|||Can you please point us to some samples of this "execute on the fly method"?