0

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

1
Contributor
2
Replies
4
Views
7 Years
Discussion Span
Last Post by azamsalam
0

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

Edited by peter_budo: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)

0

i used filter property of the table to remove blank rows

Edited by azamsalam: n/a

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.