locked
Report breakout by group RRS feed

  • Question

  • Hi all,

    I'm trying to run a report that displays a page break crosstab grouped on a specific field. I have a field called "car make" and I'm trying to run a crosstab which houses info on that "make", but I want the report to break out a crosstab for each "car make".   So, for example, the report runs a crosstab for honda, chevy, and ford, breaks it out for each "make".  I haven't been able to find anything online for sql report builder that does that.  

    Thanks. 

    Thursday, May 26, 2011 4:57 PM

Answers

  • Hi vba123,

    Thanks for your question. Base on your description, my understanding is that you have a tablix grouped by a special field “car make”, you want to break out these groups into multiple different tablixes, finally every "car make" is in one tablix, right? If I misunderstand your question, please let me know.

    If so, I suggest you drag the tablix into a list, and then add a group (“car make”) to the list. I will give you an example, for the detail steps, please follow below:

    1. From the Toolbox window, drag a list control onto the design surface of your report.

    2. Click anywhere inside your tablix, using the crosshair, drag the tablix into the list.

    3. Click anywhere inside the list, point to Select, select the list’s name and press F4 button to open the property window.

    4. In the properties window, locate to the DatasetName property, in the drop-down list, select the same DatasetName of your tablix.

    5. In the Row Groups section of Grouping Pane, right-click the detail of the list, select Group Properties, click Add button, select the field “car make”, click OK.

    Please preview your report, you will see multiple tablixes instead of one tablix with all the items. If you want to display different tablixes on different pages, you can add a page break to the group of the list control.  For more information about How to: Add a Page Break (Reporting Services), please see: http://msdn.microsoft.com/en-us/library/ms156434.aspx        

    This is the similar thread I have handled, please see http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/7d3126b6-4764-42ef-9605-ac65c230ce5c

        If you have any question, please feel free to let me know.

    Thanks,
    Sharp Wang

    • Proposed as answer by Challen Fu Wednesday, June 1, 2011 1:11 AM
    • Marked as answer by Challen Fu Monday, June 6, 2011 3:09 AM
    Monday, May 30, 2011 7:55 AM
  • Sorry for the late reply.  I followed your steps to break out by car make.  That worked!  Thanks for you help.  
    • Marked as answer by vba123 Wednesday, June 15, 2011 12:44 PM
    Wednesday, June 15, 2011 12:43 PM

All replies

  • Hi vba123,

    Thanks for your question. Base on your description, my understanding is that you have a tablix grouped by a special field “car make”, you want to break out these groups into multiple different tablixes, finally every "car make" is in one tablix, right? If I misunderstand your question, please let me know.

    If so, I suggest you drag the tablix into a list, and then add a group (“car make”) to the list. I will give you an example, for the detail steps, please follow below:

    1. From the Toolbox window, drag a list control onto the design surface of your report.

    2. Click anywhere inside your tablix, using the crosshair, drag the tablix into the list.

    3. Click anywhere inside the list, point to Select, select the list’s name and press F4 button to open the property window.

    4. In the properties window, locate to the DatasetName property, in the drop-down list, select the same DatasetName of your tablix.

    5. In the Row Groups section of Grouping Pane, right-click the detail of the list, select Group Properties, click Add button, select the field “car make”, click OK.

    Please preview your report, you will see multiple tablixes instead of one tablix with all the items. If you want to display different tablixes on different pages, you can add a page break to the group of the list control.  For more information about How to: Add a Page Break (Reporting Services), please see: http://msdn.microsoft.com/en-us/library/ms156434.aspx        

    This is the similar thread I have handled, please see http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/7d3126b6-4764-42ef-9605-ac65c230ce5c

        If you have any question, please feel free to let me know.

    Thanks,
    Sharp Wang

    • Proposed as answer by Challen Fu Wednesday, June 1, 2011 1:11 AM
    • Marked as answer by Challen Fu Monday, June 6, 2011 3:09 AM
    Monday, May 30, 2011 7:55 AM
  • Sorry for the late reply.  I followed your steps to break out by car make.  That worked!  Thanks for you help.  
    • Marked as answer by vba123 Wednesday, June 15, 2011 12:44 PM
    Wednesday, June 15, 2011 12:43 PM