InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 07:03:56 GMT20http://www.sqlservercentral.com/Forums/Topic1348133-1042-1.aspxThank you Paul! I am new here. I couldn't figure out how to delete a post after I found I had posted in the wrong place. Do you know how to do that or do I need to contact an admin? Thanks, JesseWed, 22 Aug 2012 07:58:48 GMTJesseDWhttp://www.sqlservercentral.com/Forums/Topic1348133-1042-1.aspxCross posting. Please reply here [url]http://www.sqlservercentral.com/Forums/Topic1348134-1044-1.aspx[/url]Please do not cross post.Wed, 22 Aug 2012 07:25:19 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic1348133-1042-1.aspxI have a view in Oracle 11G. I want to show the contents in an Excel 2010 Pivot Table without installing the Oracle Client on my users' machines. So I created a SQL Server 2008 R2 view that queries the Oracle view through a Linked Server. I can run the view in Mgt. Studio. It looks good....I can see the text fields as well as the numeric fields. When I connect to this SQL Server view with the Pivot Table, the numbers disappear.....all zeros! The text fields all look good. I tried to connect with the regular SQL Server Native driver as well as with ODBC and Microsoft Query with the same result. If I connect the Pivot Table directly to Oracle, there is no issue. For whatever reason, this scenario is not yielding results in a Google search. I thought I would check here to see if anyone has seen this before.Thank you for your help!Tue, 21 Aug 2012 16:45:06 GMTJesseDW