sql server reporting services: Displaying Dynamically created columns -- sql server reporting services

Displaying Dynamically created columns

Sunil Oliver
4/26/2005 1:27:01 PM

sql server reporting services:

Hello,
I have a stored procedure that accepts input parameters and depending
on the input, returns multiple columns. For example depending on the month
range passed in, the stored procedure creates and populates temporary table
with columns for each month and returns the values in the temporary table.
How do I display these dynamically created columns using Reporting Services
(the number of coulmns returned by the stored proc varies between different

Re: Displaying Dynamically created columns

Bill Youngman
5/2/2005 12:00:00 AM

Sunil,

You would need to use the matrix control and then edit the
matrix_columngroup to use the data returned from your stored proc.

Hope this helps.

Bill Youngman
Anexinet, Inc.

[quoted text, click to view]