How to add a column grouping in a tablix?


  • I am developing a tablix in SSRS 2008 R2 and am trying to add a dynamic column.  This column has four possible values: Quarter 1,2,3,4.  Beneath each of these columns I want 2 child columns: Count and %.

    So I added a column to my tablix and placed expressions in each of the rows.  I did not yet add the child columns because it was giving me errors.  So I am just trying to get the Quarter columns to work.  So I grouped this Quarter column on my Quarter field value.  And I also sorted this column on this same value.  There are no filters set on the column group.  Yet, I got this error when I tried to view my RDL:


    So then I changed the ColSpan = 1 (from = 2) to every ColSpan in the XML that I found.  But then when I built my RDL I got this error:

    So this is the latest error I have.  How do I add a dynamic column grouping that will group on Quarter?  This should be something simple I know, but the Microsoft documentation I have seen is lacking on this subject.  And if u can recommend any tutorials that would be super also!

    Ryan D

    Friday, April 13, 2012 1:45 AM


All replies