NPR report writers at MAGIC sites probably know that you can write code anywhere in a MAGIC report to put a file name into /ZFTP.TITLE and if the report is scheduled to Auto FTP, the file name created by the report code will be used instead of the default file name based on the report title.
If you need to write an NPR report and find all records with no value (nil) in a field, you can often write a simple selection EQ nil. For example if you want to find all entries in your discharge disposition dictionary that do not have a "billing code" (@ub82.code) field value,
Creating a download report is streamlined in the Report Designer, although it was not that difficult in the NPR Report Writer. If you designate a report format as Export rather than Standard on the General page, the Regions and Layout Pages become unavailable and the Fields page has a setting for download: