Confirm

Expand all | Collapse all

Sql report in Pivot table layout

  • 1.  Sql report in Pivot table layout

    Posted 06-26-2019 09:56
    A report data that has a historic data such as customer services enquiry status, is there a way of setting it up so it shows one record with with status as headers (similar to pivot table set as rows).

    ------------------------------
    Afzal Hussain
    Knowledge Community Shared Account
    ------------------------------


  • 2.  RE: Sql report in Pivot table layout

    Posted 06-28-2019 10:07
    Hi Afzal,
    To create a Pivot Table in SQL, you can either use a CASE statement or a sub query.
    These need to be repeated for each column you need to create.
    Regards
    Haf

    ------------------------------
    Hafezur Rahman
    Application Specialist
    Richmond and Wandsworth Councils
    ------------------------------