0 Replies - 165 Views - Last Post: 15 November 2018 - 03:14 AM

SSRS

When I use the Table or Matrix Wizard to create a new SSRS report it insists that the "Values field list must contain at least one field", even though all I want to create is a flat, tabular view.

I'm happy just to chose a field and sum or count it, then hide the column, but... I cannot delete the column:

"Delete Columns
Tablix body must contain at least one column"

Is there a way to remove this column, perhaps by changing its 'Tablix' nature, but without losing any of the design? I know that I could just create a blank report, and insert a table, but it is a bit more effort to remain consistent doing it this way.