Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Reporting Services Data Matrix isn't populating buckets correctly - please help

Answered Reporting Services Data Matrix isn't populating buckets correctly - please help

  • Friday, February 15, 2013 12:17 AM
     
     
    Sign In to Vote
    0

    Hey Forum Users - 

    I’m trying to achieve the following in SSRS using Report Builder 3.0 (this is all simulated data): 

    So this query is added to SQL Server Report Builder 3.0, with report column groupings set to Group Number and Row Grouping set to Group Letter, but the report data resembles the following: 


    Is there a way to write the query or design the report via Report Builder 3.0 that will fill up row and column “buckets” like the matrix at the top? I’d like to have all Group A Coupons in one row, all Group B Coupons in the second row, etc… with the subtotals out to the right of the matrix. 

    Thanks in advance! Carl 

    Carl

     

All Replies

  • Friday, February 15, 2013 1:35 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hi SSRS Yellowbelt,

    Thank you for your question. 

    I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 

    Thank you for your understanding and support.

    Thanks,
    Eileen

    If you have any feedback on our support, please click here

    Eileen Zhao
    TechNet Community Support

     
  • Monday, February 18, 2013 6:23 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Carl,

    Based on your description, it seems that the row group is a details row. To achieve your goal, please use the following steps:

    1. In the Report Designer, right click on the row group from the Grouping pane, and click “Group Properties…”
    2. In the General tab of the Group Properties dialog box, click “Add”, and select the “[Group_Letter]” field for the “Group on” item.

    If the row group has grouped on the [Group_Letter] field already, it may be related to your query of the dataset and I suggest that you post the query for further analysis.

    Regards,
    Mike Yin

    If you have any feedback on our support, please click here

    Mike Yin
    TechNet Community Support