Can I run a report via the command line? How?

Question: How do you run reports via the command line with Report Runner Viewer?

Answer: The basic keywords available via the command line in the Standard edition are:

1. jnReport=PathAndReportFileName
2. jnID=DatabaseID
3. jnPassword=DatabasePassword
4. jnRecordSelection=RecordSelection (for "quotes" around strings, use a double pipe symbol: ||)
5. jnDSN=DSN to use instead of DSN stored in report
6. jnDatabase=Database to use instead of Database stored in report

---
      
If you have a DEVELOPER add-on license (or Viewer Infinity license), these additional keywords are available (these also work with a 45 day evaluation license):

1. jnParm1=Parameter1 (set up to 30 parms --- jnParm2=, jnParm3=, jnParm4=)
2. jnPrinter=PrinterName (setting a printer also bypasses viewing of the report)
3. jnCopies=99 (number of copies)
4. jnAutoRefresh=99 (number of minutes to automatically refresh the report without user interaction)
5. jnHideWindowTitle=1 (setting to 1 enables report to be viewed when maximized without a title bar)
6. jnBuzzIfReportChangesDuringRefresh=1 (plays a sound if data changes in a report that's been set to auto-refresh)
7. jnHideGroupsPanel=1 (setting to 1 hides the group tree panel and disables the ability to toggle it on and off)
8. jnHideParametersPanel=1 (setting to 1 hides the parameters panel and disables the ability to refresh reports)
9. jnDisableDrilldown=1 (setting to 1 disables the ability to drill down into the report by clicking on group values/totals)
10. jnGroupRecordSelection=GroupRecordSelection (for "quotes" around strings, use a double pipe symbol: ||)
11. jnOutputFileName=c:\whatever path\and directory\filename.pdf
12. jnOutputFileFormat=PDF (default is PDF if not specified with jnOutputFileName or any other valid format listed below)

Valid File Formats to Use with jnOutputFileFormat:

• PDF
• PDFB (PDF with bookmarks)
• RPT (Crystal Reports format)
• RPTR (Crystal Reports format and read only)
• XLSDT (Excel Data Only - Typical)
• XLSDM (Excel Data Only - Minimal)
• XLSN (Excel Whole Report)
• XLSX (Excel XLSX Data Only)
• SEPC (Comma Separated Values - Details Only)
• SEPCN (Comma Separated Values - Details Only - No Quotes)
• TXT4 (Text - Non-Paginated (0) - 12 CPI)
• TXTP (Text - Paginated (60) - 12 CPI)
• SEPT (Tab Separated Values - Details Only)
• SEPT1 (Tab Separated Values - Details and Groups)
• SEPT2 (Tab Separated Values - All)
• TSEP1 (Tab Separated Text - No Quotes)
• TSEP2 (Tab Separated Text - Quotes)
• TSEP3 (Tab Separated Text - Quotes and Blank Lines)

---
    
Another feature of the Developer license is the ability to customize the logo shown in the lower left corner of the Viewer window and customize the color of the bottom section of the Viewer window. You configure this by modifying the [Developer] settings in JNRRV.INI:

    
---

Sample command line:

"C:\Program Files (x86)\Jeff-Net\Report Runner\Report Runner Unified.Exe" jnReport=c:\MyReports\Report1.rpt jnID=sqlsusan jnPassword=Reports!1 jnParm1=May jnParm2=2022 jnDisableDrilldown=1

---