locked
Create Dynamic columns in an RDLC report RRS feed

  • Question

  • User1182587605 posted

    Hi,

    I need to create dynamic queries using RDLC. My column names come from a query:

    Select distinct item_Number from item_Table

    The output should appear as columns like:

    Store   |   Location   |  ItemNumber1  |  ItemNumber2  |  ItemNumber3  |.....|Total

    How can I set this in my RDLC. I need totals inside the column names for this report. eg:

    Store   |   Location   |  ItemNumber1  |  ItemNumber2  |  ItemNumber3  |.....|Total

    111      |  NY            |   28                 |  30                   |  2                    |.....|

    How can I do this. Please help me with a process. Till now I have used typed dataset. Can I use any other process.

    Wednesday, May 17, 2017 10:32 AM

All replies

  • User-2057865890 posted

    Hi Deepak,

    I need to create dynamic queries using RDLC. My column names come from a query:

    Select distinct item_Number from item_Table

    The output should appear as columns like:

    Store   |   Location   |  ItemNumber1  |  ItemNumber2  |  ItemNumber3  |.....|Total

    How can I set this in my RDLC. I need totals inside the column names for this report. eg:

    Store   |   Location   |  ItemNumber1  |  ItemNumber2  |  ItemNumber3  |.....|Total

    111      |  NY            |   28                 |  30                   |  2                    |.....|

    How can I do this. Please help me with a process. Till now I have used typed dataset. Can I use any other process.

    To generate columns dynamically in reports, you could use Matrix control. For details, see Using SSRS - Matrix Control to Generate Columns Dynamically.

    Best Regards,

    Chris

    Thursday, May 18, 2017 6:42 AM