locked
issue while working with dyunamic column group RRS feed

  • Question

  • User-1746098369 posted

    Hi , greeting for the Day !!

    I am developing the matrix report in SSRS, in this I have created the Rown group based on branch (e.g. Mechanical, Coputer Sc. etc) and a column group based on Subject Code (e.g CE01, CE02 CE03 Cor etc).

    now the problem is while running the report column group displayed the all branches subject , not generating the subject on the basis of the row group.

    I want like if first branch is CE than column group only displayy the CE subjects in column group and while the group change the respective subject should be displayed in the column group

     

    please help

    thanks in advance

    Tuesday, October 21, 2014 4:59 AM

All replies

  • User-830595639 posted

    Hi,

    As per my  knowledge its not possible in single report because Matrix will generate the number of columns based on the value for your column group.

    But you can follow the below steps to achieve your desired output.

    1. Create a report, with a table grouped on Branch.
    2. Create another report with a matrix column grouped on Subject.
    3. Call the 2nd (Matrix) report from the first and pass Branch as a parameter to it so that it only generates the number of column for your given branch

    Hope this will help you.

    Tuesday, October 21, 2014 5:55 AM
  • User-1746098369 posted

    thanks nishant fir your sugeestion

    any other help or idea frens , that we can do with the issue

    Wednesday, October 22, 2014 3:17 AM