hi,
I would like to make report with SalesTable and SalesLine tables.Below is target design:
SalesId | CustAccount
- ItemId | qty
- ItemId | qty
SalesId | CustAccount
- ItemId | qty
- ItemId | qty
and so on
Can I do this wihout programming?
Depending on AX version you get a couple of ways to achieve this.
1) In AX2009 you can use so called Report Builder which is arguably the very best AX reporting tool which requires no to very minimum AX development skills. With Report Builder you will get a chance to fine tune the design of your report very easily.
Take a look at this blog about Report Builder:
2) On the other hand, you may also try out a so called Report Wizard tool which is available in all AX versions.
Open the AX development window (Ctrl+D) and from the top menu take this: “Tools > Development tools > Wizards > Report Wizard”
Here is a good blog describing how to use AX Report Wizard:
http://dx-solutions.blogspot.ch/2009/09/dynamics-ax-report-wizard_03.html
Janis is correct in what he says.
However for well-designed robust reports you should use SSRS reporting, this takes some setting up but is well worth it.
Janis is correct in what he says.
However for well-designed robust reports you should use SSRS reporting, this takes some setting up but is well worth it.
- Go to → Reports → new report
2.Expand report → Data sources ->Query->Data sources Add Sales Table
3.Expand sales table ->data sources → add salesline Table
4.Go to designs → new reports design → new Autodesignspecs
5.Add some fields like salesid and customerAccount in one body
add some fields ItemId and Qty
then open report
see as per requirement
Yeah developing Report using SSRS through RDL gives better looks and its easy to design it.
they ask only report for our design that only for code