How to Remove the row which doesn't have data?

Hello to all,

I am new to rdlc reports.

I am using WebFrom Report Viewer,

My Quesiton is that i've some fileds in my database that do not have data,

and i want if there is no data in the field then the row will not be display and the the lower row shifted to the blank row, Or i want to remove the blank row and dont want to show the blank space too, is it possible with textbox and rectangle,

and how to doit with table,list matrix.

Thank you very much.

vijaytooly

[523 byte] By [vijaytooly] at [2008-2-4]
# 1

Hi,

This is a SQL Reporting Services question rather than a question that applies directly to the Team Foundation reporting subsystem, I would therefore recommend asking it in http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1 as they might be able to provide you with a better answer.

If you want to restrict certain data being shown, I would filter it at the query level so those rows are not returned by the dataset.

Good luck,
Othmane

OthmaneRahmouni-MSFT at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...

Visual Studio Team System

Site Classified