Microsoft Dynamics AX

Home » Microsoft Dynamics AX » Microsoft Dynamics AX Forum » All Tags » report

Browse by Tags

Tags
Related Posts

  • Forum Post: Reading Records from Database

    Naeem
    we need to print consolidated bank recon report and customer/supplier consolidated statement from 3 diff companies from same database! is there a ways to have consolidation at subsidiary level?? if not how we can get this report?
    on 19 Apr 2009

  • Forum Post: Filtering Enum value in Microsoft Dynamics AX Reports

    M3mph15
    Hi all, I am developing a report to display activities for employees. Each activity is assigned to an employee and each activity has notes that are recorded in the DocuRef table. These notes can either be External or Internal which is defined in the Restrictions field of the DocuRef table. (By the...
    on 11 Jun 2009

  • Forum Post: Re: Re: Re: Dynamics AX Reporting Services report in Visual Studio

    Cathy N
    Hi Rajdip To display the report from within AX, add a new Output Menu Item in the AOT and select the Object Type "SQLReportLibraryReport". From there you can select your new Report Name from the list. If the Report has been deployed successfully then it should display as a Web part when...
    on 13 Jul 2009

  • Forum Post: Re: Ax 3.0 report viewing percentage

    Sacha Kircev
    Do you mean that you want to give a custom percentage other than the standard ones ? (e.g 109,5%)
    on 24 Aug 2009

  • Forum Post: Re: Report name in AOT from its name in the module ?

    Martin Dráb
    Hi, I am not sure if it is exactly what you want, but you can add the report name to the ReportViewer window title. See example at http://dax-cz.blogspot.com/2009/10/zobrazeni-nazvu-reportu.html (text is in Czech, but there is also source code and screenshot). Best regards, Martin Dráb
    on 27 Oct 2009

  • Forum Post: Customize report dialog

    Mohammed S. Jamous
    Hi, I'm new in AX2009 developing, all what i want is to customize the dialog that appears when i run a report. I already added 2 date fields (FromDate and ToDate) but i cannot select and filter the result based on 2 date fields. the reports that need customization are: Qutation by item, Specify inventory...
    on 2 Nov 2009

  • Forum Post: Form: use right click and setup

    ---
    Hi, I understand you want to customize 2 things: form customizing and report customizing. Read/ buy the book 'inside Dynamics ax 2009'. It give you guidance on how to do things, but not more than that. I gives you the basics on modifying a field and report. Form customizing; right click...
    on 23 Dec 2009

  • Forum Post: JOINT DEVELOPMENT: Item sales key performance indicators

    ---
    Hi, Joint development suggestion like this one for inventory related stuff: https://community.dynamics.com/forums/p/28991/48835.aspx I would dedicate this post to the 'sales per item' instead of 'sales per customer' which is now in AX. I certainly do care about my customers, but...
    on 24 Jan 2010

  • Forum Post: Re: How to remove infolog Report is scaled 93 percent to fit to page. Each Time a report is ran

    Martin Dráb
    Hi, call PrintJobSettings.suppressScalingMessage(true) (you can get the PrintJobSettings instance by calling element.printJobSettings(), for example). BTW you can find this information also in training materials ( Development IV ).
    on 22 Feb 2010

  • Forum Post: Re: Axapta 3.0 - Item description blank

    Martin Dráb
    Hi, the problem could be in incorrect setup of item description for specific language. You can define these descriptions in Setup > Language - Item description (from the Items form). I have only AX2009 at hand, but it is the same in AX3 as far as I remember.
    on 24 Feb 2010

  • Forum Post: DEV-AX: How to add the VendorRef to the top of the Ordered Item report? + code sample.

    ---
    Hi, As reported in the product suggestion tool it would be a essential that not only internal numbers but also external data of vendors, customers, invoices etc. are clearly visible to the end user. Please find attached a simple code modification for adding the VendorRef to the Ordered item Report...
    on 8 Mar 2010

  • Forum Post: Re: How to display total in Reports?

    Martin Dráb
    Hi, you can use a report control of the Sum type (for summing based on a single table field) or your own calculation logic (send() method is often good place for it).
    on 17 Mar 2010

  • Forum Post: Re: Re: Re: How to display total in Reports?

    Martin Dráb
    For an example of using the Sum control, see the tutorial_CustomizedSumDescription report. For a custom calculation, see - let's say - CustSalesItemGroupStatistics_NA report (and calculation of totalGroupAmount) - it is (of course) only one from many possibilities how to implement it. For completeness...
    on 17 Mar 2010

  • Forum Post: How to allign empty report?

    P.RAM
    Hi, I wanna to create Empty report it contain Static text...But allignment of that report is difficult any EASY way of creating empty reports.....
    on 19 Mar 2010

  • Forum Post: Customize standard report with field from different table

    Greg R
    Good afternoon all, The scenario is this: I am editing the LedgerTransListAccount report (on the menu, it's call Ledger transaction list). The report pulls most of the data from the LedgerTrans table. The customer's data will sometimes contain a specific vendor account number as the first 6 characters...
    on 25 Mar 2010

  • Forum Post: Enum Parameter

    Lauren C
    My report has a parameter which uses a base enum. The enum has 4 different options to choose when running the report. How do I insert an option which uses all 4 at once? For example, I have an enum named Phone and it has 4 types: 1 = None, 2 = Home, 3 = Mobile, 4 = Work. In a drop down, how do I add...
    on 19 Mar 2010

  • Forum Post: Help with MaxOf function

    Lauren C
    I need to use the maxof function to get the max startdate of salary for an employee. Here is my query in SQL: ( SELECT EMPLID , MAX ( STARTDATE ) RECENTDATE FROM HRMPAYROLLLINE GROUP BY EMPLID ) A ON EMPLTABLE . EMPLID = A . EMPLID AND HRMPAYROLLLINE . STARTDATE = A . RECENTDATE I am having...
    on 30 Mar 2010

  • Forum Post: Re: Print Report to Printer through X++ Code in DAX 2009

    Justin Biggs
    Normally what you're trying to do would work ok. The sales documents though work a little differently (Confirmations, Packing Slips, Invoices, etc). Since these reports normally will print during the posting process associated with it, the printer settings are pulled from the associated SalesFormLetter...
    on 8 Apr 2010

  • Forum Post: Setup one Report for dot-matrix and inkjet?

    Greg R
    Hello. I need to create a new, custom report that could be printed on a standard ink jet printer or on a dot-matrix printer. Is this possible, or do I need to create two different reports? The report is very customized; it does not just display data directly from the database. It will have one line for...
    on 16 Apr 2010

  • Forum Post: report: how to add subtotals by 2 fields, but grand total only by one of them

    Mirk
    I have a report, that has 2 fields , that should be subtotaled, but the grand totals should be shown only for one of these fields. Is it possible to do without programming and what's the best way to do it? Currently i consider modifying the footer() method and hide one of the fields if it's...
    on 25 Apr 2010

  • Forum Post: Report won't save to file, but will open on screen

    Lauren C
    I have a report that will not save to file. It runs through the motions and counts the pages as the report runs, but when I go look for the report, it's is not saved to a file anywhere. I have tried with another report and it does save to file in the location I tried to save the other report. Here...
    on 29 Apr 2010

  • Forum Post: Drill Down on Standard DAX 2009

    Vijesh Jayathilakan
    When I searched for Drill Down Reports on DAX 2009 I found this under the topic Microsoft Dynamics AX standard reports Standard reports may contain orange links and blue links. Blue links Blue links indicate that you can drill down into related data. Click the blue link to view the...
    on 16 Jun 2010

  • Forum Post: PDF created with wrong font

    Bob Martin
    I have a user who creates a PDF that has WingDings for the font instead of the standard font. Their profile is set to use the standard font and the report is designed for the standard font. This same user has CutePDF installed and when they print to the PDF printer, report displays correctly. Any...
    on 15 Sep 2010

  • Forum Post: * JOINT DEVELOPMENT * Sales statistics query with InventDimensions

    ---
    Hi, We need sales, claim (defects/ scrapped) and return statistics per item and per size. I do not see such reports in AX although I think it is a quite obvious (standard) report. If it exists it will save me lots of time. I came across 'statistics' on the Item Form --> Inquiries ->...
    on 13 Apr 2010

  • Forum Post: Change Autosum labels in reports

    ral2108
    When creating a report, you can set a field to order by and set the AutoSum property to yes. When running the report, it uses the field's label when generating a summation. Is there any way to change this label to say something like "Total:" instead of the field's label? Thanks!...
    on 29 Nov 2010
123