News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) How to get the total ...

Microsoft Dynamics GP (Archived)

How to get the total number of record in PM Payment Apply To WORK file (in Report Writer)

(0) Share

Report

Report

Posted on by wkz0

20

Could you please advise me, in the Report Writer on how to get the total number of records in the

PM Payment Apply To WORK file where this figure is need to be printed onto the report header.

If there is any function that can get this figure or do I need to use any other script or SDK to achieve this requirement. But i really do not wish to use script/VBA or SDK.

Appreciate for you help and many thanks in advance.

http://img697.imageshack.us/img697/2600/20100316recordcount.png

how to get total records count in PM Payment Apply to WORK file

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: How to get the total number of record in PM Payment Apply To WORK file (in Report Writer)

Hi, not sure if this is waht you want, but you can get the total number of records displayed on the report. Simplest would be to add a key field such as Document Number to the report footer or header, and set it to 'Count'...when the field is dragged onto the report, double click it and set its format to 'Count'.

This field will then count the number of times the field appears in the report body.

Best regards,

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2

Martin Dráb 230,458 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans