none
Report Viewer - Group Totals Problems RRS feed

  • Question

  • Guys,

    I'm sorry if this isn't the correct place, but I couldn't find a better to post. 

    I've a datable with this query result:

    Invoice          Value        Client                          Discount

    1                    1500            1        Teste                5%

    1                    1200            1        Teste                5%

    2                    1000            2        Teste2              0%

    I've build the report to show values like bellow:

    <<Group Client>> Client:  Teste

    <<Group Invoice>> Invoice: 1

                                                  <<Detail >> 1500 

                                                   <<Detail >> 1200

    << Group Invoice Footer>> Total                2700

    << Group Invoice Footer>> Discount          5%

    << Group Invoice Footer>> Total                2565

    <<Group Client>> Client:  Teste2

    <<Group Invoice>> Invoice: 2

                                                  <<Detail >> 1000 

    << Group Invoice Footer>>                     Total              1000

    << Group Invoice Footer>> Discount          0%

    << Group Invoice Footer>> Total                1000

    <<Group Client Footer >>   Total                ????

    The problem is in group client footer. In Group Invoice Footer Total i use a epression that takes the total value and discount the percentage. In client footer I need to do the same thing but for client level, but what is happening is:

    1 - If I use the expression: sum(Fields!.Value) - (sum(Fields!.Value) . sum(Fields!.Discount), the report server sum the discount for each detail line, but I need to take only the discount for each invoice here.

    Can anyone help me? I tried to be as clear as I could.

    • Moved by Caillen Tuesday, June 17, 2014 7:21 AM
    Monday, June 16, 2014 3:55 AM

All replies

  • Guys,

    I'm sorry if this isn't the correct place, but I couldn't find a better to post. 

    I've a datable with this query result:

    Invoice          Value        Client                          Discount

    1                    1500            1        Teste                5%

    1                    1200            1        Teste                5%

    2                    1000            2        Teste2              0%

    I've build the report to show values like bellow:

    <<Group Client>> Client:  Teste

    <<Group Invoice>> Invoice: 1

                                                  <<Detail >> 1500 

                                                   <<Detail >> 1200

    << Group Invoice Footer>> Total                2700

    << Group Invoice Footer>> Discount          5%

    << Group Invoice Footer>> Total                2565

    <<Group Client>> Client:  Teste2

    <<Group Invoice>> Invoice: 2

                                                  <<Detail >> 1000 

    << Group Invoice Footer>>                     Total              1000

    << Group Invoice Footer>> Discount          0%

    << Group Invoice Footer>> Total                1000

    <<Group Client Footer >>   Total                ????

    The problem is in group client footer. In Group Invoice Footer Total i use a epression that takes the total value and discount the percentage. In client footer I need to do the same thing but for client level, but what is happening is:

    1 - If I use the expression: sum(Fields!.Value) - (sum(Fields!.Value) . sum(Fields!.Discount), the report server sum the discount for each detail line, but I need to take only the discount for each invoice here.

    Can anyone help me? I tried to be as clear as I could.

    Sorry, to reply my own question, but I need help. Can Anyoune help me?
    Tuesday, June 17, 2014 2:00 AM
  • Hi FcabralJ,

    Visual C# forum is not the correct forum for your question. I'm helping you to move it to Report Controls where you might get better responses.

    Thanks for your understanding.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, June 17, 2014 7:23 AM