Showing posts with label searched. Show all posts
Showing posts with label searched. Show all posts

Monday, March 12, 2012

Reports exported as Excel cannot be read by Mac version of Excel

I searched the list but did not see anything related.

I cannot open a file directly exported from RS in the Excel format. If I open the file in the Windows version and then close it, no need to even save it, I can then open it with the Mac version of Excel. The file size after closing is about 2K less so the RS program is adding something onto the file that the Mac version does not like. It will crash Excel when trying to open.

I cannot export the report as CSV as it will not correctly import into Excel on the Mac.

Is there a work around for this?

Thanks.

--seani have the exact same problem. the excel files open on windows fine, but on the mac they crash excel. if you start excel and then use file-> open, it just hangs.|||

I am also having this problem with users trying to open the xlm file created from RS and using a MAC. Please let us know what is causing this problem and how to correct it.

I will note the spreadsheet did open for the user when they used EXCEL 98, but doesn't work with EXCEL 2001 or EXCEL 2004.

I found this http://support.microsoft.com/kb/918529 . It fixes 2005 SQL server but I see nothing for SQL server 2000.

Thanks.

|||

Hey, I'm also have this problem, I read that the SP2 of SQL Server 2005 fix this problem, but we are having some problems with SSAS and the SP2, so we can't install it.

Doe's any one installed the fix mentioned in the post above? ... Any troubles? ... Thanks!

|||We installed SP2 and low and behold the problem is gone. Our MAC users are very happy.

Thanks.

--sean

Reports exported as Excel cannot be read by Mac version of Excel

I searched the list but did not see anything related.

I cannot open a file directly exported from RS in the Excel format. If I open the file in the Windows version and then close it, no need to even save it, I can then open it with the Mac version of Excel. The file size after closing is about 2K less so the RS program is adding something onto the file that the Mac version does not like. It will crash Excel when trying to open.

I cannot export the report as CSV as it will not correctly import into Excel on the Mac.

Is there a work around for this?

Thanks.

--sean
i have the exact same problem. the excel files open on windows fine, but on the mac they crash excel. if you start excel and then use file-> open, it just hangs.
|||

I am also having this problem with users trying to open the xlm file created from RS and using a MAC. Please let us know what is causing this problem and how to correct it.

I will note the spreadsheet did open for the user when they used EXCEL 98, but doesn't work with EXCEL 2001 or EXCEL 2004.

I found this http://support.microsoft.com/kb/918529 . It fixes 2005 SQL server but I see nothing for SQL server 2000.

Thanks.

|||

Hey, I'm also have this problem, I read that the SP2 of SQL Server 2005 fix this problem, but we are having some problems with SSAS and the SP2, so we can't install it.

Doe's any one installed the fix mentioned in the post above? ... Any troubles? ... Thanks!

|||We installed SP2 and low and behold the problem is gone. Our MAC users are very happy.

Thanks.

--sean

Reports exported as Excel cannot be read by Mac version of Excel

I searched the list but did not see anything related.

I cannot open a file directly exported from RS in the Excel format. If I open the file in the Windows version and then close it, no need to even save it, I can then open it with the Mac version of Excel. The file size after closing is about 2K less so the RS program is adding something onto the file that the Mac version does not like. It will crash Excel when trying to open.

I cannot export the report as CSV as it will not correctly import into Excel on the Mac.

Is there a work around for this?

Thanks.

--seani have the exact same problem. the excel files open on windows fine, but on the mac they crash excel. if you start excel and then use file-> open, it just hangs.|||

I am also having this problem with users trying to open the xlm file created from RS and using a MAC. Please let us know what is causing this problem and how to correct it.

I will note the spreadsheet did open for the user when they used EXCEL 98, but doesn't work with EXCEL 2001 or EXCEL 2004.

I found this http://support.microsoft.com/kb/918529 . It fixes 2005 SQL server but I see nothing for SQL server 2000.

Thanks.

|||

Hey, I'm also have this problem, I read that the SP2 of SQL Server 2005 fix this problem, but we are having some problems with SSAS and the SP2, so we can't install it.

Doe's any one installed the fix mentioned in the post above? ... Any troubles? ... Thanks!

|||We installed SP2 and low and behold the problem is gone. Our MAC users are very happy.

Thanks.

--sean

Saturday, February 25, 2012

Reporting web services

Has anybody used the sql reporting services web service?

If so, can anyone share an example?

I have searched google and didn't find nothing!!!

Thank you!

Personally I'm interested in an example of any kind of web service. Thanks.|||

I created a DotNetNuke module to display report from MS SQL Reporting Services. Demo and EXE program can be downloaded from http://dnndev.icpconline.com. In VS 2003, I created a web ref to the server web service URL (ie. http://yourserver/reportserver/reportservice.asmx). The web service exposes method to retrieve reports from the server.

Source code is available to authorized developers.