Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jim123456789jim
Starting Member
13 Posts |
 Posted - 2013-12-10 : 00:52:44
|
| Hi Team,I'm exporting a SSRS report to Excel. For some input parameters the number of rows generated by the SSRS is around 100,000(more than 65000 rows) and it throws an error while exporting.One option what I tried is, to export as CSV and open the CSV and save it as Excel work book(I have office 2010 in my machine). It works, but the problem is, all the column header are displayed as text box names. For ex,(I'm looking for name Emp Name, but it is giving me Emp_Name).Is there any way or work around for this? Please suggest.RegardsJim |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-10 : 05:44:32
|
| you may have to do this using Excel macros. Otherwise only way is to change textbox names to correspond to field names------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
jim123456789jim
Starting Member
13 Posts |
Posted - 2013-12-11 : 01:59:16
|
| I'm facing a problem in changing textbox names to Field names. I'm not able to give 'Space' in the text box names. For ex, Field name "Emp Name" can not be given as Text box name "Emp Name". Any suggestion or work around for this? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-11 : 12:23:41
|
quote:
Originally posted by jim123456789jim
I'm facing a problem in changing textbox names to Field names. I'm not able to give 'Space' in the text box names. For ex, Field name "Emp Name" can not be given as Text box name "Emp Name". Any suggestion or work around for this?
try wrapping them within []------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
jim123456789jim
Starting Member
13 Posts |
Posted - 2013-12-12 : 05:49:45
|
| Tried [] but not working. Getting error "Propery value is not valid. Name can not contain sapces,and it must begin with a letter followed by letters... " Any other suggestion? |
|
|
|
|
|
|
Exporting SSRS report to Excel