Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Grouping Row Expand / Collapse
Author
Message
Posted Thursday, November 8, 2012 9:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 18, 2013 9:44 PM
Points: 18, Visits: 78
Hi,

My SQL statement gives me the example below output. What I want to do is sort by person and display like the second display below.


SQL Output

Person # Person Name PersonIdent StartDT EndDT PS

1234 Smith, David TMS 2010-01-04 08:30 2010-01-04 18:30 Central

16592 Howard, Rhonda TMS 2010-01-02 09:45 2010-01-02 16:00 Central
16592 Howard, Rhonda TMS 2010-01-04 09:00 2010-01-04 19:15 Central

13718 Cooper, Robyn QMR 2010-01-02 09:45 2010-01-02 16:00 Eastern
13718 Cooper, Robyn QMR 2010-01-04 10:00 2010-01-04 15:00 Eastern
13718 Cooper, Robyn QMR 2010-01-04 16:00 2010-01-04 19:00 Eastern

16437 Arwood, Michael TMS 2010-01-02 09:30 2010-01-02 16:00 Eastern
16437 Arwood, Michael TMS 2010-01-04 09:00 2010-01-04 09:30 Eastern
16437 Arwood, Michael TMS 2010-01-04 09:30 2010-01-04 11:45 Eastern
16437 Arwood, Michael TMS 2010-01-04 11:45 2010-01-04 13:45 Eastern
16437 Arwood, Michael TMS 2010-01-04 14:30 2010-01-04 18:00 E astern


Report Display

Person # Person Name PersonIdent # of Days Hours PS

1234 Smith, David TMS 1 10 Central

16592 Howard, Rhonda TMS 2 16.5 Central

13718 Cooper, Robyn QMR 2 14.25 Eastern

16437 Arwood, Michael TMS 2 14.75 Eastern


I was able to get the # of Days and Hour but it is not grouped, so the Report displays for each row. How can I group the output to display like above?

Thanks,
Post #1382576
Posted Thursday, November 8, 2012 11:35 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 8:50 AM
Points: 1,486, Visits: 1,037
Not exactly sure where your issue is cause I cannot see what the issues is, but here's a guess.


In your report I think you need to create a row group.
(Right Click the Left Most Cell of your table on the Detail Row, and Select RowGroup --> Parent Group.

Group by the PersonID, and Check Add Group Header.
Then put all your values on that new row thats created, you can either hide the detail row, or delete it.

Post #1382659
Posted Friday, November 9, 2012 9:34 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, December 11, 2014 7:08 AM
Points: 32, Visits: 87
I'm having a similar issue. I want to create a group (custom) where I can hide 1TGRCMHC and 1MTGRENW rows and just have the group title with the totals for approved, disbursed and unfunded visable only, unless people wanted to see the source of the total.

  Post Attachments 
Capture.PNG (7 views, 6.96 KB)
Post #1383095
Posted Friday, November 9, 2012 10:23 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 8:50 AM
Points: 1,486, Visits: 1,037
Your example does not look like there's a logical grouping available.

You can Hide the detail Row by right clicking the Row And Select Row Visibility --> Hide. and Then Check Display can be toggled by This report Item, and Select the textbox you want to control the hide and show. Which will allow user to see detail if required.
Post #1383130
Posted Sunday, November 11, 2012 1:52 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, December 18, 2013 9:44 PM
Points: 18, Visits: 78
Hi

Thank you that was very helpfull,

Using Expression in SSRS, how can I select Min and MAX dates?

In other words, is it possible to do the below SQL queiry in SSRS expressoin?

CASE DATEDIFF(dd,MIN(CONVERT(VARCHAR(10),StartDT, 101)),MAX(CONVERT(VARCHAR(10),EndDT, 101))) WHEN 0 THEN 1
ELSE DATEDIFF(dd,MIN(CONVERT(VARCHAR(10),StartDT, 101)),MAX(CONVERT(VARCHAR(10),EndDT, 101))) AS [# of Days],

Thanks,
Post #1383465
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse