Solved

SSRS Export To Excel Creating A Blank Row

Posted on 2010-09-14
5
1,658 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 12

Accepted Solution

by:
sstampf earned 500 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

636 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