Post reply

Can the report table has varying number of columns.

  • August 31, 2004 at 4:49 am

    #109231

    The requierment is to have a dynamic report, that has a table with number of columns decided on the input from recordset.

    The SQL procedure takes in parameters and returns recordset, that can have varying number of columns. All we want to do is to link this recordset to a

    table on the report.

    The report table should show the columns as they are in the Recordset. ( and the column name in the recordset shall appear as the column header in the

    Reporting table.)

  • September 1, 2004 at 8:21 am

    #521368

    I'm assuming you are talking about SQL Reporting Services.  If so, you will have to build your report table to have the maximum number of columns you will want on your report.  You can then use the Visible function on the columns and make the columns visible or not using an expression based on a value in your recordset.

    You cannot dynamically add columns at run-time.

    hawg

    ----------------------------------------------------------

    01010011010100010100110000100000010100110110010101110010011101100110010101110010
    001000000101001001101111011000110110101101110011

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

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