Data Set Access from a matrix
I am trying to create a schedule by room number report.I am using a matrix.The column group that I am using is room number.There is no row group.When you group by room it is only allowing me access to the first data item for that room.Even though there are other data items for that room I can not access them.I can not access all data items in that grouping expression.Is there a way to get unobstructed access to a dataset while working in a matrix and grouping?
If you are not getting back the correct data... I would use a table format and grouping... you can "trick" the look of the report to appear like a matrix..
Hope this helps..