Knowledgebase: Articles
How Do You Configure The Viewer With a Password and Secure/Lock It Down?
Posted by Jeff-Net Fan Support on 28 April 2013 09:52 AM

Question:

How do you configure the Viewer with a password and secure and/or lock it down?

Answer:

Yes, customizing the Viewer and locking it down is very easy. There are over 80 customization options in a file named JNRRV.INI. It's located in your Jeff-Net\Report Runner Viewer public documents folder (not Program Files) by default. Most of the fuctionality of the settings make sense just by reading the names, and settings are toggled on and off with either a 1 or a 0 or YES or a NO. Most of these customization settings are under the top [Options] group.

To set a master password, follow these exact steps:

1) Edit JNRRV.INI and make sure the SavePassword setting is set to "1". We have it set to "1" by default, so it should already be set. Exit and save JNRRV.INI.
2) Start Report Runner Viewer, set your ID/Password on the right and run any report (and make sure No ID/Password Needed is unchecked)
3) Assuming the report runs successfully, exit out of Report Runner Viewer (this should save the ID and password (encrypted) into the JNRRV.INI. If you were to restart the Viewer at this point, the ID and password should already be filled in over on the right side...
4) Re-Edit JNRRV.INI
5) Find the HideRightDataConnection option. Change it from 0 to 1. This setting will completely hide the right side ID/password box (and widen the reports list).
6) Find SaveINISettingsOnExit option. Change it from 1 to 0 (turning it off). By default, everytime the Viewer exits, your last settings are remembered. This will ensure your previous Viewer settings in JNRRV.INI are "locked" and can not be changed.
7) Save and Exit JNRRV.INI and restart the Viewer. You'll see the right side is hidden, and any report you run, should work (assuming it uses the master ID/password you already set up).

That's it! 

Some other settings you may be interested in are:

HideViewSavedButton=0
HideReportInformationButton=0

Set the above settings to 1 if you do not want those buttons to show on the Viewer window.

Next, you can set a default report path or even a path to "lock" all users to under the [Standard Viewer] options:

If you want to allow users to "bounce around" the network finding whatever reports, but you always want them to start in a default location, set DefaultPath to that path (remove the 'tick' mark in front of it).

If you want to "lock" users to a single beginning directory that they can drill down into, but not back out of, set HighPath to that path (and remove the 'tick' mark in front of it). 

LastPath always saves the last path that the last user was in, but since you are setting the SaveINISettingsOnExit to 0, this setting will no longer be updated. So, set this path equal to your DefaultPath setting.

That should get you started. If you have any additional needs, just let us know!

Here is a default view of all of the options in JNRRV.INI:

'-------------------------------------------------------------------------------------------
[Options]
 
DEBUG=YES
DebugErrorsOnly=NO
HideLogPasswords=0
 
LockViewButton=0
LockViewSavedButton=0
LockReportInformationButton=0
 
HideViewButton=0
HideViewSavedButton=0
HideReportInformationButton=0
 
ShowLoginIDAndPasswordOnly=0
 
LockLeftBrowse=0
LockRightDataConnection=0
LockBottomRecordSelection=0
 
HideLeftBrowse=0
HideRightDataConnection=0
HideBottomRecordSelection=0
 
DisableUserConfigurationOfLeftBrowse=0
DisableUserConfigurationOfRightDataConnection=0
DisableUserConfigurationOfBottomRecordSelection=0
 
HidePrintButton=0
HideGroupTreeButton=0
HideExportButton=0
HideRefreshButtonForSavedData=1
ShowParametersPanelFor2008AndGreater=0
 
'Reads registry and loads DSNs in drop-down list
LoadDSNs=1
 
'0 minutes disables auto-close
EnableViewerAutoCloseAtHowManyMinutes=30
DisableUserConfigurationOfViewerAutoClose=0
 
MaximizeViewerWindow=0
 
'2 is "full page"
'1 is "actual size"
ZoomViewer=1
 
SavePassword=1
 
HideStyleAndColorCustomization=0
 
HideEmailButton=0
HideEmailSettingsButton=0
 
ShowAllDirectories=1
 
OverrideDatabaseScheme=
 
MailPort=25
MailSSL=0
MailTLS=0
 
DisableCrystalRegistryUpdates=0
 
HideCopyToClipboardButton=0
EnableClickAndCopyToClipboard=0
HideCopyButton=0
 
'Unhide/0 to show a giant print button on Viewer window
HideEZPrintButton=1
 
'Enabling this button will fetch data from a formula field called {@jnViewerCopyAndPaste}
HideCopyReportDataButton=1
 
'If you have a firewall and it blocks the once-per-day news downloads, setting this to 1 will speed up start-up time
DisableNewsAndUpdatesCheck=0
 
ResetLoginAfterCommandTable=0
 
PromptEachReportForLogon=0
 
