need some help...reporting? analasys?

• cb005

  Newbie

  Points: 8

  More actions

  April 25, 2012 at 9:01 am

  #254907

  New to SQL/ASP...not sure where to post this.

  This is an ASP app. Attached is a partial screenshot of the app. What is the best way to get totals for each row (not column)...Like how many F's/U's/IP's/DNP's? One thought is to give each F/U/IP/DNP a value and then total. I need a way to show if the row has say 70% U's (red) then show a warning. Management doesn't care if it's on the screen or they select a button and it runs a report and analyzes the data. Does this make sense? Not sure how to approach this or what the proper terminology is for asking you all for help.

  Thanks a bunch

• Jared

  SSC Guru

  Points: 61793

  More actions

  April 25, 2012 at 9:06 am

  #1479073

  Would the COUNT(columnName) function help?

  SELECT COUNT(columnA)

  FROM table

  WHERE columnA = 'U'

  Please read the article referenced in my signature to help us better help you.

  Jared
  CE - Microsoft

• cb005

  Newbie

  Points: 8

  More actions

  April 25, 2012 at 9:13 am

  #1479082

  Thanks Jared...

  I'll read it after I post. I need the totals on the row though not the column.

  Derek