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 100 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]
HideLogPasswords=1
DEBUG=YESDebugErrorsOnly=NODebugXREF=YESDebugRPTsInTemp=NOExtraDebugLogging=NO
DebugEncryption=NOCryptoStreamClose=NOCryptoStreamDispose=NOHideEncryptionMessage=NO
LockViewButton=0LockViewSavedButton=0LockReportInformationButton=0
HideViewButton=0HideViewSavedButton=0HideReportInformationButton=0
ShowLoginIDAndPasswordOnly=0
LockLeftBrowse=0LockRightDataConnection=0LockBottomRecordSelection=0
HideLeftBrowse=0HideRightDataConnection=0AutoHideRightDataConnectionBar=0HideBottomRecordSelection=0
LockID=0LockPassword=0
IgnoreHideRightDataConnectionIfWindowsID=
DisableUserConfigurationOfLeftBrowse=0DisableUserConfigurationOfRightDataConnection=0DisableUserConfigurationOfBottomRecordSelection=0
HidePrintButton=0HideGroupTreeButton=0HideExportButton=0HideRefreshButtonForSavedData=1ShowParametersPanelFor2008AndGreater=0
'Reads registry and loads DSNs in drop-down listLoadDSNs=1
'0 minutes disables auto-closeEnableViewerAutoCloseAtHowManyMinutes=30DisableUserConfigurationOfViewerAutoClose=0
MaximizeViewerWindow=0
'2 is "full page"'1 is "actual size"ZoomViewer=1
SavePassword=1
HideStyleAndColorCustomization=0
HideEmailButton=0HideEmailSettingsButton=0
ShowAllDirectories=1
OverrideDatabaseScheme=
MailPort=25MailSSL=0MailTLS=0
DisableCrystalRegistryUpdates=0
HideCopyToClipboardButton=0EnableClickAndCopyToClipboard=0HideCopyButton=0
'Unhide/0 to show a giant print button on Viewer windowHideEZPrintButton=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 timeDisableNewsAndUpdatesCheck=0
ResetLoginAfterCommandTable=0
PromptEachReportForLogon=0
UseINIIDAndPasswordToRunPassedReports=0
HideRibbonTabHelp=0HideRibbonTabAbout=0
'Auto-Refresh SettingsEnableViewerRightClickAutoRefresh=1ShowViewerButtonsDuringAutoRefresh=0MaximumAutoRefreshLimit=1EnableAutoRefreshCountDown=1
HideViewerToolBarOnMaximize=0HideViewerStatusBarOnMaximize=0
'This should not be modified unless you are implementing your own file maintenanceBypassFileMaintenance=0
'Continues to try to process report even if connectivity failsIgnoreTestConnectivity=1
'0=Off, 1=On, 2=AlwaysShowAlerts=1
ShowZeroRecordsReports=1
HideAlternateExportButton=0HideExportBrowseButton=0HideExportButtonInExport=0 DoNotOpenWindowsExplorerAfterExport=0HideExportAndOpenButton=0
DisableCreateShortcutsInMenu=0
'List of drive letters to NOT load in left side directory structure (ie. X,Y,Z)DoNotLoadDriveList=
SaveLastViewerWindowSizeAndLocation=0
BypassSetLocation=0
DefaultToSavedDataReportsFirst=0
DisableFindParameterWindow=0
BypassLicenseWarnings=0
UsePrintMethod2=0
HideThereIsNothingToPrintMessage=0
SuppressParameterRefreshPrompt=0
EnableDrillDown=1
DefaultExportSelection=2
ShowLegacyNoSecurityLabel=0
HideSaveTemplateButton=0
DisableIDAndPasswordsForAccessExcelConnections=1DisableIDAndPasswordsForXBaseConnections=1DisableIDAndPasswordsForXMLConnections=1
'This will store user ID, password, and mail settings separately on a Terminal Server/RDP/CitrixSaveMultipleIDs=0'This will store DSN and Database settings separately on a Terminal Server/RDP/CitrixSaveMultipleDSNDatabaseAndPaths=0'By default, the location of user-based settings is the same folder this JNRRV.INI file is located (jnrrv-multiuser-template.ini will be used as default INI settings for user)SaveMultipleConfigFileInUsersMyDocuments=0
SaveINISettingsOnExit=1
'-------------------------------------------------------------------------------------------[Global Options]
MailDelivery=SMTPServer=MailAccount=MailName=Report Runner ViewerAuthenticationID=AuthenticationPassword=CC=BCC=UseFreeServer=0DefaultMailSubject=DefaultMailMessage=
DefaultExportDirectory1=DefaultExportDirectory2=DefaultExportDirectory3=DefaultExportDirectory4=DefaultExportDirectory5=DefaultExportDirectory6=DefaultExportDirectory7=DefaultExportDirectory8=DefaultExportDirectory9=DefaultExportDirectory10=DefaultExportDirectory11=DefaultExportDirectory12=DefaultExportDirectory13=DefaultExportDirectory14=DefaultExportDirectory15=DefaultExportDirectory16=DefaultExportDirectory17=DefaultExportDirectory18=DefaultExportDirectory19=DefaultExportDirectory20=
'-------------------------------------------------------------------------------------------[Sounds]
SoundsOnOrOff=ON
'-------------------------------------------------------------------------------------------[Standard Viewer]
LastPath='HighPath='DefaultPath=
NoSecurityChecked=NID=PW=DSNChecked=NDSN=DatabaseChecked=NDatabase=
'If ON, report comment files (cache) are saved in Report Runner Viewer\Settings folder in TXT filesCommentsColumnOn=0CommentsColumnHeader=Report Information'Comments or TitleCommentsColumnContent=Comments
'-------------------------------------------------------------------------------------------[Enterprise Viewer]
UserDataFile=ReportsDataFile=
'If ON, report comment files (cache) are saved in Report Runner Viewer\Settings folder in TXT filesCommentsColumnOn=0CommentsColumnHeader=Report Information'Comments or TitleCommentsColumnContent=Comments
ADPath=ADFilter=ADMethod=3
'-------------------------------------------------------------------------------------------[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=1ColorA=255ColorR=47ColorG=54ColorB=153
Report File Name=224FT=40DT=40Destination Name=437Status/Message=331Last Run=121#=31
'-------------------------------------------------------------------------------------------[Global Parameters]
Name=144Data Type=100Expression=550
'-------------------------------------------------------------------------------------------[Groups and Users]
ID=100First=125Last=125Group=100Report Tags=321
'-------------------------------------------------------------------------------------------[Reports]
Type=90Name=121FileName=274Description=292Report Tags=285
'-------------------------------------------------------------------------------------------[HelpDesk]
CompanyName=UserName=EmailAddress=
'-------------------------------------------------------------------------------------------[Messaging]
LastMessageID=0
'-------------------------------------------------------------------------------------------[Developer]
Company=
Logo187x64=
URL=
'http://www.colorschemer.com/online.htmlBackColor=0,0,64
ShowStatus=YES
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 SupportDDO=1CRO=1DRO=1DEO=1DFO=1
BCT=0
PreLoad=1
ForceEnd=0
'-------------------------------------------------------------------------------------------[Auto-Backups]Backups=ON
'-------------------------------------------------------------------------------------------[Window Sizes And Locations]
