locked
Grouping of only first and last column in an SSRS report RRS feed

  • Question

  • is it possible to group only first and last column of an ssrs report a in the image below?

    iam using SSRS Version 13.0.5101.9 

    Order

    Customer

    code

    ind Total

    Total

    12345

    abcd

    xvxy

    30

    100

    huji

    yvxx

    70

    67856

    ukil

    wwvv

    35

    80

    runi

    yuvx

    45


    

    Wednesday, February 26, 2020 7:54 PM

Answers

  • Hello Aswin13,

    Actually, row group is add new column fornt of the detail table by default, we can't change the position of row group.

    However, i figure out below method to meet you demand:

    1.Create new column between ' Order' and 'Total'

     

    2.insert table in the cells

    3. Expand the cell the suitbale length

    4.add the dataset' Customer','Code','ind_Total' and delete Data row in the upon cell and delete Header row in the below row

    5. Delete these row

    6.right click 'Customer'--'Column Visibility ' choose 'hide'

    7. Preview the report

     

    And there is another methods that create the same table in right side and close to the original table , and add 'total' group, then delete detail columns, and hide the visibilty of the last one detail column which can't be delete.

    If this reply is helpful, please 'mark as answer'. This can be beneficial to other community members finding and reading the thread easily. Thanks for your contribution.


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.



    Thursday, February 27, 2020 8:16 AM

All replies

  • Hello Aswin13,

    If i understand right, you want to add group sorting by 'Order' & 'Total' Column? It is feasible to do this though 'Add group', then 'group by' Order & Total, please see below steps:

    1. Create a table, then put 'Customer','Code','ind Total' in it

    2. Choose 'Customer' tablix, Add row group, and choose' parent group'

    3. Group by ' Order', then you add group by 'Order'

    4. Do the same steps as above to add group by 'Total'

    5. Then preview the report as below

    And here you can learn about Adding Grouping and Totals (Reporting Services)

    Hope it will help. If i misunderstand you, please clarify more detail about what you want. Thanks.


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, February 27, 2020 6:02 AM
  • This is good. But the issue is i want the total field to stay as the last column itself.

    Now when this is done total field becomes the second column.

    So is there any way this could be done. ie.. to show  grouped columns in places other than as  first columns.

    Thursday, February 27, 2020 7:16 AM
  • Hello Aswin13,

    Actually, row group is add new column fornt of the detail table by default, we can't change the position of row group.

    However, i figure out below method to meet you demand:

    1.Create new column between ' Order' and 'Total'

     

    2.insert table in the cells

    3. Expand the cell the suitbale length

    4.add the dataset' Customer','Code','ind_Total' and delete Data row in the upon cell and delete Header row in the below row

    5. Delete these row

    6.right click 'Customer'--'Column Visibility ' choose 'hide'

    7. Preview the report

     

    And there is another methods that create the same table in right side and close to the original table , and add 'total' group, then delete detail columns, and hide the visibilty of the last one detail column which can't be delete.

    If this reply is helpful, please 'mark as answer'. This can be beneficial to other community members finding and reading the thread easily. Thanks for your contribution.


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.



    Thursday, February 27, 2020 8:16 AM