Post reply

Displaying a dynamic numbers of columns in a report?

  • February 23, 2006 at 3:30 pm

    #171244

    Hi,

    I have a parameterized report which generates a dynamic SQL statement. The parameter is just the name of a table within the database. It returns all columns of the top 5 rows within the chosen table (acting as a sample of the data in the chosen table). However, the tables in the database have a varying number of columns and I am wanting to create a report with a dynamic number of columns matching the structure of the chosen table. Is this possible within Reporting Services 2000?

    Thanks for any help offered.

    Steve.

  • February 27, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • February 27, 2006 at 4:16 pm

    #623565

    Steve,

    You could use a RS matrix instead of a table.  You'd need to modify your query to a series of unions that include the column names as well as their values. 

    ie

    SELECT 'Column1Name' AS 'RS Matrix Column Group By', Column1Value

    UNION ALL

    SELECT 'Column2Name, Column2Value

    The output could then be attached to a RS matrix, where the column group by would be you column name.

    I realize this is sketchy, but it's the direction I'd go in if it were me.

    Mike

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply