Open the module, choose the report but dont view it.
Press ctrl+F2, and then go to view - sections.
Showing posts with label Report. Show all posts
Showing posts with label Report. Show all posts
Reports have several purposes in Navision:
· Reports are used to print information from a database in a structured way. For
example, you can create a report that lists all the customers and all the orders
placed by each customer.
· Every application document must be created as a report. For example, to print an
invoice, you must create a report that is automatically filled out with the relevant
information.
· Reports can also be used for other tasks and not just for printing. A report can be
used to automate many recurring tasks such as updating all the prices in an item
list. This could be achieved by writing C/AL code in a codeunit, but using a report is
much easier because you can take advantage of the powerful data modeling
facilities available in the report designer.
If you have certain report that you only want users to be able to preview but not able to print out the hard copy, you can add the following code at the on prereport trigger:
IF Not CurrReport.PrintPreview THEN
Error('This is a Preview only report');
Whenever you click on the Print button to print the report through printer, the message will come out 'This is a Preview only report' and prevent you to send the report to printer.
1) Open the Properties window (SHIFT + F4) of the data item that you want to group.
2) Enter the name of the field that you want to group by at the GroupTotalFields property.
3) Select a key for the DataItemTableView property. You must select a key that contains the field that you want to group by. Otherwise, the grouping won't work.
4) Enter the names of the fields that you want Navision to calculate based on the grouping. The calculated value can be shown in the Group Footer section.
5) Close the Properties window and open the Layout view.
6) Press F3 to insert a Group Header section.
7) Press F3 to insert a Group Footer section.
8) Add a field to the Group Header or Group Footer.
Read More..Tools-object designer-table
Select sales line, then run..
Find Qty to ship, filter <>0
Ctrl C & paste to excel file.
Done.
Go to tools-object designer-Table-PUrchase line
Then Run...
Select qty to receive, filter <>0
Block all the fields, ctrl C then paste to excel file.
Subscribe to:
Posts (Atom)
Posts
