CODEWITHSUNDEEP
sqlsql-server-2008reporting-servicesreportbuilder3.0
Steven Wood
Steven Wood

Reputation: 2785

SSRS Data Not showing when header and footer are

Quick question about SSRS

I am attempting to modify a report in SSRS using Report Builder 3 in SQL Server 2008.

The report is reading from a stored procedure and is meant to show a table of the results of that stored procedure.

I have verified that the stored procedure works, but my problem is that for some reason the header and footer of the report are showing but not the table itself.

Even if no results are returned I would still expect to see the table without any rows.

Has anyone seen this error before?

Thanks in advance

Upvotes: 0

Views: 1001

Answers (2)

Nathan Griffiths
Nathan Griffiths

Reputation: 12766

If a table is attached to a Dataset that returns zero rows, SSRS will display the contents of the NoRowsMessage property of the table, if anything has been entered, otherwise it will only display the header and footer rows of the table.

This means that if your table doesn't have header and/or footer rows AND your dataset returns zero rows AND there is nothing set for the NoRowsMessage property then nothing would be displayed on the report for that table.

Upvotes: 0

JC Ford
JC Ford

Reputation: 7066

Does your table have header or footer rows? If there is no data, those will be the only visible components. Also, check the Hidden property of the table. Perhaps the author of the report wrote an expression there that hides the table if it is empty.

Upvotes: 0

Related Questions