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.
i have a this custome code in SSRS but i am getting error msg. i am calling this function from the table footer.
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()
by peter_budo: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)
If you're in one of those predicaments where cls.__private attributes just aren't enough since they can easily be accessed through inst._cls__private, and you need something a little more secure, here's ...