locked
amount of orders for each countries for employees in northwind RRS feed

  • Question

  • Hello every one

    I want to have bellow report in Northwind: would you please help?

    Employeeid    Lastname    countryname1           countryname2 .....    countryname n    total

                                          sum of unit price 

                                           total                          total                        total                 total

    Friday, July 14, 2017 6:53 PM

Answers

  • Hi Mjafari.360,

    Thanks for your question.

    If i understand you correctly, you can refer to below blog to create SQL Server Reporting with Microsoft Excel.
    https://www.mssqltips.com/sqlservertip/1439/sql-server-reporting-with-microsoft-excel/

    Best Regards
    Willson Yuan
    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

    • Marked as answer by AV111Editor Wednesday, August 2, 2017 3:29 AM
    Monday, July 17, 2017 3:14 AM

All replies

  • Hi Mjafari.360,

    Thanks for your question.

    If i understand you correctly, you can refer to below blog to create SQL Server Reporting with Microsoft Excel.
    https://www.mssqltips.com/sqlservertip/1439/sql-server-reporting-with-microsoft-excel/

    Best Regards
    Willson Yuan
    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

    • Marked as answer by AV111Editor Wednesday, August 2, 2017 3:29 AM
    Monday, July 17, 2017 3:14 AM
  • Thanks alot WillsonI know how to do it with excel but my boss wants me to do it with Tsql :-(

    Monday, July 17, 2017 1:48 PM
  • Hi Mjafari.360,

    Thanks for your response.

    According to your description, your problem is more related to T-SQL. Since our forum is discussing Power Pivot issue, to solve your question more efficiently, please post your question in T-SQL forum: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=transactsql ,you will get a more professional support from there, thank you for your understanding and support.


    Best Regards
    Willson Yuan
    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

    Tuesday, July 18, 2017 1:48 AM