• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1919
  • Last Modified:

SSRS Export To Excel Creating A Blank Row

Hmmm how to explain this.   I am exporting a report via SSRS 2005.  Now the Reprot seems fine but it seems to be adding a blank Row after each Ship to Group, Stopping me from doing a auto filter I have attached a picture of setup and the excel in question
commm.JPG
New.xls
0
gotti777
Asked:
gotti777
  • 3
  • 2
1 Solution
 
sstampfCommented:
You can use the following code:

Sub sDeleteUnUsed()
Dim LastRow As Long, i As Long
Dim rng As Range
LastRow = Range("A65500").End(xlUp).Row
For i = 3 To LastRow
If Range("A" & i).End(xlToRight).Column = Columns.Count Then
If rng Is Nothing Then
Set rng = Range("A" & i).EntireRow
Else
Set rng = Union(rng, Range("A" & i).EntireRow)
End If
End If
Next i
rng.Delete
MsgBox "Done"
End Sub

Open in new window

0
 
sstampfCommented:
You can place the code I provided above in a blank excel file. After that you can open your "problem" file and then keeping the "problem" sheet active call my macro. Let me know if you have any questions.
0
 
gotti777Author Commented:
I will try it out in the morning   I am going to run this report a lot will this code work all the time? Or just for this sheet
0
 
sstampfCommented:
It will work all the time.........
0
 
gotti777Author Commented:
Extra Step but works good thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now