[Axapta-Knowledge-Village] Re: Total Amount Missing
Hi, Ok, thanks for answer, I'll try to be more understandable... :) Let's work on PO lines. I check Qty and Net Price on the report menu. In print options, my query is Status : Received. In the order options, I order by ItemId (with Header checked) And I asked the Grand Total, in order to have the total amount of all my ordered and received items... The result is : my report well generated and the text Grand Total displayed but with no value... Can you have it displayed ? (Do I have something to do with AOT and GrandTotal fields in Report properties ?) Many thanks in advance for your answers, Stephane --- In Axapta-Knowledge-Village@yahoogroups.com, Subrahmanyam Mamidi [EMAIL PROTECTED] wrote: Hi, I can print the total amount and Grand Total at AP/Reports/Trans/Po/PO lines. You can play around with select/print Options. And also, please let us know what are you using in ur query I am not sure why you are not able to print. May be someone in the group should help you. thanks, Subbu Stephane Laulhere [EMAIL PROTECTED] wrote: Hi there, I can't manage to have a total amount in 2 reports (in fact, many more, but I do need these 2...) : Cust/Report/Trans/Orders/Order lines (sorry my axapta is in french... I don't know the true names of menues...) (for french speaking people : Clients/Etats/Transactions/Commandes clients/Lignes de commandes) and Vend/Report/Trans/Orders/Purchase lines (sorry again) (as well for french : Fournisseurs/Etats/Transactions/Commandes fournisseurs/Lignes d'achats) The only thing I get, at the pagefooter is a text marked : Total Amount and/or Grand total Amount (total general et super total general), but no value with it, the rest of the line is empty !!! Anyone can help me ? Many thanks in advance, Stephane Laulhere Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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/
[Axapta-Knowledge-Village] Re: Howto from a newbie to this group
Many thanks Allan ! You can find the number of records selected in a datasource with total = SysQuery::countTotal(CustTable_ds.queryRun()); (this works fine. And I'm starting to understand many things with datasources with this exemple...) 3- Furthermore, if I want to get back the parameters of a request (fields + criteria) from a search or a filter command, how can I do that ? Try running the report from a class, that will give you a prettier front-end Have a look at the class CustReport_Auditor, it gives you a simple example LastValueElementName() must return the name of your report. e.g. public identifiername lastValueElementName() { return reportStr(YourReportName); } For this part, I don't have access to classes development... Hope this helps (sure it helps ! many thanks again) Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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/
[Axapta-Knowledge-Village] Howto from a newbie to this group
Hi there, First, hello everybody. I've just found this group, I hope it will help me a little in this Axaptian deep ocean... 3 questions to start : 1- Is there anybody french (or french-speaking) in this group ? 2- I want to make a select count(*) from an overview (in any form, but let's take the custtable form). Just to get the number of records my request gave me. How can I code this ? 3- Furthermore, if I want to get back the parameters of a request (fields + criteria) from a search or a filter command, how can I do that ? (let's say I have to click on a home-made-report button, which list me the content of the overview list in a form. If I click on the autoreport button, it works, but it's ugly...) Many, many thanks in advance for your answers, SteF from Bordeaux,France. If custom office agrees, i send a bottle of wine to the first guy who respond to me ! :) Yahoo! Groups Sponsor ~-- Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/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/