i new ssrs, need develop ssrs report show data in horizontal layout inline shown below pix , data, please guide help:

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:

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:

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
Post a Comment