locked
How to hide repetitive data on SSRS report RRS feed

  • Question

  • Hi,

    I am getting data from database in below format.

    I want to display output in SSRS report as per below format. 

    The major issue I am facing here is on how to display customer id once and then it should be blank. How to take Withdraw amount sum for each customer id.

    Any help would be much appreciated as I am quite new to SSRS area.

    Thanks,

    Abhiyanta

    Friday, July 5, 2013 9:03 PM

Answers

  • Hi Abhiyanta,

    From your description, there are multiple recordes for each customer id on the database, and you want dispaly each customer id once, right? In this case, you can add row group the the records using customer id as the parent group. Then each customer id will be dispaly once only. For the detail information, please see:
    Lesson 6: Adding Grouping and Totals (Reporting Services)

    If you have any questions, please feel free to ask.

    Regards,
    Charlie Liao

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


    Charlie Liao
    TechNet Community Support

    • Proposed as answer by V Karthik Monday, July 8, 2013 6:07 AM
    • Marked as answer by Charlie Liao Tuesday, July 16, 2013 3:36 AM
    Monday, July 8, 2013 5:44 AM

All replies

  • Textboxes and some other controls have a HideDuplicates property which does this.  Try it.
    Friday, July 5, 2013 9:36 PM
  • Hi Abhiyanta,

    From your description, there are multiple recordes for each customer id on the database, and you want dispaly each customer id once, right? In this case, you can add row group the the records using customer id as the parent group. Then each customer id will be dispaly once only. For the detail information, please see:
    Lesson 6: Adding Grouping and Totals (Reporting Services)

    If you have any questions, please feel free to ask.

    Regards,
    Charlie Liao

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


    Charlie Liao
    TechNet Community Support

    • Proposed as answer by V Karthik Monday, July 8, 2013 6:07 AM
    • Marked as answer by Charlie Liao Tuesday, July 16, 2013 3:36 AM
    Monday, July 8, 2013 5:44 AM