axapta - How to show a row total amount by group CG Group in Report -

-

I am using Excel 3.0 with language X ++.

I am making a report based on available reports.

Examination: available report 

  CG code amount current 1-30days: new report only shows total line of group CG group instead of showing as old report is. 31-60days 61-180 days & gt; 180days 1.1 50 10 100 30 10 5 ---------- 1.1 30 20 60 35 20 20 ---------- 1.1 20 30 80 7 80 60 -------- - 1.2 30 50 50 1 100 80 ---------- 1.2 40 70 90 5 75 15 ---------- 2.3 100 20 20 150 20 30 ------- --- 3.1 60 10 10 80 10 4 ---------- 3.1 30 60 5 100 5 60

New report in the form of a sample:

< Pre> CG code amount current 1-30days 31-60days 61-180 days & gt; 180days 1.1 Total 100 60 240 92 110 85 ---------- 1.2 Total 70 120 140 6 175 95 ---------- 2.3 Total 100 20 20 150 0 30 ----- I think that the code in the available report's code is 
  select AmountMST from CustTransOpen Where custTransOpen.AccountNum == CustTable.AccountNum & amp; ; & Amp; CustTransOpen.TransDate & lt; = BalanceAs & amp; Amp; CustTransOpen.TransDate & gt; = Compare 1 & amp; Amp; CustTransOpen.TransDate & lt; = Compare 2

I created a view to get data from 2table (Custtransopen, Custtable) with the name SKV_CustAgỉng3, then I write the group as a CG group as SQL: / P> 

  Select the zodiac sign (AmountMST) from the SKV_CustAging3 group by the Statistics Group, where the SKV_CustAging3.TransDate & lt; = BalanceAs & amp; SKV_CustAging3.TransDate & lt; CompareDate1;

I try to use the "section group" for the total amount of each group of CG, but the report still shows in detail and the end of the section group shows the total amount .

In my opinion, I want to show the total amount of a line by Group CG Group on the same example above the new report.

Is there any way to show only one record sum amount for every CG?

Please help me I am the new officer to make this report, so I do not know a lot about Axapa. Thank you.

Try to override the sending () and fetching () methods of your report to bring the records Except Call Fetch () will be printed and sent Axapta calls for each row printed in the report () method. Expansive Developers Guide contains detailed information for this method.

  • To print the data.

    • To find more examples, search the AOT with the words "Send" and "Fetch".


    Comments

    Post a Comment

    Popular posts from this blog

    c# - How to capture HTTP packet with SharpPcap -

    -
    I would like to capture all incoming HTTP packets on my machine. To do this, I am using SharpPcap which is a WinPcap The cover is. SharpPcap works very well, but it captures TCP packets and what it wants to do for me is a very low level. Does anyone know how can I easily get full HTTP requests / reactions from all these TCP packets? Thanks SharpPcap is already able to capture the packet in the same way That's what the virus does (just in the code instead of the GUI). And you can either either parse them directly or you can put them in the drive in the common .pcap file format. The steps to parse the capture are: Open a connection at any time Loop a while Or start capturing using an event callback Parsing the raw packet for the type you want If you are reading .PPP dump files In addition to calling you an offline capture reader is almost the same, there is no need to select an interface, and you can set the majority There is no need to do the modes. All st...
    Read more

    php - Multiple Select with Explode: only returns the word "Array" -

    -
    By using Wordpress I have created a multiple selection box so that users can select categories to exclude. When the page is initially loaded, I see my predefined default option. However, when I select a new value and I save ... I only see the word "Array" and have not chosen anything else? & lt; Class = "amultiple" id = "& lt; php echo $ value ['id'] ;? gt;" name = "& gt; php echo $ value ['id'] ;; gt; []" Multiple = "multiple" size = "8" & gt; & Lt ;? Php global option; Foreign currency ($ value as value $) {if (get_settings ($ value ['id']) === FALSE {$$ value ['id'] = $ value ['std']; } And {$$ value ['id'] = get_settings ($ value ['id']); }} $ Ranges = & amp; Amp; Categories ('type = post & orderbiz = name & amp; hide_empty = 1'); If ($ ranges) {$ ex_cat = implode (',', $ tt_cat_exclude); Forex Currency ($ range a...
    Read more

    php - jQuery AJAX Post not working -

    -
    I do not understand why this script does not work. It has something to do within AJAX PostScript / Function. Right now, when I submit my form, it runs php code on the same page. What it should do, send the values ​​of the form for Project_Azax.fp, then there will be a refund of success on the page which is correct or false. $ (document) .ready (function () {$ ('div # didIt'). Hide (); $ ('form [name = adminForm]'). Submit (function () ($ {'.post' ('/ project_ajax.php', {action: $ ('[name = action]') Val (), pId: $ ('[name = pId]'). Val (), name ('[Name = name]'. Val (), url: $ ('[url = url]'). Val (), summary: ('[summary = summary]'). Val ()}, Function (data) {if (data.success) {$ ('div # didIt') .Sliddown ('slow');} and {warning ('unsuccessful SA!');}}, 'Jason'); return false ;});}); What is the code for project_ajax.php below ... if ($ _ POST ['action'] == ...
    Read more