Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSRS Export To Excel Creating A Blank Row

Posted on 2010-09-14
5
Medium Priority
?
1,780 Views
Last Modified: 2012-06-27
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
Comment
Question by:gotti777
  • 3
  • 2
5 Comments
 
LVL 12

Accepted Solution

by:
sstampf earned 2000 total points
ID: 33677397
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
 
LVL 12

Expert Comment

by:sstampf
ID: 33677530
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
 

Author Comment

by:gotti777
ID: 33678020
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
 
LVL 12

Expert Comment

by:sstampf
ID: 33680183
It will work all the time.........
0
 

Author Closing Comment

by:gotti777
ID: 33695377
Extra Step but works good thanks
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question