Wednesday, March 28, 2012
Having Problems exporting to Excel
I am facing problems while exporting a report to Excel format
I am using Excel 2000 bundled with MS Office 2000 and RS Evaluation version
Do I need to do any configurations,
Is any one facing the same issue or a problem with my installation
Can anyone help regarding this...
Regards,
GirishYou need RS SP1 to export to Excel 2000
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Girish Kumar" <GirishKumar@.discussions.microsoft.com> wrote in message
news:1F82A63A-32C4-45D0-9F5C-DC949A95B14C@.microsoft.com...
> Hi all,
> I am facing problems while exporting a report to Excel format
> I am using Excel 2000 bundled with MS Office 2000 and RS Evaluation
version
> Do I need to do any configurations,
> Is any one facing the same issue or a problem with my installation
> Can anyone help regarding this...
> Regards,
> Girish
having problem while connecting sql 2000
im using sql server 2000 and i m facing this problem
plz tell me why is this
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
You failed to connect into the SQL server. I think the IP or the host name is wrong.
Check the following site for connectionstrings
www.connectionstrings.com
Regards
|||Also make sure Named Pipes and TCP/IP network libraries are enabled for the SQL2000 instance. You can easily archieve this in Server Network Utility.|||hai dude
i want to mentions one thing that i have previously used the same connection class made my self for connecting to the db..
but now on new another pc with new installation of sql server ,,having the same previously used setting.,,its not woking,,,
one thing more im not usgin ip based connection string ...
|||Why not use IP based connection string? IP is often more reliable than machine name, for example when DNS does not work properly so the machine name can't be intepreted?to IP.|||
yah thanks dude
its done