475 pts.
POSTED: Feb 12, 2009 3:20 AM (GMT)
[...] http://itknowledgeexchange.techtarget.com/itanswers/predefine-a-named-range-for-an-exported-sql-serv… [...]
Predefine a named range for an exported SQL Server Reporting Services report
How can you predefine a named range for an SQL Server Reporting Services report exported to Excel? In particular, the named range must have a specific name, along with referring to a set of cells with specific columns for all rows rendered for the given table control. I am running SQL Server 2005 SP3 with Microsoft Excel 2003.
ASKED:
Feb 10, 2009 9:05 PM GMT
UPDATED:
February 11, 2009 10:10:46 PM GMT
RELATED QUESTIONS
- Are Oracle direct queries straightforward?
- Reporting Services 2005
- Export Crystal Reports to Microsoft Excel format
- SRS 2005 Export to EXCEL
- Automate SSRS report
- Crystal report asks for parameter at runtime eventhough supplied once..
- Sample Test Data from Production in SQL Server 2008
- Rename Sheet when report exported to excel
- SSRS Excel export
- After exporting charts from SQL Server Reporting Services to MS Excel, images appear poor
Answer Wiki:
This function will name a range for you.
Function NameRange(strName As String, strRange as String) As Boolean
strName = Replace(strName," ","_")
On Error Resume Next
ThisWorkbook.Names.Add Name:=strName, _
RefersTo:="=" & strRange, Visible:=True
If Err = 0 Then
NameRange = True
End If
On Error Goto 0
End Function
To call it, pass in the name you want, and the range it refers to. Ex:
Call NameRange("My Range","A1:B100")
The function returns boolean TRUE if successful. Also note that spaces are not allowed, so the function converts spaces to underscores.
HTH
Function NameRange(strName As String, strRange as String) As Boolean
strName = Replace(strName," ","_")
On Error Resume Next
ThisWorkbook.Names.Add Name:=strName, _
RefersTo:="=" & strRange, Visible:=True
If Err = 0 Then
NameRange = True
End If
On Error Goto 0
End Function
To call it, pass in the name you want, and the range it refers to. Ex:
Call NameRange("My Range","A1:B100")
The function returns boolean TRUE if successful. Also note that spaces are not allowed, so the function converts spaces to underscores.
HTH
To see other answers submitted to the Answer Wiki View Answer History.
