i am using SSRS 2005. In my dataset there are some blank rows and in SSRS is showing blank rows. Is there a way that i just show rows with data and ignore blank rows. i set the visibility property but it is showing blank line.

dataset:

a
b
c
blank
d
blank
blank
e

i want output like:

a
b
c
d
e

Thanks

i have a this custome code in SSRS but i am getting error msg. i am calling this function from the table footer.

Imports System.Data

Public Function GetData(ds as dataset) As String

Dim row() As System.Data.DataRow

Dim myRow As System.Data.DataRow

Dim sStr As String

sStr = ""

If ds.Tables.Count > 0 Then

row = ds.Tables(0)

For Each myRow In row

 if myRow("Comments) <> "" then

  sStr = sStr &  chr(10) + chr(13)  & myRow("Provider").ToString() & myRow("Comments").ToString()
 endif

Next

End If

Return sStr

End Function

thanks

i used filter property of the table to remove blank rows

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.