CODEWITHSUNDEEP
sqlreporting-servicesgrouping
Rion Williams
Rion Williams

Reputation: 76557

Grouping Issue in SQL Reporting Services

I haven't worked with SQL Reporting much, however I have been trying to get my results to appear in a specific way but I just can't seem to figure out how to format / group my results.

The data that I am receiving from my query resembles the following:

Basically, I am trying to format my results as follows:

DISPLAY NAME (NUMBER OF STUDIES)
---------------------------------------------------------------------------------
STUDY DATE / TIME           |  STUDY DESCRIPTION                                 
----------------------------+----------------------------------------------------
01/16/2012 12:34 AM         |  EXAMPLE DESCRIPTION 1
02/22/2012 02:22 PM         |  EXAMPLE DESCRIPTION 2

I have tinkered with the grouping several times I am able to have the name appear on the left-hand side and list all of the studies to the right, however I am trying to achieve the appearance listed above but am not having any luck.

Any suggestions would be more than welcome and I will try to provide any additional details if needed.

Upvotes: 1

Views: 216

Answers (1)

user359040
user359040

Reputation:

  • Group by ID Number.
  • Include two group header rows - one for Display Name and count of rows, one for column headings.
  • Include a detail row to list study date/time and description.
  • You may want to include a group footer with a space in it, to insert a blank line between one group and the next.

Upvotes: 2

Related Questions