SSRS delete blank rows

Please support our MS SQL advertiser: Intel Parallel Studio Home
Thread Solved

Join Date: Oct 2009
Posts: 4
Reputation: azamsalam is an unknown quantity at this point 
Solved Threads: 0
azamsalam azamsalam is offline Offline
Newbie Poster

SSRS delete blank rows

 
0
  #1
21 Days Ago
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
Reply With Quote Quick reply to this message  
Join Date: Oct 2009
Posts: 4
Reputation: azamsalam is an unknown quantity at this point 
Solved Threads: 0
azamsalam azamsalam is offline Offline
Newbie Poster
 
0
  #2
21 Days Ago
i have a this custome code in SSRS but i am getting error msg. i am calling this function from the table footer.

  1. Imports System.Data
  2.  
  3. Public Function GetData(ds as dataset) As String
  4.  
  5. Dim row() As System.Data.DataRow
  6.  
  7. Dim myRow As System.Data.DataRow
  8.  
  9. Dim sStr As String
  10.  
  11. sStr = ""
  12.  
  13. If ds.Tables.Count > 0 Then
  14.  
  15. row = ds.Tables(0)
  16.  
  17. For Each myRow In row
  18.  
  19. if myRow("Comments) <> "" then
  20.  
  21. sStr = sStr & chr(10) + chr(13) & myRow("Provider").ToString() & myRow("Comments").ToString()
  22. endif
  23.  
  24. Next
  25.  
  26. End If
  27.  
  28. Return sStr
  29.  
  30. End Function
  31.  

thanks
Last edited by peter_budo; 18 Days Ago at 6:23 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)
Reply With Quote Quick reply to this message  
Join Date: Oct 2009
Posts: 4
Reputation: azamsalam is an unknown quantity at this point 
Solved Threads: 0
azamsalam azamsalam is offline Offline
Newbie Poster
 
0
  #3
20 Days Ago
i used filter property of the table to remove blank rows
Last edited by azamsalam; 20 Days Ago at 12:42 pm.
Reply With Quote Quick reply to this message  
Reply

Tags
ms, sql

This thread has been marked solved.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC