CODEWITHSUNDEEP
reporting-servicesssrs-2008reportingservices-2005ssrs-tablixssrs-grouping
SAM
SAM

Reputation: 189

SSRS Show data in horizontal layout

I new to SSRS, need to develop SSRS report to show data in horizontal layout inline as shown below is pix and data, Please guide with your help:

enter image description here

ID      Type        ID
1   Drawings    True
2   Shop Drawing    False
3   Samples False
4   Specification   True
5   Diskettes   False
6   CD Disc False
7   Bulletin    False
8   Site Instruction    False
9   Sketches    True
10  Submittal   False
11  Product Literature  False
12  Other   False

Regards

Upvotes: 1

Views: 4731

Answers (1)

Ian Preston
Ian Preston

Reputation: 39586

Here's one approach to consider:

Create a matrix with one Row Group and one Column Group. Remove the row/column header rows and add a new column, so you only have two textboxes in the matrix body:

enter image description here

Set the Row Group expression to:

=Ceiling(RowNumber(Nothing) / 6)

Set the Column Group expression to:

=(RowNumber(Nothing) - 1) Mod 6

This creates artificial groupings that will have six values per row.

I set the first textbox expression to:

=IIf(Fields!Selected.Value = "True", "X", Nothing)

i.e. display X when required. The main textbox is just set to the Type field.

This gives a matrix of values as required:

enter image description here

Obviously the formatting is rough but you can see how it works.

If the ID value in the dataset is unique and sequential you might be able to use that instead of RowNumber(). Also, this just preserves the Dataset order.

Hopefully this gives you a few ideas.

Upvotes: 7

Related Questions