reporting services - SSRS Show data in horizontal layout -


i new ssrs, need develop ssrs report show data in horizontal layout inline shown below pix , data, please guide 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

here's 1 approach consider:

create matrix 1 row group , 1 column group. remove row/column header rows , add new column, have 2 textboxes in matrix body:

enter image description here

set row group expression to:

=ceiling(rownumber(nothing) / 6) 

set column group expression to:

=(rownumber(nothing) - 1) mod 6 

this creates artificial groupings have 6 values per row.

i set first textbox expression to:

=iif(fields!selected.value = "true", "x", nothing) 

i.e. display x when required. main textbox set type field.

this gives matrix of values required:

enter image description here

obviously formatting rough can see how works.

if id value in dataset unique , sequential might able use instead of rownumber(). also, preserves dataset order.

hopefully gives few ideas.


Comments