RE: [Axapta-Knowledge-Village] Changing Properties of Fields in Field Groups
Title: Message Bob, on the groups properties, change the AutoFieldGroupOrder to 'save the fields properties'. This should allow you to modify and save them. Regards, Jason Milburn Nexgen Enterprise SolutionsBliss House251 Dewsbury Road, Ossett, WF5 9QF A member of The ERP Group Ltd. www.theerpgroup.co.uk -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 07 October 2004 13:41To: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village] Changing Properties of Fields in Field GroupsHi All, Does anyone know if it is possible to modify the properties of fields in field groups. I created a report with the report wizard. When I select properties on a field in a group the properties display but cannot be modified. Thanks, Bob Bob BrinkerOakdene Group, Inc.2625 Butterfield Rd. (Suite 212E)Oak Brook, IL 60523-1261(630)368-1046 x/230(630)368-1050 (Fax)[EMAIL PROTECTED] 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.
RE: [Axapta-Knowledge-Village] Hi, Reporting
Title: Message Hi I have only recently started programming in Axapta and had a lot of problems starting reports. My advice would be, Always create a project to contain you reports, tables etc. This makes it easy to export and import the xpo. For compile just open the project and click the compile icon, but it should compile when you import the xpo. To create a report, right click in the project, create new report. Then expand and right click on design and create new design. Then right click on design and generate design. Then right click on the generated design to add report sections, header, body footer etc. Add a data source to make fields available in the report. Just create a report to try things out and after a while you will get the hang of it. See the developer documentaion for more info. I would try to avoid using the graphical report designer to add and move fields and it does not always work - and never press delete key in here as it can delete a whole section. This has happened to me. Another word of advice, save you project regularly and export the xpo aswell for extra backup. Jason -Original Message-From: ottawa_m2003 [mailto:[EMAIL PROTECTED] Sent: 13 August 2004 20:18To: [EMAIL PROTECTED]Subject: [Axapta-Knowledge-Village] Hi, Reporting Hi,My company wants me to do reporting stuff.I want to know the basics of reporting1. How to create a report?2. where to put the code?. I know X++.3. Any cubes related work do i need to do?.4. How to compile the code in report?.Your help will help a lot to me.cheers,OttawaSharing 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.
RE: AW: [Axapta-Knowledge-Village] SQL Select in axapata (X++)
Title: Message Thanks all. That works great. Jason -Original Message-From: Girish B [mailto:[EMAIL PROTECTED] Sent: 29 July 2004 11:49To: [EMAIL PROTECTED]Subject: Re: AW: [Axapta-Knowledge-Village] SQL Select in axapata (X++) select maxof(IDNumber) from myTable; lastIDProcessed = myTable.IDNumber;--- "Theissen, Annette" [EMAIL PROTECTED]wrote: Please try maxof instead of max: select maxof(IDNumber) from myTable; Bye, Annette Mit freundlichen Grüßen / Best regards Dipl. Phys. Annette Theißen System Software Entwicklung __ Viscom AG - Carl-Buderus-Str. 9-15 - D-30455 Hannover Phone: +49/511/94996-0 - Fax: +49/511/94996-900 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] - http://www.viscom.de http://www.viscom.de/ -Ursprüngliche Nachricht- Von: helpmeobwan [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 29. Juli 2004 12:00 An: [EMAIL PROTECTED] Betreff: [Axapta-Knowledge-Village] SQL Select in axapata (X++) I have connected to an access database using selectstatement. Now I want to connect to another table and get the lastest IDNUmber. select max(IDNumber) from myTable; lastIDProcessed = max(IDNumber); But axapta reports a syntax error on the select statement. I do not use SQL much but I think the statement is ok. Does anyone know how to do this in X++ ? JSharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT http://us.ard.yahoo.com/SIG=129vkbu8k/M=295196.4901138.6071305.3001176/D=groups/S=1705001380:HM/EXP=1091181608/A=2128215/R=0/SIG=10se96mf6/*http://comp anion.yahoo.com click here http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S= :HM/A=2128215/rand=939069220 _ Yahoo! Groups Links * To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] ribe * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service http://docs.yahoo.com/info/terms/ . ___ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.comSharing 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.