Showing posts with label Report. Show all posts
Showing posts with label Report. Show all posts

Friday, 17 October 2008

Report Grouping and Totalling

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.

Saturday, 5 April 2008

Page Counter (N of M)

Here are few useful resources on this topic:
Mibuso - Page Counter (N of M)
Mibuso - Page N or M
Mibuso - Page of Pages Solution
Mibuso - Numbering report pages

Print Preview only Report

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, Navision will raise the error 'This is a Preview only report' and prevent you to send the report to printer.