InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 00:03:57 GMT20http://www.sqlservercentral.com/Forums/Topic1382576-150-1.aspxHi 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,Sun, 11 Nov 2012 13:52:53 GMTJysafe Lerroyhttp://www.sqlservercentral.com/Forums/Topic1382576-150-1.aspxYour 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.Fri, 09 Nov 2012 10:23:28 GMTRay Mhttp://www.sqlservercentral.com/Forums/Topic1382576-150-1.aspxI'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.Fri, 09 Nov 2012 09:34:29 GMTSteve-0http://www.sqlservercentral.com/Forums/Topic1382576-150-1.aspxNot 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.Thu, 08 Nov 2012 11:35:35 GMTRay Mhttp://www.sqlservercentral.com/Forums/Topic1382576-150-1.aspxHi,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.[code="plain"][b]SQL OutputPerson # Person Name PersonIdent StartDT EndDT PS[/b]1234 Smith, David TMS 2010-01-04 08:30 2010-01-04 18:30 Central16592 Howard, Rhonda TMS 2010-01-02 09:45 2010-01-02 16:00 Central16592 Howard, Rhonda TMS 2010-01-04 09:00 2010-01-04 19:15 Central13718 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 Eastern13718 Cooper, Robyn QMR 2010-01-04 16:00 2010-01-04 19:00 Eastern16437 Arwood, Michael TMS 2010-01-02 09:30 2010-01-02 16:00 Eastern16437 Arwood, Michael TMS 2010-01-04 09:00 2010-01-04 09:30 Eastern16437 Arwood, Michael TMS 2010-01-04 09:30 2010-01-04 11:45 Eastern16437 Arwood, Michael TMS 2010-01-04 11:45 2010-01-04 13:45 Eastern16437 Arwood, Michael TMS 2010-01-04 14:30 2010-01-04 18:00 E astern[/code][code="plain"][b]Report DisplayPerson # Person Name PersonIdent # of Days Hours PS[/b]1234 Smith, David TMS 1 10 Central16592 Howard, Rhonda TMS 2 16.5 Central13718 Cooper, Robyn QMR 2 14.25 Eastern16437 Arwood, Michael TMS 2 14.75 Eastern[/code]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,Thu, 08 Nov 2012 09:28:10 GMTJysafe Lerroy