Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Groups the Row groups in which correct values falls into it

Unanswered Groups the Row groups in which correct values falls into it

  • Thursday, January 03, 2013 1:45 AM
     
     
    Sign In to Vote
    0

    i have a table(matrix) in my ssrs,in my row groups i have student data  in which 3 values falls into it.a)John, Sam and Mary
    im my datasets i have 2 data , Teachers and Surpervisor as column.this display the total number of students,
    So in my student row i want to match only those values to both Teachers and Supervisor.
    eg

    here is what my table look like when i run it

    ---------------------------------
             Teacher    Supervisor

    --------------------------------------

    john ---  56            0
    ---------------------------------
    Sam       0           112

    Mary

    ---------------------------------

    the value 50 and 112  should be a constant value and also since Student is in row group how can i group john to separate
    from Sam and Marry.

     

All Replies

  • Thursday, January 03, 2013 3:51 AM
     
     
    Sign In to Vote
    0

    Is there a column which differentiates john from other like an indicator? If so then you can group using that column.

    Regards,Eshwar.

    Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.


    • Edited by Eswararao C Thursday, January 03, 2013 3:52 AM
    •  
     
  • Sunday, January 06, 2013 8:27 PM
     
     
    Sign In to Vote
    0

    thanks for your reply

    i want my table to be like this one below especially for the Usage columns. how can i divide my cells like that in ssrs 2008?...groups

    thanks in advance

     
  • Monday, January 07, 2013 7:08 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Uttar,

    From you description, it seems that you want to add grouping and totals to your tablix, right? If in this case, please refer to the link below to see the MSDN document about add grouping and totals, which tell you how to do it steps by steps.
    http://msdn.microsoft.com/en-us/library/ms170712.aspx

    If the issue persists, please elaborate the structure of the dataset, if possible provide us a screenshot about the table with the sample data, so that we can male further analysis.

    Regards,
    Charlie Liao

    Charlie Liao
    TechNet Community Support

     
  • Friday, January 11, 2013 8:24 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Uttar,

    Have you solved your issue? Do you like thie tablix format in the screenshot below?

    Regards,
    Charlie Liao

    Charlie Liao
    TechNet Community Support

     
  • Sunday, January 13, 2013 9:53 PM
     
     
    Sign In to Vote
    0

    hi Charlie,

    No yet. yea I like d one you shown above. I'm using ssrs 2008. how  you solved it? but for row People can u merge man and women together so column 3 can have 12..

    thanks


    • Edited by uttar007 Sunday, January 13, 2013 9:54 PM
    •  
     
  • Monday, January 14, 2013 2:18 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Uttar007,

    If in this case, I am afraid you need to use two tablix to display it. In Reporting Services, we cannot add parent groups for details row in it left side and right side. I have tested it using two tablix. It looks like below.

    Regards,
    Charlie Liao

    Charlie Liao
    TechNet Community Support

     
  • Wednesday, January 16, 2013 2:53 AM
     
     
    Sign In to Vote
    0

    hi Charlie,

    I use matrix and table nothing seems solving my problem...i thinks its my row groups or expression in which it gets me wrong.but according to the output above, can you elaborate more on that..if steps will be grateful..

    thanks

     
  • Thursday, January 17, 2013 1:23 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Uttar007,

    The steps below are for your reference.

    1. Drag two table controls into the design surface.
    2. Drag [col2] to the tables, and then add a row group for this column, parent group is [col1].
    3. Change the parent group field to [col3] in table two.
    4. Drag table two to the right side of table one, and set the visibility property to “Hidden” for the columns which is useless.

    Hope this helps.

    Regards,
    Charlie Liao

    Charlie Liao
    TechNet Community Support