Summary Report

• ashatimjohn

  SSC Veteran

  Points: 247

  More actions

  February 25, 2022 at 10:20 pm

  #3989184

  I need to create a summary report with a bunch of counts off different critera.

  The summary is a rectangle with text boxes in it.

   

  If there is any way or a better way, please let me know.  Thank you all for your help.

  1.  Total case count - I've already done this.
  2. Case count for cases received by 4:30 pm - I have no idea how to get this to work.  I thought if there was a way to put criteria on a text box I could do something like this:  CONVERT(VARCHAR(5),created_date,108) > '16:30:59

• Phil Parkin

  SSC Guru

  Points: 246990

  More actions

  February 26, 2022 at 10:57 am

  #3989425

  Which reporting tool are you using?

  If you want a code solution, please provide sample data and desired results in a consumable format.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• Michael L John

  One Orange Chip

  Points: 27065

  More actions

  February 26, 2022 at 12:38 pm

  #3989505

  Duplicate Posts

  https://www.sqlservercentral.com/forums/topic/summary-report-4

  https://www.sqlservercentral.com/forums/topic/summary-report-3

  Please do not cross-post

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/

• ashatimjohn

  SSC Veteran

  Points: 247

  More actions

  February 26, 2022 at 3:30 pm

  #3989576

  I apologize for posting twice.  I didn't know there was a reporting services forum.  Thank you!