How to display in the report

• venkat.2914

  SSC-Addicted

  Points: 407

  More actions

  March 13, 2014 at 1:27 pm

  #305287

  i have a table 'X' in my sql server which has name and status fields and I need to generate a report from that query in which i need to display like

  Name, count(Status1),Count(status2)

  here i need to group by name and count the number of status status1 is where Status =1 and Status2 is where Status =2 in the table 'X'

  How can i display Status1 and Status2 in the same report?

  Plese suggest

  Thanks in Advance

  Ven

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  March 13, 2014 at 2:09 pm

  #1696953

  Did you try the matrix wizard? I think that's what you're after.