RE: [Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0

[Malcolm Burtt]

Title: Message

Hi Matt   I may have added MSPivotTable11 myself. Its been a while since I made these modifications. Have you worked out what the differences are between SP2 and SP3 in this area? I'd like to make sure my application works for Office 2003.   Regards   Malcolm -----Original Message----- From: Matt Birtwistle [mailto:[EMAIL PROTECTED] Sent: 27 September 2004 23:00 To: [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0 Gone back to SP2 and it works fine.   I always thought SP’s were cumulative but I guess not   From: Matt Birtwistle [mailto:[EMAIL PROTECTED] Sent: 27 September 2004 19:27 To: [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0   Found how to create reference to MSPivotTable11 in the BaseEnum.   Problem still not fixed though   From: Matt Birtwistle [mailto:[EMAIL PROTECTED] Sent: 27 September 2004 18:16 To: [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0   Malcolm   I’m unable to compile your mod as the reference to MSPivotTable11 is not recognised. I only see MSPivotTable9 and 10   Regards Matt   From: Malcolm Burtt [mailto:[EMAIL PROTECTED] Sent: 27 September 2004 13:47 To: [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0   Hi Matt   There was some odd stuff (IMHO) in the OLAPPivotTable class that I modified. I don't have Office 2003, so I can't check if mine works for that, but I did make changes to get it to work correctly for Office XP. My code reads....   static str getActiveXGuid(OLAPPivotTableVersion _pivotTableVersion)   {       switch (_pivotTableVersion)       {           case OLAPPivotTableVersion::MSPivotTable9:               return '{0002E520-0000-0000-C000-000000000046}';           case OLAPPivotTableVersion::MSPivotTable10:               return '{0002E552-0000-0000-C000-000000000046}';   // SYP-Modification SP2 - Begin           case OLAPPivotTableVersion::MSPivotTable11:               return '{0002E55A-0000-0000-C000-000000000046}';   // SYP-Modification SP2 - End       }       return '';   } static OLAPPivotTableVersion getAvailablePivotTableVersion(boolean _throwError = false)   {   // SYP-Modification SP2 - Begin       if (OLAPPivotTable::isPivotTableAvailable(OLAPPivotTableVersion::MSPivotTable11))           return OLAPPivotTableVersion::MSPivotTable11;   // SYP-Modification SP2 - End       if (OLAPPivotTable::isPivotTableAvailable(OLAPPivotTableVersion::MSPivotTable10))   // Upgrade Modification on 04 Mar 2004 by MPB - Begin   // Was using version 9 even though 10 was available!!           return OLAPPivotTableVersion::MSPivotTable10;   // Upgrade Modification on 04 Mar 2004 by MPB - End       if (OLAPPivotTable::isPivotTableAvailable(OLAPPivotTableVersion::MSPivotTable9))           return OLAPPivotTableVersion::MSPivotTable9;       if (_throwError)           throw error("@SYS75295",'APPLDOC://Help Topics/OLAPPivotTableSetup');       return OLAPPivotTableVersion::None;   } I hope that helps some..   If you do find that it needs extra modification to get it to wokr with Office 2003, would you drop me a line and let me know what you changed so that I can include it too.   Regards   Malcolm Burtt Global IT Group "Business Solutions designed for YOUR business processes" Global IT Group is the trading name of Touchstone Global Business Solutions Ltd. and is part of the Touchstone Group PLC. -----Original Message----- From: mattbirtwistle [mailto:[EMAIL PROTECTED] Sent: 27 September 2004 11:46 To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0 Is there anybody out there that has found a fix for Pivot Tables not working with Axapta 3.0 SP3 with Office 2003. I get the following error message when trying to call a pivot table: ActiveX Error Unable to create ActiveX Control (Class ID: {0002E520-0000-0000-C000-000000000046}) Is not found on the system, Please check if the control is correctly installed. Followed by an infolog: Unable to call method on ActiveX, wait until object is fully initialised. My pivot tables used to work fine with SP2 Thanks Matt Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/   To unsubscribe from this group, send an email to: [EMAIL PROTECTED]   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.