Malcolm I'm afraid I haven't worked out the differences, but I'm not a technical person! The release notes for SP2 make a definitive statement that Office 2003 is supported for Pivot tables, but no mention is made in the notes for SP3 of any conflicts. So that you know, when I rebuilt my applications with SP2 last night I didn't need to apply your fixes. The modifications that SP2 has made that are referenced "SYP-Modification SP2" hadn't carried through to SP3 Regards Matt
________________________________ From: Malcolm Burtt [mailto:[EMAIL PROTECTED] Sent: Tue 28/09/2004 09:20 To: [EMAIL PROTECTED] Subject: RE: [Axapta-Knowledge-Village] Pivot Tables in Axapta 3.0 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 click here <http://us.ard.yahoo.com/SIG=129e5mk7t/M=295196.4901138.6071305.3001176/D=groups/S=1705001380:HM/EXP=1096446056/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> ________________________________ 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] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. 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: http://docs.yahoo.com/info/terms/
<<winmail.dat>>