CODEWITHSUNDEEP
sql-serverreporting-servicescrystal-reportsssrs-2008
J P
J P

Reputation: 79

2008 SSRS What kind of report type and how to properly group data?

I am coming from Crystal Reports and trying to replicate what would seem to be a fairly simple report in SSRS 2008, but I am having trouble determining what type of base report style I need, and how to achieve properly nested grouping of my data.

I have watched a bunch of tutorial videos on YouTube, searched google, and experimented with SSRS based on what I have been able to find online, but I haven't been able to achieve the desired result. 

I have a list of songs associated with each Album Id
The songs can either be Type 1 (Track A) or Type 2 (Track B)
The report results are first grouped by the Album Id (Group Header #1) and then grouped by Song Type (Group Header #2)
There is a new page or page break after unique album id (Group Footer #1) 
I have attached the design example in Crystal Reports and also the Sample PDF created when printing the report.

crystal reports design example sample pdf of how data is grouped and displayed

I am hoping someone can help point me in the right direction. Thank you!

Upvotes: 0

Views: 64

Answers (1)

Jamie F
Jamie F

Reputation: 23789

With SQL Server 2008 R2, the options in SSRS changed quite a bit. So as pointed out in comments, design the reports in 2008 R2 or more recent version of SQL server/BIDS to get at this.

If creating this report, I would start with a blank report in a recent version of BIDS, and add the data source, then data set, then drag a table onto the design surface. I would drag the Artist name to the "Row Groups" sub-pane of the design window to create a grouping based on Artist. Then I would create a calculated field in the data set that is a concatenation of album name and side. So I could then drag that field into "Row Groups" underneath the Artist group. Right clicking on these groups will let you add rows and headers for the groups to insert the dynamic and static data you are working with.

You can choose Group Properties and indicate that a page break should be inserted between every instance of the Artist group.

Upvotes: 3

Related Questions