UseINIIDAndPasswordToRunPassedReports=0
 
HideRibbonTabHelp=0
HideRibbonTabAbout=0
 
EnableViewerRightClickAutoRefresh=1
ShowViewerButtonsDuringAutoRefresh=0
MaximumAutoRefreshLimit=1
 
HideViewerToolBarOnMaximize=0
HideViewerStatusBarOnMaximize=0
 
'This should not be modified unless you are implementing your own file maintenance
BypassFileMaintenance=0
 
'Continues to try to process report even if connectivity fails
IgnoreTestConnectivity=1
 
'0=Off, 1=On, 2=Always
ShowAlerts=1
 
ShowZeroRecordsReports=1
 
HideAlternateExportButton=0
 
'List of drive letters to NOT load in left side directory structure (ie. X,Y,Z)
DoNotLoadDriveList=
 
'This will store user ID, password, and mail settings separately on a Terminal Server/RDP/Citrix
SaveMultipleIDs=0
SaveMultipleDSNDatabaseAndPaths=0
 
SaveINISettingsOnExit=1
 
 
 
'-------------------------------------------------------------------------------------------
[Global Options]
 
MailDelivery=SMTP
Server=
MailAccount=
MailName=Report Runner Viewer
AuthenticationID=
AuthenticationPassword=
CC=
BCC=
UseFreeServer=0
 
 
 
'-------------------------------------------------------------------------------------------
[Sounds]
 
SoundsOnOrOff=ON
 
 
 
'-------------------------------------------------------------------------------------------
[Standard Viewer]
 
LastPath=
'HighPath=
'DefaultPath=
 
NoSecurityChecked=N
ID=
PW=
DSNChecked=N
DSN=
DatabaseChecked=N
Database=
 
'If ON, report comment files (cache) are saved in Report Runner Viewer\Settings folder in TXT files
CommentsColumnOn=0
CommentsColumnHeader=Report Information
'Comments or Title
CommentsColumnContent=Comments
 
 
 
'-------------------------------------------------------------------------------------------
[Enterprise Viewer]
 
UserDataFile=
ReportsDataFile=
 
'If ON, report comment files (cache) are saved in Report Runner Viewer\Settings folder in TXT files
CommentsColumnOn=0
CommentsColumnHeader=Report Information
'Comments or Title
CommentsColumnContent=Comments
 
 
 
'-------------------------------------------------------------------------------------------
[Icons]
 
Default=jnrr_folder_16.png
 
'Docking=package_16.png
'Help Desk=support2_16.png
'Sales=register_16.png
'Shipping=truck_green_16.png
'Support=support3_16.png
'Testing=pylon_16.png
 
 
 
'-------------------------------------------------------------------------------------------
[Application]
 
Style=1
ColorA=255
ColorR=47
ColorG=54
ColorB=153
 
Report File Name=224
FT=40
DT=40
Destination Name=437
Status/Message=331
Last Run=121
#=31
 
 
 
'-------------------------------------------------------------------------------------------
[Global Parameters]
 
Name=144
Data Type=100
Expression=550
 
 
 
'-------------------------------------------------------------------------------------------
[Groups and Users]
 
ID=100
First=125
Last=125
Group=100
Report Tags=321
 
 
 
'-------------------------------------------------------------------------------------------
[Reports]
 
Type=90
Name=121
FileName=274
Description=292
Report Tags=285
 
 
 
'-------------------------------------------------------------------------------------------
[HelpDesk]
 
CompanyName=
UserName=
EmailAddress=
 
 
 
'-------------------------------------------------------------------------------------------
[Messaging]
 
LastMessageID=0
 
 
 
'-------------------------------------------------------------------------------------------
[Developer]
 
'Your company/organization name; it will display in title bar of main app as Report Runner Viewer for Your Company Name
Company=
 
'Your custom logo file path (like c:\my company logo\logo.jpg) sized at 187x64
Logo187x64=
 
'URL to go to when user clicks on your logo
URL=
 
'http://www.colorschemer.com/online.html
BackColor=0,0,64
 
'Show the spinning gears with message
ShowStatus=YES
 
'This overrides the standard message with one from you
ErrorMessage=There was a problem with the command line options for this report. Please contact Support for assistance.
 
  
 
'-------------------------------------------------------------------------------------------
[MultiUserLocks]
 
 
 
 
'-------------------------------------------------------------------------------------------
[Test Permissions]
 
Permissions=
 
 
 
 
'-------------------------------------------------------------------------------------------
[Crystal Engine]
'Do NOT make changes on these settings unless instructed by Support
DDO=1
CRO=1
DRO=1
DEO=1
DFO=1
 
BCT=0
 
PreLoad=1
 
 
 
'-------------------------------------------------------------------------------------------
[Auto-Backups]
Backups=ON
UploadBackupToDropBox=ON