Creating a Directory Listing type Report in SSRS

1
votes

I was wondering if there was a way to create a directory listing report in ssrs and if so, how would i go about creating it. I'm mostly familiar with creating tabular and some somewhat complex reports, but nothing like this; so any help would be extremely useful.

Here's a sample of how the report might look.

Sample Report

Thanks!

Addendum: The content on each page needs to be grouped by Department & Sub-Department. I made a mistake on the sample report; where it says Department Subtitle it should say sub-department.

2
sql-server-2008reporting-servicesssrs-2008report

2 Answers

1
votes

Here's one way I've seen it done.

For a 3 column look, create 3 tables/list with the same dataset and set visibility for details group to:

=IIF(ROWNUMBER("YourDataSet") mod 3=1,FALSE,TRUE) <--Table1 
=IIF(ROWNUMBER("YourDataSet") mod 3=2,FALSE,TRUE) <--Table2
=IIF(ROWNUMBER("YourDataSet") mod 3=0,FALSE,TRUE) <--Table3
1
votes

I think your problem is an addition to this question here.

I did a simple test that imitates your situation. Here is how to do it:

  1. Set the report to 3 columns via Report properties. Adjusted the width of each column so that they fit in 1 page of paper.
  2. Add a List control to the first column. Put Text Box controls inside with the required data fields. The List control will repeat for each Listing record.
  3. Create groups for Department and Sub-Department via Row Groups pane. Rearrange the groups so that they will appear above the List control.
  4. Right-click on Department group (or Sub-Department group) and add Page Breaks.
  5. Preview (Should get a result pretty close to what you want)