Summary Report

Question

Post reply

Summary Report

ashatimjohn

SSC Veteran

Points: 219
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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 245813 More actions · Answer 1

Which reporting tool are you using?

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

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.