none
ReportViewer RDLC report grouping problem! RRS feed

  • Question

  • VS 2010 Pro ReportViewer

    Hi, After struggling with subreports and their horrible performance I decided to go for the other method; joining my DTs (Datatables) in one DT. It partially works. The report first looked like this:

    Team1
    ---Player1
    ---Player2
    Team2
    ---Player1
    ---Player2
    and so on...

    The problem is that I have three DTs not two:

    Parent DT (Teams): contains names of teams.
    Child DT (Players): contains names of players.
    Grand child DT (Awards): contains awards every player won (player achievement).

    So I joined all the three DTs in one single DT. The joining works and I setup some grouping, but the report now looks like this:

    Team1
    ---Player1
    ------Award1
    ---Player1
    ------Award2
    ---Player2
    ------Award1
    ---Player2
    ------Award2
    Team2
    ---Player1
    ------Award1
    ---Player1
    ------Award2
    ---Player2
    ------Award1
    ---Player2
    ------Award2

    As you can see, the player name is repeated. I don't want it to be repeated, I only want the awards every player won to be repeated. I need the report to look like this:

    Team1
    ---Player1
    ------Award1
    ------Award2
    ---Player2
    ------Award1
    ------Award2
    Team2
    ---Player1
    ------Award1
    ------Award2
    ---Player2
    ------Award1
    ------Award2

    I'm sure it's all about grouping, which is something I don't even know how it really works, what I achieved so far depended on trial and error which is (IMHO) a bad way to learn programming (but this is a different subject). Any ideas on how to setup the grouping to achieve my goal. I searched a lot but can't find any. Thank you very much.

    Wednesday, November 13, 2013 8:47 AM

All replies