Home

DataLink Viewer 2011 User Manual

image

Contents

1. Added a DataLink_Viewer ini option of Report_Reload_Discards_Login_Info By default this option is set to False This allows you to run a report in DLV change the rpt design in Crystal Save and reload the new rpt design in DLV without repeating the login process Added logic to preserve qualifiers in table names for native Oracle connections Anew Integrated_Authentication_Set_Entry command line argument allows administrators to set integrated authentication information for specified Windows User ID and Machine Name s For detail see Setting Integrated Authentication for Multiple Machines Citrix Farm Anew Set_Formulas1 command line argument allows setting of formula expressions provided the formula name starts with a character For detail see the user manual section on Argument for Setting Formula Expressions 2002 2015 Millet Software Page 119 e DateTime parameter placed on the report layout now react to user clicks by providing a popup change dialog with Calendar and Time change controls In prior versions this was possible only with Date parameters Added a new option to DataLink_Viewer ini Options section Save_Screen_Space_By_Removing_Main_Report_Tab True By default this option is set to True and DLV saves screen space by removing the Main Report tab at the top of the Preview window When a drill down is initiated DLV restores the tabs to allow navigation This causes a brief flicker If you
2. Customer Customer Name Platou Sport Employee Last Name Davolio Revenue 15 104 03 Discount 743 02 ml Orders_Detail Quantity 3 Cust_Qs 3 89 ml Revenue Si gal Discount wll Discount gall Late ll Lead_Time gal Cust_Qs mi Values Discount Notes e You may disable this functionality by adding this to the master DataLink_Viewer ini Options Disable Visualization True e Since the visualizer takes care of generating summaries from the data it is best to use it with detail reports e To get loaded into the visualizer a field formula must be placed on the report layout Its name must not end with NOK an indication it s Not OK to include it If the 2002 2015 Millet Software Page 43 field formula is suppressed or is placed in a suppressed section it gets loaded into the list of candidate Fields Formulas only if it s name ends with _OK This is designed to avoid exposing sensitive suppressed information e When a user launches a report that has save visualization layouts you may want DataLink Viewer to immediately launch the visualization instead of the report preview You can achieve that behavior by going into the DataLink Viewer Options dialog Launch tab and selecting a Visualization Action Visualization_Action Keep_Preview_and_Load_Visualization Minimize_Preview_and_Load_Visualization Hide Preview and Load Visualization
3. Refresh Report Data C Use current parameter values z Te Prompt for new parameter values Change Parameter Current Value Start_Date 11 21 2008 12 00 00 AM Product_Types Gloves Helmets Status_Codes 50 100 10 Notes e To remove linked subreport stored procedure parameters from this dialog the parameter name must contains Linked 2002 2015 Millet Software Page 15 Save and Reuse Named Parameter Sets Video If you click the refresh button for a report that has at least 8 parameters Options dialog allows you to change that number a Save button becomes visible in the following dialog C Use current parameter values RefreshEvery 600 Ze Prompt for new parameter Veit Level ay op Level s metic how _Parameter_Panel Hide Panel If you click Save the following dialog allows you to save the current parameters value set to DataLink_Viewer ini under a unique name for this report SCH Name 2001 to 2009 Al Products TopN_Level1 TopN_Level2 Topi Detal From_Date 1 1 2001 12 00 00 AM 12 31 2009 12 00 00 AM Expand_Level_1 Click to Expand Top Nodes Product Class LL Customer Alley Cat Cycles Show_Parameter_Panel Hide Panel F A 2002 2015 Millet Software Page 16 The next time you load this report you would get a dialog that allows you select and reuse any of the saved named parameter sets for this report Saved Parameter Values Dou
4. e After Export Action a l No Action Open File Open Folder Apply to Future Exports Added a Skip Export Format Dialog option in DataLink_Viewer ini By changing this option to True if the user selects an export format of CSV or Excel and the report has saved export settings in Crystal File Export Report Export Options the dialog showing export format options would be skipped and the saved settings would be used Installing on a machine with an older version Service Pack of the SAP Crystal Reports Runtime Engine for NET Framework 4 0 now automatically upgrades the runtime to the latest service pack The user no longer needs to first manually uninstall the older service pack version Double clicking a section with a formula that launches a report now accepts wrapped text and doesn t require double clicking directly on the formula If a section contains multiple launching formulas the one that is directly double clicked gets launched Clicking on a formula can now set the value of another formula to either the name of the clicked formula new option or to the value of the clicked formula old option For more detail see the user manual section on Click to Set Formula Value If you embed DLV_RPT_PATH in the text of a launching DLV_Run formula DataLink Viewer substitutes the path to the current report file for that token allowing you to dynamically specify the folder wh
5. 2002 2015 Millet Software Page 8 Typical Use Scenarios In a typical scenario you would select a report to view by double clicking it After prompting you for parameter values the viewer would display the report with all the preview functionality available within Crystal drilldown tree view export zoom print The report can also be invoked from a desktop shortcut a batch file or another program using command line options Select Report Window After starting DataLink Viewer you would see a screen similar to this DataLink Viewer TBR Select Report Preview 7A amp OBS C Program Files DataLink Viewer 11 DataLink_ iewer_Year_and_Product_Prompts 11 rpt Last Used Path Name Title Description Subject Type Last Used amp Last Used Today C Do DLY_In_Place_Drill_Down_12_M In Place Drill Down DLY Demo Dril Down Sample 2008 2008 06 27 09 42 Last e Yesterday CiiDo NorthWind_Multi2_2008 rpt Test Report Northwind2 w subreport SQL Server 2008 06 26 23 38 C Pro DataLink_Viewer_Year_and_Pro DLY 11 Sample Report Dynamic Ca Sales Sample xI 2008 06 26 23 01 C Do test_range_param_9 rpt Test report for range parameters Parameters Sample amp 2008 06 26 22 51 Last Used Tuesday Last Used Monday Last Used Older Use the button to browse for and open a report for the first time Previously selected reports are listed in a grid and can b
6. Customer Name 4 SQL Expression 1 Subreport1 Subreport RFa RecordNumber lt 1 EnableSuppress Text2 Text RHa 3 4 gt 6 EnableSuppress v Edit Filter 8 mn Record 1of36 Iplml m CS Note to disable this functionality set Disable Inspect Reports True in the DataLink_Viewer ini Options section 2002 2015 Millet Software Page 47 Report Documentation After previewing a report a click on the status bar panel displaying the report name br test_check_formulas_Good_N rpt 269 269 provides a report documentation window such as this Report was last saved in Crystal Designer Version 14 1 1 1036 By Ido Millet ido MilletSoftware com On 2015 07 31 12 34 24 Eastern Standard Time Revision 46 Subject Report Inspector Documentation Comments Demo report with subreport for demonstration of Expression Inspector and Report Documentation Key Words Expression Inspector Author Ido Millet ido MilletSoftware com 1 Xtreme Sample Database 11 5 False Subreports 1 2002 2015 Millet Software Ki Report Information test_check_formulas_Good_N rpt Tel m Page 48 Launching Reports amp Command Line API Launch Reports from File Explorer DataLink Viewer allows you to launch a report from the Windows File Explorer by Right Clicking a rpt or rpz file The typical File Explorer menu provides the following extra options re ll pen Se D roduct
7. To disable sharing parameter values from prior answers open DataLink_Viewer ini and change the following entry from TRUE to FALSE E Parameters Share Prior Answers TRUE 2002 2015 Millet Software Page 30 REQUIRING A VALUE FOR A DYNAMIC PARAMETER This can be achieved by following these guidelines 1 Add a string formula with the name of DLV_PARAMETER_REQUIRED to the Report Footer of the dynamic parameter report not the main report 2 The formula must return a non blank string if you wish to enforce a required value for the parameter 3 If the string returned by the formula is longer than 10 characters it would be used as the text of the message box in cases where the user clicks OK without specifying a value for the parameter Otherwise a standard message appears 4 The formula and even the report footer section as a whole can be suppressed 5 You must place the Page N of M special field in the Page footer of the dynamic parameter report even if that field or the page footer as a whole are suppressed FORCING USERS TO SELECT FROM THE LIST OF VALUES NO DIRECT EDIT By default dynamic parameter dialogs for single value parameters allow the user to enter a value directly instead of clicking on the displayed list You can force the user to select from the list displayed by the dynamic parameter report under two scenarios 1 You include the text NoEdit in the parameter name or 2 The user double c
8. When previewing a Grouped report if you click B or press Ctrl G the Group Swap Expert dialog open up Rekis Fomulas Group By Using Drag amp Drop DOW_OK Employee Last Name Quarter_OK Product_Type Product Type Name For example Value E Year_OK gm V instead of Grouping the report by Cistomer Oly Employee and by Product Type you pe may group the report by Country and OE Year Orders Order Date Product Product Name The grouping change doesn t require hitting the database again so it is very quick DataLink Viewer also adjusts all formulas using group summaries as well as the Group Selection formula to reflect the new grouping This feature avoids the need to create parameters and formulas in cases where you wish to provide dynamic grouping functionality A video demonstration is available Notes 1 If you try to invoke the Group Swap expert for a report grouped on a date you get a detailed message box like this N Group Swap Expert disabled for report grouped on date D Ship_Date_OK because such grouping requires a time period choice e g each year F you wish to enable the Group Swap Expert for this report create a formula that returns the desired time period For example ToText Ship_Date_OK yyyy and group the report on that formula instead 2002 2015 Millet Software Page 41 2 For the same reason date fields formulas are not listed a
9. EN Click on left for Bookmarks DataLink Viewer 2011 View Print Export Inspect Schedule and Auto Refresh Crystal Reports www MilletSoftware com Version 6 6 December 2015 By Millet Software 5275 Rome Ct Erie PA 16509 3951 ido MilletSoftware com 814 825 6009 Disclaimer This software is provided as is by Millet Software without assuming any responsibility for harm to computer systems software or data with which these files are used 2002 2015 Millet Software Page 1 MAIN BENEFITS 33 52 300 eS avnide cas a As Sisko avd aicleds dita aia hi kivied died ae a ee 6 INSTAEL REMOVE s2 05d0e0 Sostvt nid E eee Rik th A EES 8 INVITEIERT ZIL KEE 9 SELECT REPORT AW INDIOW EEN he chee eee eS i ed E 9 Right Chck Report Row Memes reese a ein havin Suis bated ek ean 10 PREVIEW REPORT WINDOW sde segues ss Ee deed E geed EE EE ee SE dE Ed 11 Report Grid Helps eege rss ge ee aie di EE ai Vaai da enna 13 Report Preview Help edu ease meant ae Eege Ee aaah 13 Selecting Report to MEss ee 14 COPYING TEXT CONTENT FROM THE REPORT sssseseseeeeeeeessereessreesssetrseteesstreessreeesseeesertesseeessteeesstesseeressrreessreeeene 14 Text COpy CMEC a ee aee a ea dee dee ee Ne ege d e os ates treet tea 14 Tooltip Copy Ctrl Shift C 22 3 tacdieig ui ees aivig sien wiht dieiy ar a i Aided wildy aisles 14 PARAMETER FUNCTIONAL IT Y ccsssssssssssescsssssecsscseossensssosesonesasonssonsssscvecsvessnesssesseeseosssossso
10. this allows us to call 1 report and progress to the next line in a batch file no blocking as well as avoid the ugly DOS window CreateObject Wscript Shell Run amp WScript Arguments 0 amp 0 False Step 3 Use notepad to create one batch file for each report to trigger its viewing and auto refreshing Here are two batch files one for a report with a parameter and one for a report without one Report_1 bat C Program Files Millet Software DataLink Viewer 2011 DataLink_Viewer_2011 exe v C DLV Report_1 rpt Parm1 2004 Auto_Refresh 30 Report_2 bat C Program Files Millet Software DataLink Viewer 2011 DataLink_Viewer_2011 exe v C DLV Report_2 rpt Auto_Refresh 30 Step 4 Use notepad to create a batch file which silently calls the two reports inserting a 15 seconds wait between the calls Double click or schedule that batch file to start the processing wscript exe C DLV invis vbs C DLV Report_1 bat CALL WAIT 15 wscript exe C DLV invis vbs C DLV Report_2 bat 2002 2015 Millet Software Page 35 Click to Set Formula Value Video Demo DataLink Viewer reacts to user clicks on specially named formulas by setting the value of another formula Click to Set Another Formula to Clicked Formula Value For example if a user clicks on a formula called value the text Region it will attempt to locate the Region If the user clicks
11. 2002 2015 Millet Software Page 22 Dynamic amp Cascading Parameters Video Demo This section explains the special dynamic amp cascading parameter functionality provided by DataLink Viewer The first parameter in our sample report was named by the report developer as Prompt_Order_Year rpt DataLink Viewer detects that such a report exists and links to that report as the basis for prompting the user Note if a prompting report doesn t exist the static parameter dialog provided by Crystal will be used DataLink Viewer always tries to locate and use Live Prompts before using the static Crystal prompts RESPOND TO SINGLE VALUE LIVE PROMPTS DataLink Viewer detects that the Prompt_Order_Year rpt parameter was designed to accept only a single value and hence it presents you with the linked report inside a dialog that allows you to click and select only a single value Double Click to Select alues for Main Report Order Year 2003 Cancel Z Note that by linking to a live prompt report the designer of the report doesn t have to change the report design every year in order to add one more entry to the default value list of the static parameter Instead the prompt report dynamically presents all available years in the database 2002 2015 Millet Software Page 23 LINK BACK IN A HIERARCHY OF LIVE PROMPTS Once you select 2004 and hit OK the viewer detects a second parameter in our sample report Prompt_Pr
12. To enable this set the Disable Daa Gd option to False in DataLink_Viewer ini Users can now click a fields formulas objects and if the report developer assigned an HTML tooltip for these objects a window pops up and displays that content For a description of this functionality see Click to Show HTML Tooltip A short video demo is also available Added Ctrl C to copy the text and Ctrl Shift C to copy the tooltip text of a clicked field in report preview Since you can use a formula to control the content of a tooltip this allows you to copy to the clipboard much more than just the displayed value of a field For detail and sample use scenario see the user manual section on Copying Text Content from the Report Removed dependency on Visual Basic PowerPacks In the 2008 version exporting drill downs in rpz files resulted in exporting the main report instead In the 2011 version this limitation is now removed 2002 2015 Millet Software Page 115 The Option dialog has a new Database tab for setting logon and connectivity options The Options dialog has a new Export tab to control the After Export action You can elect to automatically open the exported file within its associated application Open the folder in File Explorer take no action or Ask the user each time they export The dialog for asking the user has a checkbox for adopting the selected choice and applying for all future exports to avoid being asked again
13. e After creating a Visualization layout you can name and save it What gets saved is only the layout not the data So each time you load report data the layout applies to the new data e All Visualizations get saved into a single dlvv file in the report folder This allows you to easily distribute the visualizations with your reports e Using the Options dialog you can specify a folder location for visualization files You can give users Read Only Centralized or Distributed access to visualization files The logic is as follows 1 Ifthe viz file for the rpt is found in the rpt folder it is used there If the user has no write permissions to that folder the user won t be able to save new Visualization Layouts 2 Otherwise if the viz file for the rpt is found in the ReportList folder the folder where the ReportList txt is located it is used there Again if the user has no write permissions to that folder the user won t be able to save new Visualization Layouts 3 Otherwise if a location was specified in the Options dialog for the visualization layouts folder the visualization layouts for the report would be loaded from and saved to that folder Again if the user has no write permissions to that folder the user won t be able to save new Visualization Layouts So if you use Citrix or Terminal Services server and you wish to give each user their own visualization files you can specify the visualizations folder as something
14. you must create a table called DLV_Log in the target database Email to me if you d like to receive a sample MS Access database with the required DLV_Log table Below are example of data structures for MS Access and MS SQL Server However those are just examples You can use such a table in any other ODBC aware database Oracle DB2 Sybase etc TYPICAL USE The DLV log table can be used to Monitor report use 1 Monitor report performance using the start amp end time information 2 Monitor what employees access print export what data This can be useful for addressing data privacy and protection concerns and requirements e g HIPAA If there is a need to monitor this log for exception situations you can use Visual CUT another Millet Software tool to schedule exception reports and email alerts against this table 2002 2015 Millet Software Page 88 MS ACCESS DATA STRUCTURE Here is the table structure required for this table when implemented under MS Access along with comments explaining what information is recorded E DLV_Log 5 LogN AutoNumber Surrogate Key Rpt_Path Text Path to the rpt file Rpt_Name Text Name of the rpt file Proc_Start_Lacal Text Preessing Start DateTime String representation For example 10 18 2008 3 48 02 PM Proc_End_Local Text Processing End DateTime String representation For example 10 18 2008 3 48 04 PM Droc Start GMT Text Preessing Start DateTime in Greenwich Mean Time GMT al
15. 6 arguments are separated by gt gt as a delimiter 1 The path amp name of the ini file 2 List of machines separated by delimiter or just the name of 1 machine 3 The user id 4 The Database user id 5 The Database password 6 Operation Type a Appends the User ID amp Password pair if it doesn t already exist for all specified machines b like Append but removes any other User ID amp Passwords c Deletes the User ID amp Password pair if it already exists d Completely drop all pairs from the specified User ID amp Machine entries 2002 2015 Millet Software Page 102 ENFORCING SETTINGS IN A MASTER DATALINK_VIEWER INI FILE The master DataLink_Viewer ini file is located in the application folder or the auto redirected folder as described in the section above The File_Locations section in the master file may indicate that a different user DataLink_Viewer ini file located at a different folder should be used As an administrator you may want to ensure that some centralized settings in the master ini file always override the settings in the user ini file You can do this by setting the values to all upper case for example TRUE or FALSE instead of True or False This tells DataLink Viewer that it should use these settings from the master file This behavior applies to the following options shown as if you wanted to apply them centrally from the master DataLink_Viewer ini file Opt
16. Brown Chiaroscuro Vagabond Gray Orange Blue Office Olive Office Silver Office LiserFormat1 in os O Style3D Office2003 2002 2015 Millet Software Page 95 Disabling Report Preview Buttons In some scenarios you may wish to remove the Print Export Select Expert or Search Expert buttons from the preview window of reports This is useful for example in cases where your application launches reports in DataLink Viewer via a command line and you wish to restrict some users from printing and or exporting the report You can globally remove the Print and or Export buttons from the Preview window by setting the following options in the DataLink_Viewer ini file Options Disable Print Button TRUE note this disables all 3 print buttons Disable Print ThisPage Button TRUE Disable Print Quick Button TRUE Disable Export Button TRUE Disable Search Button TRUE Disable Refresh_Button TRUE Alternatively you can control these options via command line arguments For example all in one line Note see Enforcing Settings in a Master DataLink_Viewer ini File for information about enforcing these settings from the master ini file to all user ini files 2002 2015 Millet Software Page 96 Disabling DataLink Viewer Buttons In some scenarios you may wish to disable certain user interface buttons so that for example users can t convert rpt files to rpz files open the user manual etc You can dis
17. Fields X4 Formula Fields SAL Expression Fields Parameter Fields E Running Total Fields S Group Name Fields E Special Fields IO Fe 2 The record selection formula must include a condition that restricts the data according to the User ID In most cases this would be achieved by creating a new table in your database or adding a new column to an existing table For example a new column in the Sales_Rep table or a new table can associate each Sales_Rep_ID with his her User ID The record selection formula would include a condition such as This would ensure that as each Sales Rep logs into their PC DataLink Viewer will show them only the sales records associated with their own Sales_Rep_ID Note using a table you can use multiple records to map the same User_ID to multiple areas of responsibility User_ID Table J E Customer_IDs Product_IDs Region_IDs _ Product Code UserID d Visual CUT This allows you to give a single user for example a CUT ixm regional manager who should be able to see information DataLink Viewer ixm7 for all her Sales Reps permissions to view information __ Visual CUT ido that is related to more than one entity Jon Joe DataLink Viewer Mike el In the table example on the right ixm7 is allowed to view Record 14 1 elv sales information for all three products while ido is allowed to view sales information only for Visual CUT
18. If the report uses a UDL for a data source with a name matching one of the Il delimited targets the user would be prompted to enter a new Data Source name If you want any UDL source to be targeted for a data source change set the Targets entry to ALL like this UDL_Data_Source Targets ALL 2002 2015 Millet Software Page 79 Integrated Authentication Integrated Authentication Remember Me DataLink Viewer allows users to avoid repeated login prompts to databases The database login information is stored highly encrypted inside DataLink_Viewer ini as shown below w DataLink_ iewer ini Notepad loj x File Edit Format Help Integrated Authentication Enable Integrated Authentication FALSE ixm7 SOBPCOZ S3E4S1BSE0AZ1194DSA1LEOCADBS6E637AD3AOSDF3ZF1686B BZ648F2S1F9F9BAZBEDDLECIZ4486BS6BS88080DZ2BEA0CA61 E The security of login information is maintained not only by storing it in encrypted format but also by storing it with an internal identification of which Windows User amp PC this login information belongs to DataLink Viewer uses this encrypted database login information only after checking that the same Windows user is running from the same PC In other words users cannot break the login security by attempting to copy and paste the encrypted information to their own ini file entry For example in the example shown above integrated authentication has been enabled This can be done via a checkbox in the Optio
19. In some cases you may want to use the same report to connect to different data sources such as a testing or production server While each report stores connection properties for only one default ODBC Data Source Name DSN DataLink Viewer allows you to use command line arguments or the DataLink_Viewer ini to specify a different ODBC DSN The command line argument structure is as follows or The argument overrides all ODBC DSNs used in the report by the new DSN The argument overrides only for tables that use the old DSN Note ODBC_DSN_From_To support multiple pairs separated by i as shown in the example above This addresses scenarios where a report uses multiple ODBC DSNs e g when subreports use different DSNs Also you may specify ODBC_DSN_From_To as a global entry in the Options section of DataLink_Viewer ini Overriding the Database Specified in the Report or ODBC DSN For ODBC data sources you can enter a database name into the login dialog if you wish to override the database specified in the ODBC data source or in the report itself This is useful for situations where the same database e g MS SQL Server contains multiple databases each with the same table structure If the number of such databases is large creating a dedicated ODBC DSN for each and using the select ODBC DSN functionality may be too tedious Instead you can directly type in the database name in the login dialog To enable database name input
20. Info Work Office 814 898 6262 Home Office 814 625 6009 C ProgramDataMilletSo ware OLV_2011 0ataLink_Viewer ini C ProgramOata MilietSo ware OLV_2011 FieportList txt To navigate to the Folder where DataLink_Viewer ini is located double click that textbox and DataLink Viewer will open that folder location in File Explorer That makes it easier to find and edit the ini file in cases where the folder is hidden typical for app data folders 2002 2015 Millet Software Page 100 CITRIX AND FILE LOCATION FUNCTIONALITY DataLink Viewer can be installed on Citrix but be sure to install from the Console The File Locations tab in the Options dialog allows a single installation of DataLink Viewer on a Citrix or Terminal Server to support individual settings for each user by providing each user their own version of DataLink Viewer ini and ReportList txt file under their own mapped user drive Note upon initial launch of DataLink Viewer by a user if the target folders don t exist they get created and if the target files don t exist they get copied from the master copies in the application folder An alternative approach is to use these settings to force all users to share a centralized version of these files In such a case you should make the ReportList txt folder read only to the users so that the master list of reports doesn t get changed by the users This dialog also allows you to specify a centralized local logging of r
21. Shift P Quick Print Default Printer Ctrl X Export Ctrl Zoom In Ctrl Zoom Out 2002 2015 Millet Software Page 13 SELECTING A REPORT TO VIEW Let s launch DataLink_Viewer_Year_and_Product_Prompts V12 rpt installed under the c Program Files DataLink Viewer 12 directory in typical installations You can do this by 1 Selecting that row and clicking the Preview Tab or 2 Right Clicking that row and selecting Preview or 3 Double clicking the row Note the sample reports assume that you have the Crystal Reports Extreme Sample Database for that version of Crystal already installed on your PC Before displaying the report DataLink Viewer would prompt you for any report parameters and logon information required by the report If the report was saved with data the viewer would ask you if you want to refresh the data or use the data saved with the report in which case you would not be prompted for parameter values Copying Text Content from The Report When previewing a report you may want to copy the text content from a clicked field or formula TEXT Copy CTRL C After a field formula is clicked pressing Ctrl C copies the value of the field as text to the clipboard You can then paste that text using Ctrl V or right click editing menu to a target of your choice TOOLTIP COPY CTRL SHIFT C After a field formula is clicked pressing Ctrl Shift C copies the value of the tooltip of that field as text to
22. all users who will then be authenticated to the database using their own windows user id and the secret global password If you are in the rare situation where you need to use this functionality contact Millet Software and if your use scenario matches this functionality you will receive detailed instructions 2002 2015 Millet Software Page 82 Protect Report Designs with rpz Files Compress amp Encrypt Rpt to Rpz The Compress amp Encrypt Rpt to Rpz button on the 1 Tab of DataLink Viewer allows you to select an rpt file and convert it to rpz file Compression amp Encryption to rpz File Completed E x A Report File gt C Program Files DataLink Viewer 9 World Sales Report rpt gt rpz File C Program Files DataLink viewer 9 World Sales Report rpz Keep the rpt File and give your users only the rpz file Your users would then be able to run the rpz file in DataLink Viewer but won t be able to open it in Crystal Designer Note DataLink viewer doesn t allow rpz files to be exported to rpt files This ensures your report designs are fully protected The resulting rpz file is a compressed and encrypted version of the rpt file that is recognizable only by DataLink Viewer amp Visual CUT Your users can run the resulting rpz files in DataLink Viewer or Visual CUT but cannot view or modify them in Crystal This allows developers to protect and hide their reports designs either as an intellectual proper
23. double clicking a report section as described above you may wish to prompt the user for some input and embed that input into the command line One scenario is a case where you wish to prompt the user to provide the value for a parameter Another scenario may be a case where you wish to print labels for the product you are double clicking but you want the user to be prompted for the number of copies to print You can achieve this functionality by embedding within the command line a call to an InputBox function DataLink Viewer would then replace the InputBox Call with the input from the user For example the following formula would prompt the user for number of copies and then print the Product rpt report for the double clicked Product Name to the default printer with the number of copies specified by the user DIV Run v C temp Product rpt Parml Product Product Name Yn Printer Default 4 Print Copies InputBox Please Specify How Many Labels amp amp How Many Copies for amp Product Product Name amp amp amp 1ye The bold text is the InputBox call This call must be enclosed by ME and has 4 parts separated by 1 InputBox a keyword indicating this is a request for an InputBox dialog 2 The Prompt the text shown within the InputBox dialog If you need to specify line breaks within the prompt text be sure to use vbCrLf case sensitive rather th
24. eee et AE es Dee deed Ee PLE ees Aven Deep Aen rege 110 VERSION 6 4 1003 SP12 NOVEMBER 29 2014 112 EE EE EE E 112 seg eene 113 VERSION 6 3 1045 SP7 NOVEMBER 9 2013 115 2002 2015 Millet Software Page 5 Introduction DataLink Viewer 2011 uses the Crystal 2011 runtime components and allows you to run Crystal reports from version 7 8 8 5 9 10 XI 2008 and 2011 While the creation and design changes of Crystal reports rpt files require the full Crystal Reports software you can let other PCs view print and export these reports by installing DataLink Viewer DataLink Viewer provides several useful features such as command line API allowing you to schedule printing and trigger viewing of reports from your application task scheduler batch files or desktop shortcuts an intuitive Grid for organizing and selecting previously opened reports reduced login frustrations via integrated authentication choice of alternative data sources selective parameter refresh dynamic and cascading parameters even for versions prior to XI auto refresh user based row level security and more Main Benefits 1 Refresh View Print and Export Crystal reports 2 Schedule Report Exports or Printouts using the free windows task scheduler 3 Uses Crystal 2011 runtime components providing full support for new features such as interactive parameter panel and advanced CrossTabs 4 Group Swap Expert allowing allowing group chan
25. flag indicating we are requesting a report to be shown viewed S shows the report and allows selection of other reports via the Report Selection Tab V is a View Only option that allows only viewing of the specified report the Report Selection Tab is not available to the user 3 the report path and file name 4 Optional Parameter value arguments supplied as ParmN Value where N is the position of the parameter in the parameter list within the Crystal report 5 Optional User ID and Password arguments 6 Other optional arguments Export Printer Print_Copies ODBC_DSN ODBC_DSN_From_To Oracle_Server Connect_To_SQLOLEDB Auto_Refresh ViewMode Disable_Print_Button Disable_Print_ThisPage_Button Disable_Print_Quick_Button Disable_Export_Button Disable_Search_Button Disable_Refresh_Button DB_Path_Use_Default Disable_Group_Swap Examples 1 Invoke viewing of a sample report while passing 1997 as the 1 parameter value C Program Files Millet Software DataLink Viewer 2011 DataLink_Viewer_2011 exe S C Temp DataLink_Viewer_Year_and_Product_Prompts rpt Parm1 1997 2 Invoke viewing of a secure report while passing User_ID and Passord C Program Files Millet Software DataLink Viewer 2011 DataLink_Viewer_2011 exe s C temp Some Secure Report rpt user_id dba password sql 3 Invoke viewing of a report with only Preview tab no Select Report tab and specify an ODBC data source This is useful in cases where
26. on another formula called string value the text Country it will attempt to locate the value to Country that has as its string formula and set its string value to that has as its formula and set its string The name of the clicked formula has 4 parts 1 DLVSet_ this is a constant that identifies the formula to DataLink Viewer as a click source 2 Any number not limited to a single digit d or a in samples above This allows for multiple formulas each with a different string value to set the string value of the same target formula 3 a colon 4 The name of the target formula Sort in the examples above whose string value would be set to the string value of the clicked formula Note avoid spaces and special characters e g underscores in the target formula names Click to Set Another Formula to Clicked Formula Name Following the scenario in the section above if the target formula name contains ClickedFormulaName its value gets set to the name rather than value of the clicked formula If it contains ClickedFormulaNameDrillDown the click also triggers a DrillDown This allows initiating a drill down while dynamically controlling visibility of elements in the drill down Make sure the group name you are drilling on is not blank 2002 2015 Millet Software Page 36 Click Column Headers to Re Sort The Report As a demonstration of what can be achieved with the Click to Set a Formula Value function
27. report loading stops with a message indicating which From tables were unmatched with report tables 2 This functionality is available only in DataLink Viewer 2008 and 2011 Overriding the XML File Location This functionality was added for a customer who needed to call DataLink Viewer from his application via a command line The data source for the report was an XML file ADO NET XML connection but on each call to DataLink Viewer instead of using the original XML file as a data source a different XML file name and location may be used The command line argument to allow overriding the XML file path looks like this XML _Path_From_To C custprog PICKLIST xm1 gt gt C temp B139 xm1 If you need more than one pair of From To directives separate them with a Il delimiter Within each pair of From To directives the From location is separated by a S gt from the To location Notes 1 If any of the From paths is not found in the report the report loading stops with a message indicating which From paths were unmatched 2 This functionality is available only in DataLink 2011 2002 2015 Millet Software Page 73 Stripping Table Qualifiers when Connecting to a Different Database The SQL statement generated by Crystal frequently contains not only table names but also the database name used at the time the report was designed Database Table or Database Owner Table Such table qualifiers can frustrate attempts to
28. wish to avoid this step you can now set this option to False Ctrl Shift F1 now opens DataLink_Viewer ini configuration settings in Notepad When closing the application after an interactive session the ReportList txt file 1 tab report grid is now transferred to the recycle bin approximately once per 10 times This provides a copy of the file in case it gets erased during abnormal termination of a user session The report grid right click menu provides options to increase decrease font size The changes are saved and reused across sessions Added a 64 bit version of DataLink Viewer 2011 2002 2015 Millet Software Page 120
29. with text elements conditional formatting or record selection criteria without changing the report design Or perhaps you wish to restrict use of your reports to only paying customers by providing a license code that must match using secret logic the company name in the customer s database Instructions First add to the Options section in DataLink_Viewer ini in the application folder an entry with a key name Company and value Millet Software of your choice For example Options Company Millet Software Then add a String Single Value parameter named DLV_INI_Option_KeyName to the report DataLink Viewer automatically sets the value of such parameters to the value found for the Key Name under the Options section of DataLink_Viewer ini So in the case above the parameter value of DLV_INI_Option_Company would be set to Millet Software Notes e Within DLV the user never gets prompted for the value of such parameters e Ifa matching key name can t be found the parameter gets the value of Failed INI Lookup e You can have as many parameters like this as you wish each with a different key name e To pass such parameters to subreports create a formula in the main report that simply returns the value of the parameter Then pass that formula as a link to the subreport e The ini file used by this process is always the MASTER ini file the one in the DataLink Viewer application folder even if you redirect to
30. 5 Packaged with Service Pack 15 of the Crystal Runtime DataLink Viewer now provides an Expressions Inspector for listing amp searching formulas SQL expressions running totals selection formulas and conditional formatting expressions The report grid right click menu provides options to launch the Expressions Inspector for one or multiple reports See Report Inspection amp Documentation Tools Expression Inspector and this demo image A click on the status bar panel showing the report name now provides a window see demo image with information about the report For detail see Report Inspection amp Documentation Tools Report Documentation Visual CUT can now delegate exporting to DataLink Viewer 2011 in order to take advantage of Crystal 2008 201 1 2013 features e g Calculated CrossTab members The status bar now provides smoother updates during load refresh auto refresh and data visualizer events Added Print_As_Designer ini file entry to the Options section and to the Export Print tab of the Options dialog By default this option is now set to TRUE in order to use the same mechanism that Crystal Reports Designer uses to print This solves printing issues caused by the prior Crystal runtime printing logic For example for one customer this allowed printouts of UPC barcodes to scan properly The Reload_Report_On_Refresh option now accommodates Auto Refresh scenarios The command line argument of Printer_Setup
31. 5 EnableSuppress Subreport_test1 testdate1 Field Detala 1 2 EnableSuppress Texti FieldHeading PHa CurrentDate gt 1 1 2016 EnableSuppress test Formula test amp 1 Formula 3 Gr1 Formula Dese Formula 3 Subreport_test1 test_date Formula CurrentDate Formula Subreport_test1 String_Formula Formula CurrentPageOrientation Formula 1 Subreport_test1 test_number Formula 1 2 Formula 1 Group Level 1 Group pirea Fajen Then Gier crSortDirection RTotal_Cust_Count Ruining Total 1 1 Evaluate Condition 1 Detail a Section Detail CurrentDate gt 1 1 2016 EnableSuppress Detail b Section Detail CurrentDate lt 1 1 2016 EnableSuppress RHa Section RH 1 20R 2 3 EnableSuppress RHa Section RH 1 2 EnableKeepTogether RHa Section RH IER EnableSuppress fBlank RHa Section RH 1 3 EnableUnderlaySection RHa Section RH RGB 230 230 230 BackgroundColor RF a Section RF currentdate gt 1 1 2015 EnableSuppressIfBlank RFa Section RF RGB 230 230 230 BackgroundColor GHia Section GH1 False EnableSuppress Subreport_test1 Detail a Section Detail currentdate gt 1 1 2015 EnableSuppress Subreport_testi BE a Section RF 5 gt 2 EnableSuppress fBlank Subreport_testi RF b Section RF ab cd EnableSuppress Selection Formula Record Selection Formula Customer Customer ID lt 1000 Filter Selerpen Formula Group Selection Formula Maximum Customer Customer ID gt 10 Filter Cust_Name_Left4 SQL Expression fn LEFT Customer
32. 890S58C66A16F5317 e text into the dialog 3E19F47466ARAR4C27D9C6B9SA0EFD8CB854407620C12EC73533 S OE8397B6S90EFEZ3FDC8CCE2BAAFB86425710018034CD266 612 Please contact Millet Software for more detail about the various options and the use scenarios supported by this dialog 2002 2015 Millet Software Page 85 MAKE_RpPZ2 COMMAND LINE ARGUMENT If you need to automate the conversion of rpt files to rpz files with expiration dates and license keys your command line call should look like this all in one line C Program Files Millet Software DataLink Viewer 2011 DataLink_Viewer_2011 exe After the Make_RPZ2 key word and the colon the arguments are separated by gt gt gt as a delimiter The 8 arguments are 1 The path to the rpt file s to be converted you may specify wild cards as demonstrated in the example above you may specify multiple paths separated by a semi colon 2 The target folder where the rpz files should be deposited Include subfolders when wildcard expressions are used for source files True False 4 The maximum age in minutes of the rpt file s to be included Older files would be skipped This allows the command line to be placed in a batch file and scheduled while avoiding the conversion of older files that have already been converted Use a value of zero to convert all files regardless of age 5 Text information to embed in the rpz file Separate lines with This informatio
33. Authentication should be used if TRUE user_id amp password are ignored Note This functionality is not available in the Crystal 8 5 version of DataLink Viewer 2002 2015 Millet Software Page 75 Forced Login Right clicking the report list provides a Preview Report force login popup menu option for forcing a login window before previewing the report Preview Report Preview Report new window Preview Report Force login Print Report default printer Print Report select printer Export Report Delete Row This is useful when a previous report connected to one ODBC data source and you wish to run the same or another report against another ODBC data source you wish to login to the same data source under a different user id without restarting DataLink Viewer You wish to avoid the default login information provided by Integrated Authentication without bothering to go into the Options dialog and turning Integrated Authentication off Note for some ODBC data sources Crystal Commands there are some scenarios where the only way to avoid connecting to a previously opened connection is to close and reopen DataLink Viewer 2002 2015 Millet Software Page 76 Selecting Folder Location for FoxPro DBF Files MasterBuilder DataLink Viewer 2011 supports dynamic selection of data folders for reports using the Visual FoxPro ODBC driver for a File DSN using Free Tables which are dbf files under a giv
34. Cancel Apply 2002 2015 Millet Software Page 68 RIGHT CLICK THE GRID AND SELECT PREVIEW REPORT NEW WINDOW When you righ click a report row in the Select Report tab a popup menu provides you an option of Preview Report new window If you click on that option the report would launch in a new window REMOVE THE PREVIEW TAB FROM THE INITIAL WINDOW If you wish to always use the initial DLV window to launch reports into new preview only windows you may want to completely remove the Preview tab from the initial DLV window You can achieve that by setting the following options in the DataLink_Viewer ini file Options Show_Preview_Tab FALSE Note this option takes effect only if you also use the Options dialog to turn on the option for Double Clicking a Report Row in the Grid Launches the Report to a View Only Window When these two options are set DLV changes several things 1 The initial DLV window shows only a Select Report tab 2 The right click menu option of Preview Report is not shown Instead only the Preview Report new window option is visible 3 The right click menu option of Preview Report force login launches the report to a new window instead of to the Preview tab which is not available The end result is that the initial DLV window becomes just a launch pad to report previews 2002 2015 Millet Software Page 69 Database Choice Functionality DataLink Viewer provides login dialogs to support an
35. Fetching parameters are typically used to control how the data is displayed on the report for example grouping sorting and section suppressions DataLink Viewer allows you to specify values for such parameters when using saved data For example C Program Files Millet Software DataLink Viewer 201 1 DataLink_Viewer_2011 exe v C temp Report rpt Use_Saved_Data True Parm1 Detail Argument for Setting Formula Expressions You can set formula expressions via a command line argument provided that e The formula name s must begin with a a character e Any double quotes are specified as dblq e Only main report formulas are targeted The command line argument starts with Set_Formulas1 followed by pairs of Formula Names and Formula Expressions The name is separated from the expression by gt gt gt Each pair is separated from the following one by like this Set_Formulas1 Name133SExpression1 Name255SExpression2 For example the following command line argument would set the first specified formula expression to the string Ido and the second formula to the numeric expression of 2 2 Set_Formulas1 MyName 33 dblq Ido dblq TwoAndTwo 3352 2 2002 2015 Millet Software Page 58 Command Line Arguments for Triggering Scheduling Exporting Using the Export command line argument you can trigger or even schedule exporting for a report so the user doesn t need to preview the report or see the Da
36. ISABLING REPORT PREVIEW BuTtIONS ttt t ttt e e e ere ere ere ere rererererererere 96 DISABLING DATALINK VIEWER BUTTONS ccccccccccccccececccesececececesesecesececesesesesesesecsseseseseseesessessesusssusesesssssessseseseaes 97 DISABLING LOGIN DIALOG MEMORY OF LasrUsesi 97 ADD YOUR COMPANY INFO TO THE ABOUT DiaAtLOoOo 98 FILE LOCATION amp REDIRECT LOGICS icccecsescccesbcscevetbecteuebe sack oceoeecouss a a a a a a a e a 99 Checking and Navigating to Key File Locations ec eesssssssecseesecesesecsseceessecaeesccnesecsaeeecsaecasesesseesesnaeseeeas 100 Citrixiand File Location Functionality 25 6 c cccsisotssadecs pasteciedevensssenstusesvesehssbansovsessbsvesonpaseyeetietnasnesstulessastesenses 101 Setting Integrated Authentication for Multiple Machines Citrix Fam 102 Enforcing Settings in a Master DataLink_Viewer ini blei 103 Updating DataLink_Viewer ini via a Delta Pie 104 EXPLICIT ASSIGNMENT OF DEFAULT PRImNTER tt t ttt e orere re rererere rerererererere 105 SETTING ENCRYPTED PASSWORD ENTRIs 106 KNOWN ISSUES AND LIMITATION ccssssccssssccsssscccssssscccsssccsscssccccsssccccsscaccccssseseessecccesssaccccsscessessscecessnes 107 UPDATE HISTORY ssssisscosicsssccsticsesccsssusesssevseccosevsecsssecsacssbeccoosesncsesesbensesesbecseenstcbsessdessuvendesseseedocseseassudacesdecdecsasense 108 VERSION 6 5 2002 SP15 ENTERED TESTING DECEMBER 8 2018 108 VERSION 6 5 1001 SP15 NOVEMBER 25 2018 109 Eegiel ee Ee
37. LUES STORE AS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING LOB CONNECTION_PROPERTIES STORE AS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING LOB REPORT_SQL STORE AS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING Sequence to allow the trigger to auto number the primary key CREATE SEQUENCE DLV_LOG_SEQ Trigger to automatically generate the primary key values CREATE OR REPLACE TRIGGER DLV_LOG_INS BEFORE INSERT ON DLV_LOG FOR EACH ROW WHEN new LogN IS NULL BEGIN SELECT DLV_LOG_SEQ NEXTVAL INTO new LogN FROM dual END 2002 2015 Millet Software Page 91 ORACLE MODE BIND VARIABLES If you wish to log processing to an Oracle database you should add the following entry to the Options section of DataLink_Viewer ini Log ODBC_Type Oracle That option sends Insert SQL statements using bind variables an approach that avoids a 4K column size limitation HOW TO START LOGGING The following DataLink Viewer Options dialog allows you to specify the ODBC Data Source Name DSN where the DLV table resides and the User ID amp Password stored encrypted if the data source requires a login Options File_Locations You can OVERRIDE the default location application folder of the 1 DataLink_Viewer ini file 2 ReportList Txt saves and populates the report list in the grid C Documents and Settings ixm My Documents BNETDataLink View
38. OLLATE SQL_Latin1l_General_CP1_CI_AS NULL Machine_ID nvarchar 255 COLLATE SQL_Latin1_General_CP1_CI_AS NULL Parameter_Values nvarchar 40000 COLLATE SQL_Latin1_General_CP1_CI_AS NULL Connection_Properties nvarchar 40000 COLLATE SQL_Latin1_General_CP1_CI_AS NULL Report_SQL nvarchar 40000 COLLATE SQL_Latin1_General_CP1_CI_AS NULL Live_Data_1_0 int NULL Records_Read_N int NULL Export_Activity_1_0 int NULL Print_Activity_1_0 int NULL ON PRIMARY GO Note for recent versions of SQL Server replace nvarchar 40000 with nvarchar MAX 2002 2015 Millet Software Page 90 ORACLE DATA STRUCTURE The script below contributed by Jonathan Klobucnik from A H Belo also includes a definition of a Sequence and a Trigger to handle the Auto Numbering requirement CREATE TABLE DLV_LOG LOGN NUMBER 0 NOT NULL RPT_PATH NVARCHAR2 255 RPT_NAME NVARCHAR2 255 PROC_START_LOCAL NVARCHAR2 255 PROC_END_LOCAL NVARCHAR2 255 PROC_START_GMT NVARCHAR2 255 PROC_END_GMT NVARCHAR2 255 WINDOWS_USER_ID NVARCHAR2 255 MACHINE_ID NVARCHAR2 255 PARAMETER _VALUES CLOB CONNECTION_PROPERTIES CLOB REPORT_SQL CLOB LIVE_DATA_1_0 NUMBER 0 RECORDS_READ_N NUMBER 0 EXPORT_ACTIVITY_1_0 NUMBER 0 PRINT_ACTIVITY_1_0 NUMBER 0 CONSTRAINT DLV_LOG_PK PRIMARY KEY LOGN ENABLE LOGGING PCTFREE 10 INITRANS 1 STORAGE BUFFER_POOL DEFAULT LOB PARAMETER_VA
39. _Prompts 9 rpt vi Pi Export pt ON P Print ar Print with EAT Anen with gt Open launches a report to a Preview window Export exports the report to a user selected export format and disk file Print prints the report to the Default printer Print with prints the report to a user selected printer These options allow users to invoke exporting or printing of a report without previewing it This means users don t have to wait for the preview to complete before providing exporting or printing choices Similar choices are available from the full user interface in DataLink Viewer by right clicking a report row in the 1 tab grid However some users may prefer to use File Explorer as a launch mechanism without starting DataLink Viewer Note DataLink Viewer associates these file explorer actions with rpt and rpz files only on PCs where these extensions are not already associated with other applications This means that on a machine where Crystal Reports is already installed where rpt files are already associated with the Crystal application you will not see these right click menu options in File Explorer 2002 2015 Millet Software Page 49 Launch Reports from Command Lines DataLink Viewer allows you to launch a report from another application or from a shortcut using a command line The general structure of the command line is 1 the full path and name of the DataLink Viewer executable 2 S or V as a processing
40. a DataLink_Viewer ini at a different location This allows you to enforce this type of parameters from a centralized location Securing Reports against Unauthorized Use If you wish to secure your reports against unauthorized use you can provide authorized users a License Key string for the ini entry Within the report later distributed to clients as an rpz file you design a record selection criterion that returns true only if the license key matches the company name in the database As a simple example you could check the number of characters in the license key is equal to the length of the actual company name in the database plus the number of R s in that company s name If you don t have access to the company name in the database or if you wish to issue per machine licenses use the technique described in the next section 2002 2015 Millet Software Page 20 Load Machine Company Report Information into Parameters DLV_MACHINE_NAME If a report has a single value string parameter called DLV_Machine_Name DataLink Viewer automatically sets the value of such a parameter to the Windows Machine Name on which DataLink Viewer is running DLV_REGISTERED_COMPANY If a report has a single value string parameter called DLV_Registered_Company DataLink Viewer automatically sets the value of such a parameter to the Company Name specified when the Windows operating system was installed In conjunction with the ability to load ini value
41. able user interface buttons by setting the following options in the DataLink_ Viewer ini file Options Disable_RPZ_Creation TRUE Disable_Check_for_Updates TRUE Disable_Options_Dialog TRUE Disable_Browse_Dialog TRUE Disable_User_Manual TRUE Disable_Version_Info TRUE Note see Enforcing Settings in a Master DataLink_Viewer ini File for information about enforcing these settings from the master ini file to all user ini files Disabling Login Dialog Memory of Last User ID By default DLV remembers and displays the last User ID specified in the login dialog To disable that behavior set the following option in the DataLink_Viewer ini file Options Last_User_ID DLV_DISABLED 2002 2015 Millet Software Page 97 Add your Company Info to the About Dialog In DataLink_Viewer ini you can set 3 lines in the About dialog to text of your choice This can be useful in a large company where you want users to know who to contact with technical questions It can also be useful when you sell Crystal reports bundled with DataLink Viewer and you wish to specify your contact information for similar reasons For example using the following settings in DataLink_Viewer ini Options About _Linel www acme com About _Line2 For Technical Support contact Jane Doe About _Line3 Jane Doe acme com 888 1234 4567 you would get the following About dialog Note as demonstrated with the www acme com line DataLink Viewer au
42. ality the sample report DLV_Column_Header_Sort reacts to clicks on column headers by resorting the report based on the clicked column header A short video demonstration is available at http www milletsoftware com Download DLV_Sort_By_Click wmv The four column headers are clickable formulas 1 DLVSet_1 Sort1 with a string value of Customer Name 2 DLVSet_2 Sort1 with a string value of Region 3 DLVSet_3 Sort1 with a string value of Country 4 DLVSet_4 Sort1 with a string value of Postal Code The target formula Sort1 starts with a design time value of Customer Name and as its value gets changed due to user clicks the SortBy1 formula reacts by returning one of the 4 database columns Customer Name Region Country or Postal Code This in turn changes how the report groups are sorted Note group rather than record sorting is used in this sample report because the Crystal runtime components don t re sort records unless the report data is refreshed from the database The Group re sort occurs all on the client side without hitting the database again Click to Show HTML Tooltip Ae Heng If the tooltip of a formula or any other object begins with lt HTML gt DLV assumes the tooltip contains rich content that should be displayed in an independent window Crystal allows you to set the Tooltip property of any object to a complex expression so you can easily accumulate a lot of detail into nicely formatte
43. an Chr 10 3 The Title the text shown as the title of the InputBox dialog 4 The Default value 1 in the example above How Many Copies for Endorphin Please Specify How Many Labels Notes 2002 2015 Millet Software Page 66 Launch another Application and Pass Parameters to It DataLink Viewer lets you launch any other application and pass parameters to it by double clicking a report section that contains a formula that statically or dynamically results in a string with the following structure EXE_Run Any_Program exe command line arguments Note TN When you need to embed double quotes into the result of a string formula you must escape the double quotes with another double quote Here are some variations on that theme EP A add a double quote E a start the resulting string with a double quote Za end the resulting string with a double quote insert a double quote into the middle of the resulting string 2002 2015 Millet Software Page 67 Launching Reports in a New Window By default the initial DataLink Viewer DLV window displays two tabs Select Reports and Preview You select a report from the first tab and view it in the second tab However in many cases you may wish to launch a report from the initial window into a new preview only window You may also wish to remove the Preview tab from the initial window This section describes the various options for achievin
44. an also trigger auto refresh by using an Auto_Refresh argument when invoking a report from a command line Here s how you would trigger a viewing of a report and auto refreshing it every 5 minutes 300 seconds C Program Files Millet Software DataLink Viewer 201 1 DataLink_Viewer_2011 exe v C temp Report rpt Auto_Refresh 300 Saved Data Auto Refresh Imagine a case where a huge report takes 30 minutes to run and 10 users wish to monitor the data in that report by auto refreshing it Instead of each of the 10 users waiting for the report to retrieve data on their PC you can schedule the report for example using Visual CUT to export to a Crystal Report format The resulting rpt file has all the information as Saved Data inside the rpt file The 10 users can then open the exported rpt in DataLink Viewer and elect to not refresh the saved data If the report was launched with an Auto_Refresh command line argument the users can elect to keep loading the saved data on each refresh cycle allowing the latest exported data from Visual CUT to be reflected in the auto refreshed report within DataLink Viewer To tell DataLink Viewer to use saved data during Auto Refresh use a command line like this C Program Files Millet Software DataLink Viewer 201 1 DataLink_Viewer_2011 exe v C temp Report rpt Auto_Refresh 600 Auto_Refresh_Use_Saved_Data True Specifying Parameters When Using Saved Data Auto Refresh Some param
45. are Page 77 Changing Folder Location for Access Excel Pervasive Paradox ACT Files If your report uses the native connection to MS Access or Excel files or if you are connecting to Act via pad files or Pervasive ddf files you can control the location of the database files using the following section in DataLink_Viewer ini Database Path Selection Paths C Old xtreme mdb gt gt C New xtreme mdb C a test mdb gt gt for Pervasive ddf files Paths E Jobtrack FILE DDF gt gt for ACT pad files Paths E DB1 DB1 pad gt gt E DB2 DB2 pad for Paradox specify only path to DB files Path C Old gt gt c New Note you can also use a Database_Path_Selection command line argument As demonstrated above the Paths entry may contain multiple pairs of old gt gt new paths Each pair specifies the old path followed by a gt gt separator followed by the new path The pairs are separated by a If the new path is blank or if it contains just a question mark DataLink Viewer will prompt the user to select a new path when a report using the old path is first used If the new path has one question mark followed by a valid path that path will be the default location in the dialog asking the user to select a path If instead of a single question mark the new path starts with a double question mark DataLink Viewer will always prompt the user to select a path each time a report using the old path r
46. ations for detail 2002 2015 Millet Software Page 46 Report Inspection amp Documentation Tools Note these tools work with rpt files rpz files are protected Expression Inspector DataLink Viewer allows you to inspect report formulas SQL expressions running totals selection formulas and conditional formatting expressions for one or multiple reports A right click menu on a report grid row provides the following menu options GA Open Containing Folder amp Generate Command Line Reload Title amp Subject a het a Formulas amp Expressions in Multiple Reports A Use Smaller Font The results are presented in a grid allowing grouping sorting searching exporting and filtering gt Formulas amp Expressions in This Report Formulas that fail to compile are presented with an error message See a full sized sample image here http screencast com t 74ux1XgWRms Good SQL Running election x Fna aea Subreport Object ObjectType Section Expression Expression Type UseCount Error Message test1 Field Detala Currentdate lt 1 1 2015 EnableSuppress est Field Detala If 1 2 Then True else False EnableCanGrow test1 Field Detala test ToolTipText test1 Field Detail a Show this instead DisplayString test2 Field GHia Currentdate lt 1 1 201
47. ble Click to Use x 2001 to 2009 All Products Barbados Sports Profit Double clicking any of the entries or selecting an entry and clicking the OK button would launch a dialog allowing you to reuse that set of saved parameter values or selectively change some of these saved parameter values This functionality was designed to address scenarios where reports with many parameters are used in one of several parameter patterns By saving and naming these patterns the user can reuse them Note if you are a report developer you can deliver these saved parameter patterns to a user machine by copying the Named_Parameter_Sets section in your DataLink_Viewer ini file to the user s DataLink Viewer ini file 2002 2015 Millet Software Page 17 Click to Change a Parameter Value If you place a main report parameter on the report layout when a DataLink Viewer user clicks on that parameter DataLink Viewer prompts the user for just that parameter That allows your users to simply and intuitively select just one parameter to refresh TOGGLING BETWEEN 2 PARAMETER VALUES If a user clicks on a parameter that has exactly 2 default values no custom values allowed DataLink Viewer toggles the value of that parameter to the other value This provides many useful behaviors The sample report demonstrates toggling between viewing Profit or Revenue by simply clicking on the Metric parameter Another parameter allows toggling between expandi
48. bsolute path to these reports either specify just the report name without a path or you may use a DLV_RPT_PATH token and DataLink Viewer will replace it with the path for the currently viewed report For example DLV _Run v Chr 34 DLV_RPT_ PATH Product Type Catalog V12 rpt Chr 34 Chr 34 Parml Product _Type Product Type Name Chr 34 CREATE A USER INTERFACE FOR SELECTING AND LAUNCHING REPORTS The ability described above launching one report from another allows you to very easily create a user interface that lets your users select and launch reports The key steps are 1 Create a REPORT Table with one record for each report Typical columns would include a the path and report file name b a description of the report c report subject Profit Product Returns Orders d report frequency Daily Weekly Monthly etc 2 Create a Report Selection report listing these available reports with a formula in the detail section for launching the selected report Note you can design the main report with Parameters for listing only reports of certain subjects or certain frequencies Of course the REPORT table must store these classifications Let the user run the Report Selection report and launch the selected report by double clicking it 2002 2015 Millet Software Page 65 EMBED INPUT FROM THE USER IN THE COMMAND LINE CALL FOR ANOTHER REPORT When launching another report by
49. ce Drill Down functionality A report may initially preview with all details collapsed like this A DataLink Viewer DLV_In_Place_Drill_Down_11 rpt Select Report 1 1 Product Type 3 27 2006 3 14 PM Preview So SR mw x BusinessObjects E3 Revenues and Days to Ship in 2004 4 Revenue 1 970 125 5 954 49 985 495 540 12 166 51 696 10 206 265 533 Days To Ship 2 8 2 8 2 8 2 9 2 9 2 9 2 9 3 2 DLY_In_Place_Drill_Down_11 1pt 2 616 Records The buttons are actually a formula that return a plus or a minus sign When the user clicks on the these buttons the level 2 detail is revealed Product Type Competition Product gt SlickRock D Nicros D Rapel Gloves Kids 2002 2015 Millet Software Revenue 1 970 125 5 954 49 985 495 540 Supplier Craze Craze Craze 12 166 51 696 Days To Ship 2 8 2 8 2 8 2 9 Revenue Days To Ship 185 397 28 147 790 28 161 854 29 2 9 2 9 Page 38 And when a button another formula in level 2 is clicked level 3 detail is revealed Product Type Revenue Days To Ship Competition 1 970 125 2 8 Locks 5 954 2 8 Helmets 49 985 2 8 Mountain 495 540 2 9 Product Supplier Revenue Days To Ship SlickRock Craze 185 397 28 D Nicros Craze 147 790 28 Customer Country Revenue Days To Ship Sports Fever New Zeakac 330 11 0 Blazhag Bikes USA 1 319 8 0 Pke
50. d by the number of specified seconds For Time parameters this argument returns just the current time adjusted by the number of specified seconds For example if the current datetime is June 17 2008 5 22 38 PM then Now_Minus_3600 returns June 17 2008 4 22 38 PM for a DateTime parameter and 4 22 38 PM for a Time parameter 2002 2015 Millet Software Page 55 You can specify a Date Constant as the parameter value in a command line invocation of DataLink Viewer For example or for a range parameter Benefits these date constants allow you to use the same report interactively specifying any date as the parameter value as well as in scheduled mode This can also lead to since using date functions in the record selection formula within the report can force record selection to be performed by Crystal instead of by the DBMS Note for DateTime parameter the Time portion of the parameter value is set by these constants to 12 00 00 AM start of the day To set a DateTime parameter to the end of the day 11 59 59 PM you must include the parameter name in a DataLink_Viewer ini entry under the Options section like this the parameter names are separated by I 2002 2015 Millet Software Page 56 NUMBER CONSTANTS When triggering viewing printing or exporting via a command line for a report that has a Numeric parameter you may want to set the parameter to a constant reflecting a year or a month relative to the current year o
51. d Close Call Shell stAppName 1 End Sub 2002 2015 Millet Software Page 51 Referring to Saved Encrypted Passwords This section describes how to centralize and protect passwords by avoiding specifying them directly inside command line argument Instead you can name encrypt and store the passwords inside DataLink_Viewer ini Besides protecting your passwords this also allows you to change the passwords in one location instead of in multiple command line arguments Instead of specifying a plain password in a command line such as C Program Files Millet Software DataLink Viewer 2011 DataLink_Viewer_2011 exe v C temp my rpt user_id dba password sesame You can refer to a saved and encrypted password like this C Program Files Millet Software DataLink Viewer 2011 DataLink_Viewer_2011 exe v C temp my rpt user_id dba password Encrypted_Password_FTP To save the encrypted password go to the Launch tab in the Options dialog and click on the Encrypt amp Save Password button This provides the following dialog Encrypt and Save Password to DataLink_Viewer ini Options Sectior Password Name FTP Encrypted_Password_FTP 2CDA636786B09644 74 E4003182BAD 1E2961E20D00E57831D018D9FF78B1 Password lessscssscsssss j BD3 The ini file entry is always named as Encrypted_Password_ followed by the password name you specify So in my case the full name is Encrypted_Password_FTP From that poi
52. d HTML pages including HTML tables To see how Crystal formulas can build an HTML table from report data visit this video demo The key advantage of this technique is that in some cases you want to display detail data side by side with the main report That is something that On Demand Subreports or Drill Downs typically can t provide You can even click on several objects to open multiple HTML tooltip windows and arrange them side by side Notes e You can press Ctrl P to print the content of any HTML tooltip window e DLV remembers the location amp size of the last opened HTML tooltip window e Ifthe tooltip HTML syntax includes a lt Title gt lt Title gt tag the tooltip window reflects that title e HTML Tooltip windows are automatically closed when you refresh or navigate away from the report preview window To automatically close the tooltip windows also on events such as drill down paging and parameter panel refresh set the following entry in the DataLink_Viewer ini file to TRUE Options Close_HTML_Tooltips On Page Events True 2002 2015 Millet Software Page 37 In Place Drill Down Video Demo Crystal s Drill Down functionality is limited to opening the detail in a new tab However in many cases users prefer to expand collapse detail within the main report tab By adding to the report a few formulas and using them in the suppress expression of detail sections DataLink Viewer allows you to achieve In Pla
53. d values from the current report are automatically passed to the new report Specify these arguments only if you need to override these values y should be the preferred option when you launch a report into a new window because it removes the Select Report tab from the new window simplifying what the user sees This also increases the window space dedicated to showing the report Here are some examples of such String formulas invoke a second report and load it into the Current Preview Tab DLV_Run_Here s c directory subdirectory Report rpt launch into a Preview Only V window and specify some parameter values DLV_Run v c CR My_Report rpt Parm1 Cust CUST_N ven Parm2 Prod PROD_Code mm full DLV window S and specify both login as well as Parameter information DLV_Run s Some_Report rpt user_id dba password sql Parm1 1997 Note When you need to embed double quotes into the result of a string formula you must escape the double quotes with another double quote Here are some variations on that theme seat add a double quote 1 start the resulting string with a double quote ee end the resulting string with a double quote i insert a double quote into the middle of the resulting string 2002 2015 Millet Software Page 64 CURRENT REPORT PATH TOKEN If you wish to launch another report in the same folder as the current report file without knowing the a
54. down issue when the group value contains a single quote 2002 2015 Millet Software Page 118 Fixed an issue with remembered parameter values when they end with hyphens e If an Excel or Access file data source is specified in the report via relative path and the file exists in the same folder as the report DataLink Viewer uses the file in the same folder as the data source Paths to sample reports in the report list grid are now updated to C Program Files x86 on first time launch of DataLink Viewer 32 bit version on a 64 bit machine Version Info and Options dialogs now always maintain their position in front of the main DataLink Viewer window Improved the help screens triggered by function key F1 When the login dialog shows alternative ODBC DSNs to select from if the machine has more than 9 DSNs the dialog provides a search panel allowing you to enter text to search the list of DSN This makes it more efficient to locate a particular DSN in a long list of DSNs Added a DataLink_Viewer ini option of Skip_Complex_Login_Logic By default this option is set to False This allows DLV to have full control over the login process change ODBC DSNs servers databases and data source paths on the fly and capture encrypted Integrated Authentication information Setting this option to True solved a database connection failure for one user with an Oracle ODBC connection with tables that belong to different schemas
55. e launched by double clicking or by Right Clicking or by selecting and clicking the Preview Tab Use the D button to reload a report if changed and saved in Crystal Use the EI button to access a dialog for setting various options These options are maintained in the file DataLink_Viewer ini Lf p Use the button to open this User Manual inside MS Word 2002 2015 Millet Software Page 9 Use the button to compress amp encrypt RPT files into RPZ files This allows you to protect and hide your reports designs either as an intellectual property issue or as a tech support issue See the section on Protecting Report Designs with rpz Files for more detail on this feature Use the button to access a dialog with Version and system information That dialog also has a button that allows you to check for software patches on my web site and install them online This patching mechanism is very fast since the patches are typically very small contain only file changes x RIGHT CLICK REPORT ROW MENU Use the button to exit DataLink Viewer if you Right Click a report row in the grid the following popup menu is displayed Preview Report Preview Report new window Preview Report force login Print Report default printer Print Report select printer Export Report Delete Row To delete a report from the grid but not from the hard drive select Delete Row from the popup menu or select the report r
56. eceecesecesecsecaeceaecnaecaaecaeecaeeeseeeneeeseeeeeeereeerensees 24 Respond to Multi Value Live Prompts cceesssesscssesecssecseesecseesecseesecsaeceesecseesecneesecnaeeeesaecaessecseeaesneeeeeeaees 25 Manage Display amp Data Values for Live Parameter 0 cccescsesscseesecsseeeessecseesecseesecsaeeecsaeceessecaeesesneeeeeaees 26 View the Renette NEE KEE E ed ee 27 DYNAMIC AND CASCADING PARAMETERS DEVELOPER Nope 28 Naming Parameters i ui ee tina ee tion E EES keane eee 28 Designing Live Prompt Reports iniisa eir Site nove toh his bane aaa eee 28 Implementing a Select All Option EN 29 Sharing Values Across Cascading Parameter scscssscsssssceseseeesecscesccneesccsaeeecesecaeesecneesecsaeeeesaesaeesesnesseeeaees 30 Requiring a Value for a Dynamic Parameter 0 0 seeccesssccsseeseesecseeeceeecsaeceeaecseesecsesscesaeeeceaecesesesaeeeeeneseeeeaees 31 2002 2015 Millet Software Page 2 Forcing Users to Select from the List of Values No Direct Ed 31 AUTO REFRESH REPORT csscssscsssscssssscsscncsscsscncsscscnsssscscnsssscecnessccecnessscusessscusnessscessessscusnsssssusnessssesnesssoess 32 AUTO_REFRESH COMMAND LINE ARGUMENT onsin nnr ii iE ERR EE RE RE 33 SAVED DATA AUTO REFRESH orea a a e E E N a a a a a a a 33 SPECIFYING PARAMETERS WHEN USING SAVED DATA AUtOoRrrREsn 33 AUTONPAGE AND SREFRESH ee aa a era Ea a E REE hee EE dE Eet 34 VIEWMODE REMOVE TOOLBAR STATUS BAR TITLEBAR cccssssscecsescec
57. ed Layout to Earlier Position Ctrl Shift Down Shift Saved Layout to Later Position Ctrl C Copy Display to Clipboard Ctrl P Print Ctrl S Save Layout to a New Name Ctrl Shift S Save Layout to Last Loaded Name Ctrl Shift X Delete Last Loaded Layout Name Location of Visualizations File for this report C Program Files Millet Software DataLink Viewer 2011 DLV_2011_Visualization_Demo dhywv 2002 2015 Millet Software Page 45 ig Attributes of Orders Order Date EE Orders Order Date 1 Year 2 Quarter Adding Hierarchies A 3 Month As shown for Orders Order Date to the right each date column automatically FE sen generates a dimension node with a date hierarchy of Year Quarter Month and Day ES Year The dimension node also hosts these elements plus Week and Week Day as SS Quarter separate attributes in case the user wishes to use them independently e g Revenue ve by Quarter regardless of the Year SR Week Day However you may want to add your own custom hierarchies The Product and F E puea Market hierarchies shown to the right demonstrate how you can package attributes E oa 1Class into a hierarchy node so that a user can drag the whole hierarchy to a shelf and 2 Type proceed to expand collapse its branches 3 Product 23 Class Each custom hierarchy is located under its own dimension node The dimension i Type r au Product node also hosts the hierarchy attributes as independent elem
58. election via a double click You can now disable extra application exit processing once per 12 cases DLV moves ReportList txt to the recycle bin and deletes temp files created by the Crystal runtime by creating the following entry in the master DataLink_Viewer ini Options section Disable Exit Processing True Added special handling for a Citrix scenario where file redirects might experience some network latency Folder location options for files such as DataLink_Viewer ini and ReportList txt can now include references to environment variables such as USERNAME This is useful for Citrix TS scenarios Fixed an issue with re saving a data visualization layout under the same name Fixed an issue with native ADO connections to Access Excel Fixed an issue with specifying a main report parameter via command line argument when the parameter is linked to a subreport stored procedure parameter Fixed a report load delay when using saved data and Integrated Authentication is turned on 2002 2015 Millet Software Page 113 Improved error message for a rare report load failure Fixed handling of optional text log file location e Fixed an issue with exporting from the report grid right click menu option Fixed an issue with the button to reset integrated authentication information Fixed handling of double quotes within ParmN command line arguments Fixed an issue with storing the extra Folder locatio
59. en folder IMPORTANT NOTES 1 The File DSN must be present and user should have modify permissions at C Program Files Common Files ODBC Data Sources or on a 64 bit machine C Program Files x86 Common Files ODBC Data Sources but not in both locations 2 The folder choice actually changes the File DSN so you may wish to create a dedicated File DSN just for your Crystal Reports This functionality was originally developed to support Intuit Master Builder company reports where each company s data is located in a different folder on the same PC Two sections in the DataLink_Viewer ini file control this functionality Folder_Selection_DSNs Visual_FoxPro_DBF IMB7 Data dsnlIMB Data den MB7 Data dsn Folder_Selection_Must_Contain company dbf Enable_Folder_Selection TRUE The 1 section specifies which File DSNs call for this new functionality The File DSNs are specified exactly as they are named in the report itself They must be enclosed in Il as delimiters even for the first last or only entry The 2 section specifies in the case of Master Builder data that users should be allowed to select only folders that contain a company dbf file That section also allows users to Enable or Disable dynamic folder selection is Select The Company Folder For This Report wll x ER LOCAL DISK DI 1 4 2 2 Landscaping C Direct Deposit J Images C Reports pen Folder Selected Canes 2002 2015 Millet Softw
60. en populating large report list grids A double click on editable cells in the report list grid Title Description Subject Type now launches a preview of the report Using the Print_Copies argument you can now set custom text on each print copy such as Copy 1 of 2 Copy 2 of 2 See Setting Custom Text for Each Print Copy and this demo image Added Export_Viz command line argument to save data visualization to an image Combining this with Visual CUT allows embedding of visualizations in reports email message bodies and auto refreshing web dashboards Packaged with Service Pack 15 of the Crystal Runtime Fixes printing issues Fixed install problem in older Windows platforms XP 2003 Fixed an issue with saved date parameter values Fixed an issue with saved linked dynamic parameter value Fixed issues with Grid search Ctrl F F3 Shift F3 Fixed issue with triggering a parameter dialog by clicking on a formula 2002 2015 Millet Software Page 110 2002 2015 Millet Software Page 111 Version 6 4 1003 SP12 November 29 2014 Packaged with Service Pack 12 of the Crystal Runtime NEW FEATURES Added special handling for printing using custom paper size This involves targeting the custom paper size by saved name rather than by ID which can be different across machines Added Printer_Setup command line argument This allows control of printer name and the Dissociate Formatting Page Size and Pr
61. ents By applying user ata Market friendly names to all these nodes the user can find these attributes more easily de Market 1 Country You can add custom hierarchies for your visualizations by adding a 2City Visualization_Hierarchies section to DataLink_Viewer ini See example below A 3 Customer The Top_Nodes entry in that section specifies what columns if found in the report SS Country data should be used as top nodes in custom hierarchies The column names are H separated by Di meng Each top node such as Product Product Class has an entry defining the following elements e Hierarchy Label followed by For example This label applies also to the dimension node that hosts the hierarchy and its components e This is followed by the sequence of attributes making up the levels of the hierarchy from top separated by gt gt gt delimiters e Each level is specified as the column name and its friendly name separtated by Visualization_Hierarchies Top_Nodes Product Product Class Customer Country Product Product Class Product Hierarchy Product Product Class Class gt gt gt Product_Type Product Type Name Type gt gt gt Product Product Name Product Customer Country Marke Customer Country Country gt gt gt Customer City City gt gt gt Customer Cu stomer Name Customer Automated Exporting See the user manual section on Fully Automated Exporting of Data Visualiz
62. eport use statistics P Options File_Locations You can OVERRIDE the default location application folder of the 1 DataLink_Viewer ini file 2 ReportList Txt saves and populates the report list in the grid C Program Files DataLink Viewer 12 ReportList txt To Enable Logging of Who ran Which Report When and Where specify just the Path e g c temp for the log file DLV_Use_Log txt Log Processing via ODBC DIV Log Table must exist Log ODBC DSN User ID Password Dynamic_Parameter_Reports_Path Extra Location for Dynamic Parameter Reports Besides the location of the main report and the DataLink Viewer folder B ox canca ao Note folder location options for files such as DataLink_Viewer ini and ReportList txt can include references to environment variables such as 7 USERNAME This is useful for Citrix TS scenarios 2002 2015 Millet Software Page 101 SETTING INTEGRATED AUTHENTICATION FOR MULTIPLE MACHINES CITRIX FARM The Integrated_Authentication_Set_Entry command line argument can automate encrypted storage within DataLink_Viewer ini of login information Database User ID amp Password per specified Windows User ID and Machine Name s In the simplest case this allows an administrator to set or change Integrated Authentication for a user after installation of DataLink Viewer or after database password changes Keep in mind that this login information is stored enc
63. er 12 bin ReportListtxt To Enable Logging of Who ran Which Report When and Where specify just the Path e g c temp for the log file DLV_Use_Log txt Log Processing via ODBC DLY_Log Table must exist Log ODBC DSN DIV Leg 9 v User ID Password Dynamic_Parameter_Reports_Path Extra Location for Dynamic Parameter Reports Besides the location of the main report and the DataLink Viewer folder TC CCU OK Cancel Apply 2002 2015 Millet Software Page 92 Record Report Use in a Text Log File If you use the Options dialog to specify a folder location for a DLV_Use_Log txt DLV creates that file if it doesn t already exist and appends to it use statistics after each report viewing This log file contains one row with column headers followed by one row for each report viewing event The columns are 1 Report Path 2 Report Name 3 User_ID 4 PC 5 Start 6 Finish You can use that file for example using Crystal with a Text ODBC driver to analyze what reports are popular who runs what reports and what reports take too long to run 2002 2015 Millet Software Page 93 Settings amp Options Customizing the Grid Layout By dragging clicking or right clicking the grid column headers you can apply various options such as grouping the report by any column s sorting the grid hiding showing columns etc Here is the menu you get when you right click a column header Sort Ascend
64. er and M with the total number of copies See this demo image 2002 2015 Millet Software Page 61 SCHEDULING PRINTING Since you can trigger printing using the Printer command line argument you can use the Windows Task Scheduler or any other scheduler application to trigger printing of the report For detailed instructions on how to use the free windows task scheduler see the section on Scheduling in my Visual CUT User Manual Visual CUT provides much more powerful report scheduling options at www milletsoftware com visualcutManual htm SCHEDULING PRINTING FOR MULTIPLE REPORTS If you need to schedule printing of multiple reports at the same time the best approach is to place all command lines into a single batch file Then schedule the batch file in the free Windows Task Scheduler as described above Argument for Printer Setup The Printer_Setup command line argument allows you control 1 The Printer Name Note only if the No Printer option is tuned off for the report 2 The Dissociate Formatting Page Size and Printer Page Size property This argument is designed to address use scenarios where during automated export the page size and margins for a specified printer should be used The syntax is constructed as the word Printer_Setup followed by a colon and the following II separated elements 7 Default or leave blank if you don t want to change the printer name m or if you want to contro
65. ere the calling report is 2002 2015 Millet Software Page 116 Fixed rendering of parameter refresh dialogs when user elects to set Display options to larger font sizes Added support for Date Constants and Number Constants when specifying parameter values via command line arguments For example Parm1 Start_Month_Minus_1 For detail see the Date Constants and Number Constants sections in the user manual Using acommand line argument Ignore_Saved_Parameter_Values ALL you can run a report and get prompted for unspecified parameter values skipping the saved parameter values dialog DataLink Viewer now ignores a saved parameter value if that parameter is no longer used in the report Improved handling of Printer Default and Printer Dialog arguments a the main window is minimized unless user interaction with login or parameter dialog is required b if the user cancels from a parameter dialog the process closes without a warning message about missing parameter values c Printer Dialog now closes automatically after printing A configuration file is now available at C Program Files Millet Software DataLink Viewer 201 1 DataLink_Viewer_2011 exe config It allows users to set number of rows per parameter page The status bar at the bottom of the window shows how many records were selected out of the total number of records retrieved e Fixed a login issue with ODBC_DSN command line argume
66. essecnesseeneeseeeaees 78 CHANGING DATA SOURCE NN UDE FILES a de N E A E AE 79 INTEGRATED AUTHENTICATION eeessseesscseessoccesseceesseosssocessoceessecessoecsscoessscooeesseceessecsssseessccecsseceessecsssoeessocseesseee 80 INTEGRATED AUTHENTICATION REMEMBER Me 80 SHARED MACHINE AUTHENTICATION aucsgirunernuirsie nnne ee n a a a e i es ieaie aidia iaai 81 2002 2015 Millet Software Page 4 SHARED SECRET PASSWORD WITH WINDOWS Uscpls 82 PROTECT REPORT DESIGNS WITH RPZ FILES sccccssssscssssscccssssccccssseccesssscccsssecccessccececssscssesecesessssees 83 MAKE_RPZ COMMAND LINE AROGUMENT tettre t ttt t e e e e ere ere e ere ere erore rerererere 84 CREATE RPZ FILES WITH EXPIRATION AND LICENSEktxs 85 Make Rpz2 Comimand Hine Argument ege eeh teseroch area E E a ER AEE TE en 86 MONITORING DATALINK VIEWER USE e sseseessecessseosscccessocecssececssecsscsecsscoceesseceessecsssoecssoceesseceesoecsssoeessoseessese 88 RECORD PROCESSING TO AN ODBC DATABASE trette terere e erete rererere rerererere 88 BK RE 88 MS Access Data KEES 89 SOL Server Data Structure deeg ef a dates eased dee evaded ssestheceudeeshecendon e EERE i 89 LBE EE Te EE 91 Oracle mode Bind Variables sra a e a r a a ris a sa e E Gam Ea iep eS 92 How to Start Log sine egene REET E E A cen dE 92 RECORD REPORT USE IN A TEXT LOG RE 93 SETTINGS amp OPTIONS E 94 CUSTOMIZING THE GRID LAY QUT lt 0 eed cos EA EEE E E E A ees 94 CUSTOMIZING THE GRID STE 95 D
67. esssececsesececseceeceeaeeecsesaeeeseeseeeesseeeeseaaees 34 CYCLING THROUGH SEVERAL AUTO REFRESHED RrpopTs 35 CLICK TO SET FORMULA VALUE serisini 36 CLICK TO SET ANOTHER FORMULA TO CLICKED FORMULANALUR 36 CLICK TO SET ANOTHER FORMULA TO CLICKED FORMULA NAME s sssssssssssesseessteesesereseessttssresstessresseseesereseersernst 36 CLICK COLUMN HEADERS robr SoprTopRrpop 37 CLICK TO SHOW HTML TOO LTIP sccsscscsccsscssssesscssssessossssessessssossessssessersssessessssessossssessessscessersssessersssensores 37 IN PLACE UI E LR AN 38 CONVERTING SECTION DOUBLE CLICK TO IN PLACE DRILL DOWN sccsesceceseeesseeceeeeeneeceseeeeaeecaceeeaeecnaeeeentees 40 DYNAMIC GROUPING GROUP SWAP EXPERT scssscsssssssesscsesesssssscecssssesecssssesscnssseseesessesessessesessessesees 41 OPTIONAL TECHNIQUE FOR GAINING FORMULA ACCESS TO THE DYNAMIC GROUPING ccccceseesseeecececeeeessaeeeeees 42 DATA VISUALIZER iisscissssvscsisssvesonsesvessessovossssossiseasvaensesesnestesessosbuasonsiseasdaosansecnebdesecnossuasensiseasdasssdbesnestesessoosiseaxoane 43 ADDING e Le UE 46 AUTOMATED EXPORTING ee eegne ee Ee RE KE A E E Aa aE ahaa SE 46 REPORT INSPECTION amp DOCUMENTATION TOOLS ccscsscssssssssssscesssseseessssesecsessesecnssesessesseseeneseesees 47 EXPRESSION INSPECTOR umece nae d Ee Eden Eege ee ee ENEE dean vs 47 REPORT DOCUMENTATION EENS EN Eed EES ES ANNE 48 LAUNCHING REPORTS amp COMMAND LINE API sccssscss
68. eters don t participate in data selection Such Non Fetching parameters are typically used to control how the data is displayed on the report for example grouping sorting and section suppressions DataLink Viewer allows you to specify values for such parameters when using saved data For example C Program Files Millet Software DataLink Viewer 201 1 DataLink_Viewer_2011 exe v C temp Report rpt Auto_Refresh 600 Auto_Refresh_Use_Saved_Data True Parm1 Crew 2002 2015 Millet Software Page 33 Auto_Page_and_Refresh Using this command line argument you can request the viewer to automatically advance to the next page every N seconds After getting to the last page the viewer will next move to the first page and also refresh the report data The cycle then continues Here s how you would trigger the process with 20 seconds as the time increment C Program Files Millet Software DataLink Viewer 201 1 DataLink_Viewer_2011 exe v C temp Report rpt Auto_Page_and_Refresh 20 Note to pause the auto page amp refresh process double click on the report Double click again to resume ViewMode Remove Toolbar Status bar TitleBar When you trigger a report from a command line using a v View Only window you can also elect to remove the toolbar status bar title bar in order to maximize the space available for the report itself The command line argument for controlling this behavior is ViewMode and it ha
69. etststs ests ts tetetete stets t stees Esene EEE EEEE EEEE EEEE EEEE EEEE ee eeen eneee eeen ee 68 New Window On File Launch and or On Double Check 68 Right Click the Grid and Select Preview Report new Window 69 Remove the Preview Tab from the Initial Windouw 69 DATABASE CHOICE FUNCTIONALITY sseseessecessseossccecssoceessececssecsscoecssoceesseceesoecssscecssoceesseceessecsssseessoseessese 70 SELECT ALTERNATIVE ODBC DATA SOURCES FOR THE SAMERrpORT 70 RESTRICTING THE LisropODbBCDSNCnocrks 71 Forcing Login for DSN Group Members 71 SPECIFY THE ODBC DSW ENEE dE aI Sa OR Se UGE San ip E 72 OVERRIDING THE DATABASE SPECIFIED IN THE REPORT OR ODBC DSN ssesssssssssssesesererererererererererererererererererererere 72 OVERRIDING THE TABLE LOCATION ODBC ssssssseseseeseeeeesseresssrressseresereesseteessrrsssstessertesseteessreesssteseeetessreessreeeene 73 OVERRIDING THE XML FILE LoCATION a a a a a e ar aa aar Sat 73 STRIPPING TABLE QUALIFIERS WHEN CONNECTING TO A DIFFERENT DATARASb 74 OVERRIDING THE SERVER IN NATIVE ORACLE CONNBCTION 75 SELECTING AN ALTERNATIVE SQL SERVER OLE DB DATA SOURCE ssssssssssessssreseetessereessrresssreesereessereessrreessere 75 FORGED E Ee EE 76 SELECTING FOLDER LOCATION FOR FOXPRO DBF FILES MagrRbum DER 71 CHANGING FOLDER LOCATION FOR ACCESS EXCEL PERVASIVE PARADOX ACT burg 78 Using Command Line Argument to Avoid Path Prompt cccseescsesecseeecssecseesecsevseceaeeecsaece
70. evenue By Product DataLink_Viewer_Year_and_Product_Prompts 12 rpt j3 Records 2002 2015 Millet Software Page 27 Dynamic and Cascading Parameters Developer Notes This section reviews how report designers can activate the extra functionality of linking to live prompt reports NAMING PARAMETERS e In our sample report the live prompt reports and parameter names were Prompt_Order_Year rpt and Prompt_Products rpt Field Explorer x e le as xK t P Database Fields 3 1 Formula Fields SQL Expression Fields Parameter Fields a Prompt_Order_ Year rpt a Prompt_Products rpt E Running Total Fields S Group Name Fields Special Fields DESIGNING LIVE PROMPT REPORTS The reports acting as live prompts should be These reports name Formulas named in such a manner can be clicked and selected within the prompt viewer You can place a field or a formula on the report to let the user select a meaningful Display Value e g Product_Name If you give that field or formula a tooltip text or expression that value would be used as the parameter Data value 2002 2015 Millet Software Page 28 IMPLEMENTING A SELECT ALL OPTION If you run the report again and scroll to the bottom of the live Product Type selection prompt you would notice that you can select the All Product Types option Select Product Types to be included in the Repo
71. fter applying group swaps For example you can design the report to have Employee Last Name as the formula expression for DLV_Group_L1 reflecting the initial design of the report If the user swaps Customer Country for the level 1 grouping DLV changes the expression in the DLV_Group_L1 from Employee Last Name to Customer Country This allows you to build Advanced Charts not limited to the Grouping Hierarchy and CrossTabs that reflect the dynamic grouping The sample report DLV_2011_Change_Group_Demo rpt demonstrates this feature 2002 2015 Millet Software Page 42 Data Visualizer When previewing a report clicking the toolbar button loads the report data into a powerful data visualization tool The idea is to go beyond regular pivot tables or charts The user can drag and drop to display and drill down into data patterns using effects such as multiple data panels animation filtering sorting coloring sizing shapes trend lines and filters DataLink Viewer takes care of loading the report data into the visualizer and mapping it into Measures numeric columns Attributes and Dates Dates are treated as special attributes with Year Quarter Month and day hierarchy Users can then create save and reuse visualization layouts Please watch a 25 minute video demo for more detail Ve shy D A gemeeten X l tz of Attributes ah Orders Order Date i gal Measures
72. g this As described in the sections dealing with the command line api of DLV you can launch reports in a Preview Only window by using v instead of s within the command line However this section deals with user interaction options for achieving the same thing There are several ways to achieve this NEW WINDOW ON FILE LAUNCH AND OR ON DOUBLE CLICK The Launch tab in the DLV Options dialog allows you to direct DLV to launch reports into a View Only window when double clicking an rpt file in File Explorer or when double clicking a report row in the Select Report tab Options Launch Fle Locations Associated_File_Launch_Mode rou can associate RPT ARPZ files with DataLink Viewer by Right Clicking a report file in Explorer and selecting Open With When the user Double clicks an RPT APZ file should they be able to see 1 Both Preview and Report Selection Tabs View and Select or 2 Only the Preview Tab View Only View Only T Saved_Data_Action When DataLink Viewer opens a report with Saved Data should DataLink Viewer Refresh the report with data from the database 2 Display the report with saved data or 3 Prompt the user to decide Prompt Enable_Integrated_Authentication F Allow Storage amp Reuse of Encrypted Database Logon Info for Each Windows User Eat New_Window_On_Double Click Iw Double Clicking a Report Row in the Grid Launches the Report to a View Only Window OK
73. ges on the fly 5 Data Visualizer adding OLAP and advanced charting capabilities 6 Intuitive Customizable Grid Interface to classify organizing and launch Reports 7 Dynamic amp Cascading Parameters even for pre XI reports e Select Live Parameter Values from linked Crystal reports that act as dynamic pick list data sources or default to using Crystal s static parameters e Restrict Live Parameter Values based on choices in a prior live parameter e Remember Values last used for each Live Prompt allowing the user to accept or replace those values 2002 2015 Millet Software Page 6 8 Command Line Interface for launching reports from other programs and from other Crystal reports 9 Protect amp Hide Report Designs by converting your rpt files into rpz files Your users can run the resulting rpz files in DataLink Viewer but cannot view or modify them in Crystal To completely protect report designs DataLink Viewer blocks exporting of rpz files to rpt or report definition files 10 Filter Data based on User Login 11 Export amp Print Reports Directly without previewing 12 Remember Last Export Format and File Name for Each Report 13 Auto Refresh Reports 14 React to User Actions in Useful Ways requires special formulas e In Place Drill Down www milletsoftware com Download DLV_InPlace_DrillDown wmyv e Click to Group Sort http www milletsoftware com Download DLV_Sort_By_Click wmv e Click to set a fo
74. ing Z Sort Descending Group By This Column UR o0 Hide Group By Box Remove This Column Column Chooser Best Fit Best Fit all columns UI ai T Filter Editor Show Find Panel Show Auto Filter Row Most of these options are quite intuitive The Group By Box shows or hides the area at the top of the screen that allows you to control how the Grid is grouped by dragging amp Dropping column headers to from that area Here is the menu you get when you right click the top left corner of the grid Grid Style Y Name vw Title Description v Subject v Last Used As shown above the Columns menu cascades to the list of columns and allows you to directly set column visibility You can do the same via a slightly longer process using the Column Chooser option in the previously shown menu 2002 2015 Millet Software Page 94 Customizing the Grid Style The Grid Style option in the menu you invoke by right clicking the top left corner of the grid bring up a dialog that allows you to customize the look amp feel of the grid Any choice you make in the Grid Style dialog shown below is immediately reflected in the style of the grid The style of the grid is maintained in ReportList grd You can always revert back to the default style of the application by closing DataLink Viewer Deleting that file and starting DataLink again Default Pastel 1 Pastel 2 Pastel 3 Winter UltraFlat Spring Summer Autumn
75. ing the special option in the login dialog 2 The Enable_Shared_Machine_Authentication and Shared_Machine_Authentication information is always taken from the master ini file This allows an administrator to enable disable and change the shared machine authentication for all users in one central file 3 The regular integrated authentication information for a user machine entry that matches the logged in user id and the machine id is always taken from the user ini file if it exists 2002 2015 Millet Software Page 81 4 There can be only one shared machine authentication entry If you need to change to another administrator delete the Shared_Machine_Authentication line and let the new administrator go through the Remember Me and dialog step 5 If the administrator adds more data sources and login information to their integrated authentication information all the machine users would have access to the new data sources This is because the entry is really a pointer to whatever that administrator has accumulated in their entry ixm7 SOBPC02 in my case 6 If you interactively switch between DSNs and you want Integrated Authentication functionality set Enable_Integrated_Authentication_For_DSN_Changes to True This is arare scenario so for more detail contact Millet Software Shared Secret Password with Windows User IDs DataLink Viewer has special functionality allowing an administrator to set change a secret global password for
76. inter C Program Files Millet Software DataLink Viewer 2011 DataLink_Viewer_2011 exe v C temp Report rpt user_id dba password sql Parm1 Gloves Printer Default Here s how you would send a report to a printer selected by the user C Program Files Millet Software DataLink Viewer 2011 DataLink_Viewer_2011 exe v C temp Report rpt user_id dba password sql Parm1 Gloves Printer Dialog Here s how you would send a report to a specified printer C Program Files Millet Software DataLink Viewer 2011 DataLink_Viewer_2011 exe v C temp Report rpt user_id dba password sql Parm1 Gloves Printer Srv1 Laser1 SPECIFYING NUMBER OF COPIES To control the number of printed copies you can use a Print_Copies argument The syntax is constructed as the word Print_Copies followed by a colon and the number of desired copies For example C Program Files Millet Software DataLink Viewer 2011 DataLink_Viewer_2011 exe v C temp Report rpt Printer Srv1 Laser1 Print_Copies 3 SETTING CUSTOM TEXT FOR EACH PRINT COPY Using DataLink Viewer XI R2 in cases where Print_Copies is specified each print copy can have custom text such as Copy 1 of 2 Copy 2 of 2 Simply place a Crystal formula called Print_Copy_Template on the report canvas For each printed copy DataLink Viewer XI R2 would first update the text in that formula by replacing N with the copy numb
77. inter Page Size property This argument is designed to address use scenarios where during automated export the page size and margins for a specified printer should be used The Launch tab in the Options dialog now has a button called Encrypt amp Save Password It allows you to centralize amp protect passwords by avoiding specifying them directly inside command line argument Instead you can name encrypt and store the passwords inside DataLink_Viewer ini For detail see Referring to Saved Encrypted Passwords A new Encrypted_Password_Set_Entry command line argument allows administrators to automate the saving of Encrypted Passwords to targeted ini files For detail see Setting Encrypted Password Entries Report Grid now has drop downs for the Subject and Type columns Report grid right click menu now provides an Open Containing Folder and Generate Command Line options The report list grid style is now managed in ReportList xml file instead of ReportList grd This avoid conflict with incompatible ReportList grd files from older versions of DataLink Viewer 8 5 9 XI R2 The transition from the grd to the xml file occurs automatically Added Test_Connectivity_On_Refresh_Parameters option to the DataLink_Viewer ini Options section and to the Options dialog For certain databases scenarios you may set it to False to avoid that extra step Added Reload_Report_On_Refresh option to the DataLink_Viewer ini Options sec
78. into the database field in the login dialog you need to set the Override_ODBC_DSN_Database entry under the Options section in the DataLink_Viewer ini file to TRUE like this er ren Datibase TRUE Note that if that option is set to TRUE the database specified in the ODBC DSN can no longer override the database specified in the report if the user doesn t type in a Database the specified Database remains the one used in the report Note This functionality is not available in the Crystal 8 5 version of DataLink Viewer 2002 2015 Millet Software Page 72 Overriding the Table Location ODBC This functionality was added for a developer who needed to call DataLink Viewer from his application via a command line The data source was Pervasive via ODBC and a command line argument was needed to control what year archive is used for the report The database contained a table for 2010 GL 10JRL as well as a similar table for 2011 GL 11JRL The report was already designed to reference the GL 10JRL table using a generic alias of GL_JRNL The command line argument to allow overriding the table used for the report looks like this Table From_To GL 10JRL gt gt GL 11JRL AR 10JRL gt gt AR 11JRL Within each pair of From To directives the From location is separated by a gt gt from the To location The pairs are separated by a II from each other Notes 1 If any of the From tables is not found in the report the
79. ions Disable _RPZ_ Creation TRUE Disable_Check_for_Updates TRUE Disable_Options_Dialog TRUE Disable_Browse_Dialog TRUE Disable_User_Manual TRUE Disable_Version_Info TRUE Disable_Print_Button TRUE Disable_Export_Button TRUE Disable_Search_Button TRUE 2002 2015 Millet Software Page 103 UPDATING DATALINK_VIEWER INI VIA A DELTA FILE When deploying DataLink Viewer to many users you may want to automate the process of updating some of the DataLink_Viewer ini settings You can do that by placing a DataLink_Viewer_Delta ini file in the application folder Any entries found in that file will update DataLink_Viewer ini when the application is launched Here is an example of a DataLink_Viewer_Delta ini file Delta_Options Delete_After NEVER USE or NEVER or Some Date specified as yyyyMMdd if entry above not found then default is USE Update_Master_INI False if entry above not found then default is False Update_Slave_INI True if entry above not found then default is True Options Attempt_Logon_Without_Password False Strip_Table_Qualifiers True Saved_Data_Action Display Associated_File_Launch_Mode View Only New_Window_On_DbIClick True Parameter_Values_Remember_Max_Chars 900 Saved_Parameter_Set_Minimum_N 5 Integrated_Authentication Enable_Integrated_Authentication True The Delta_Options section is used only to control the following aspects of the process e The Delete_After option controls when
80. iple values After clicking on Competition and Helmets to select those Product Types click OK to progress to the Products selection within those Product Types 2002 2015 Millet Software Page 25 MANAGE DISPLAY amp DATA VALUES FOR LIVE PARAMETERS In this particular situation the Product Type Name is used for both display value what gets shown to the user in the list of available values as well as data value what gets passed into Crystal as the parameter value As demonstrated in the following step DataLink Viewer allows you to present the user with meaningful product names as display values while passing Product IDs as the actual parameter data value Again DataLink Viewer detects that the parameter called Prompt_Products rpt was designed to accept multiple values and hence it presents you with the linked report Prompt_Products rpt inside a dialog that allows you to click and select multiple values Note that only Products within the Selected Product Types in the previous step are available for selection This demonstrates the power of cascading dynamic parameters Select Products to be Included in the Report Kol hi i Business Obje C Competition Main Report IN Gloves IN Helmets IN Kids Active Outdoors Crochet Glove Active Outdoors Lycra Glove nFlux Crochet Glove nFlux Lycra Glove riumph Pro Helmet riumph Vertigo Helmet Ma ce 3I TTI h Mozzie A Active Outdoors Crochet Glove Delete Active Outd
81. issue and can be fixed using some registry entries For explanation see this blog by Ken Hamady http kenhamady com cru archives 2503 more 2503 It boils down to setting the following registry keys for DataLink Viewer 2011 HKLM SOFTWARE SAP BusinessObjects Crystal Reports for NET Framework 4 0 Crystal Reports Export PDF TruncationAdjustment 2 HKLM SOFTWARE SAP BusinessObjects Crystal Reports for NET Framework 4 0 Crystal Reports Export PDF UsePrecisePositioningForText 1 This enlarges the font and also eliminate the truncation in most cases and when it doesn t you can increase the TruncationAdjustment from 2 to 3 or higher until the problem is resolved Note On a 64 bit machine for the 32 bit version of DLV 2011 the registry paths start with HK LM SOFTWA RE Wow6432Node SAP BusinessObjects 2002 2015 Millet Software Page 107 Update History Version 6 5 2002 SP15 Entered Testing December 8 2015 When exporting a report for the first time the export file name now defaults to the report file name Note for subsequent exports of the same report DLV remembers the last used export file path amp name To automatically close html tooltip windows on events such as drill down paging and parameter panel refresh you can now set the following entry in the DataLink_Viewer ini file Options Close _HTML_Tooltips On Page Events True 2002 2015 Millet Software Page 108 Version 6 5 1001 SP15 November 25 201
82. l the Dissociate Formatting Page Size and Printer Page Size property You may skip that property if you only need to control the Printer Name Here are some examples Printer_Setup MyPrinterName Or Printer Setup MyPrinterName True Or Printer Setup True 2002 2015 Millet Software Page 62 Argument for Documenting File Locations and Report Parameters The Document2INI command line argument allows other applications to request information from DataLink Viewer about key file locations DataLink_Viewer ini ReportList txt design of parameters for a given report The command line call looks like this all in 1 line C Program Files Millet Software DataLink Viewer 201 1 DataLink_Viewer_2011 exe Document2ini c My_Reports my_Report rpt gt gt c temp MyFile ini The two elements after the Document2ini argument name and the colon are 1 the rpt file containing the parameters to document If the rpt file doesn t exist only the key file locations get updated in the ini file 2 The ini file that should be created updated with the documentation If the specified rpt file doesn t exist only file locations are set in the ini file For example File_Locations Master_Ini_File C ProgramData MilletSoftware DLV_2011 DataLink_Viewer ini Slave_Ini_File C ProgramData MilletSoftware DLV_201 1 DataLink_Viewer ini Report_List C ProgramData MilletSoftware DLV_2011 ReportList txt If the specified report does exi
83. licked an item in the dynamic parameter report and that item has an associated data value tooltip expression If the option to remember dynamic parameter values is turned on from that point on that parameter will force the user to select from the list 2002 2015 Millet Software Page 31 Auto Refresh Reports When clicking the Refresh button you can specify that the report should automatically refresh every N seconds As shown in the following dialog when a report has parameters the Auto Refresh option is enabled only when you elect to reuse the current parameter values Refresh Report Data e Use current parameter values C Prompt for new parameter values een When a report doesn t have parameters the dialog is simpler and you can always elect to enable auto refresh Refresh Report Data l Refresh Every Seconds Cancel The auto refresh process stops when you click the Refresh button again or when you select another report When auto refreshing a decrementing progress bar at the bottom of the page reflects the of the refresh interval remaining until the next refresh Lab2 rpt wm A click on that progress bar pauses resumes the auto refresh process If a user is on a drill down tab auto refresh is placed on hold When the user closes the drill down tab or moves back to the main report tab auto refresh resumes 2002 2015 Millet Software Page 32 Auto_Refresh Command Line Argument You c
84. like H where H is the user s Home folder 2002 2015 Millet Software Page 44 e When packaging an rpz file a new checkbox option allows you to embed the dlwv file inside the rpz file e When loading the visualizer for a report that has saved visualization layouts the 1 layout gets applied to the current data automatically A drop down provides access to all the other named visualizations a az fy 4 UU D Customer Discount Versus Revenue Greg by Emp Colored by Customer Vintage Revenue by Customer Vintage Paged by Product Colored by Discount Revenue Cross Tab of Employee by Product Type Colored by Discount J palate as a Function of Lead Time by Customer Sized by Revenue 1 Revenue Bars Colored by Discount Emp x Bicycle x Quarter LI Auto_Saved_On_Exit 1 Revenue Trendline with Late and Lead Time by Employee and Product Type In the example above the top 6 layouts are surrounded with curly brackets indicating these visualizations were embedded inside the rpz file The next 2 items were added by the user and are managed in a local dlvv file Only non embedded entries can be added deleted renamed and sorted by the user Hitting the F1 keyboard key provides the following reminders about useful function keys DataLink Viewer Visualizer F Ctrl Up Show Previous Saved Layout Ctrl Down Show Next Saved Layout Ctrl Shift Up Shift Sav
85. n can be accessed via a report parameter named DLV_Rpz_File_Info 6 Rpz Expiration Date dd mm yyyy The mz file will not run beyond that date unless a license key with a later expiration date is added to the machine 7 Contact Information to embed in the rpz file This information is provided to the user when trying to run an expired rpz or an rpz requiring a new license key 8 Show Conversion Results Dialog True False This controls whether the process will be quiet typical for a scheduled process or result in a dialog showing what files were converted and what options were applied aa a9 Compression amp Encryption to rpz File s Completed x Keep the rpt file s and give your users only the rpz file s Your users would then be able to run the rpz file in DataLink Viewer but wont be able to open it in Crystal Designer ttt Applied Expiration Date Jul 30 2010 Applied License Key Applied rpz_File_Info zz Report File c temp rptiMainReport 1 rpt gt rpz File c temppziMainReport 1 pz 2002 2015 Millet Software Page 86 2002 2015 Millet Software Page 87 Monitoring DataLink Viewer Use DataLink Viewer allows you to monitor the use and performance of reports across the organization via logging to an ODBC table or to a simple text file Logging to ODBC is a more secure and powerful approach and is described first Record Processing to an ODBC Database To log processing to an ODBC database
86. n dialog Launch Tab The user ixm7 then logged in to a secure database by providing a database user id amp password The user turned on the Rememebr Me option visible only when integrated authentication is enabled ia ODBC RDO Login x Server warehouse Database student User ID imz XXXXXXXX Password Cancel The information was then saved for the ixm7 user running on the SOBPC02 PC as shown in the ini file above From that point on the same user ixm7 once logged to the same PC SOBPC02 doesn t need to manually login to the same data source The same user can turn on the Remember Me option for unlimited number of secure data sources and the information for all of them would be maintained inside the encrypted entry The Options dialog allows each user to delete their own integrated authentication information by clicking a button 2002 2015 Millet Software Page 80 Shared Machine Authentication This section describes how one user can elect to share their integrated authentication information with any other user who successfully logged in to the same machine Step 1 First add the entry in bold to the DataLink_Viewer ini file Integrated_Authentication Enable_Integrated_Authentication TRUE ixm7 SOBPC02 scpocar3psBF3484000123301DD155638EAD4AD6B4D622C04DF125B7404BCBC4717ASDA2FBCD94314A7CE63BBE7357E Enable_Shared_Machine_Authentication TRUE Step 2 Then as the key user who will share i
87. n for dynamic parameter rpt files Fixed an issue with command line printing when the report has zero records 2002 2015 Millet Software Page 114 Version 6 3 1045 SP7 November 9 2013 You can now schedule or trigger report exports not just printouts without user intervention This version supports the new features in Crystal 2011 Run rptr read only Crystal reports You can also package rptr files into rpz files with expiration dates and or license keys Export Excel Data Only natively to xlsx files note regular not Data Only excel exports to xlsx still use custom conversion from xls to xlsx This is because Crystal 2011 provides native export to xlsx only for Data Only exports Added Data Visualization functionality La For detail see Data Visualizer or watch a 25 minute video demo Ke Users can now click a new toolbar icon or Ctrl G to launch a Group Swap Expert This new dialog allows changing via drag and drop the fields formulas used to group the report or reordering the groups For example instead of Grouping the report by Country and within Country by City you may Group the report by Product Type and within Product Type by Product For detail see Dynamic Grouping Group Swap Expert or watch video demo Users can now click a new toolbar icon E to launch a Data Grid panel for ad hoc grouping sorting totaling filtering and exporting of the report s data set
88. ng Scheduling Exporting Fully Automated Exporting of Data Visualizations ccs ccesecssesecseeseceseeecesecseesecneesecsaeeecsaecasesecaeesesneseeesaees 60 COMMAND LINE ARGUMENTS FOR TRIGGERING SCHEDULING PRINTING ccccccccccecesecesececeseseceseseseseseseseseeseeeeeseees 61 Specifying Number of opeg kiet ka e en a EE EEEE E a EAE EEE EEE E a E E aE E 61 Setting Custom Text for Each Print Copyn cetie eaea o e eree e e E E Oe N EAA aa EE EESE EE 61 S heduling Provitn E 62 Scheduling Printing for Multiple Reports ees eeeeecsesscseeseceseeeeesecseesecseeeccsaeeeessecaessecseesecsaeeeesaecaeesesneseeeeaees 62 ARGUMENT FOR PRINTER SETUP u ccccccccccccccccscscccscsesesesesescsesesesesesesesesesesesssesesesesesssesesesesesscesscesesssssassusesssssesesuseseaes 62 ARGUMENT FOR DOCUMENTING FILE LOCATIONS AND REPORT PARAMETERS sssssssseseseseserererererererererererererererere 63 LAUNCH A REPORT WHILE VIEWING ANOTHER REPORT seseseeeseeesisesestststststste tetetete tets ts tses es tsesen terete esee es eneses esee ee ee 64 Current Report Path Token sisi ic s sssscesstssstvsstsssescotsesseeszecssueoastavvssssessyessbessbsssacveaesdeassessheasapscabassachasvauss SS aE oin 65 Create a User Interface for Selecting and Launching Report 65 Embed Input from The User in the Command Line Call for Another Reno 66 LAUNCH ANOTHER APPLICATION AND PASS PARAMETERS Tor 67 LAUNCHING REPORTS IN A NEW WINDOW ssesseeesesesesesesesrsrsesest
89. ng all top nodes or manually selecting which nodes to expand SPECIAL DATE AND DATETIME PARAMETER DIALOGS If a user clicks on a single value Date or DateTime parameter DataLink Viewer presents an enhanced date entry selection dialog To quickly select a date double click a date on the calendar Once the calendar is selected Page Up Down changes the month and Ctrl Page Up Down changes the year 4 June 2012 gt 4 July 2012 Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri 28 29 30 31 2 27 28 29 6 7 4 6 13 14 11 13 2 2 18 20 27 28 25 27 4 5 1 2 3 C Today 6 9 2012 L 1 Today 6 9 2012 2 19 01 PM oK _ 2002 2015 Millet Software Page 18 INPUT BOX DIALOG If a user clicks on a single value parameter with less than 2 default values where custom values are allowed DataLink Viewer presents a simple InputBox dialog making it easier and faster for the user to change the parameter value LISTBOX DIALOG If a user clicks on a single value parameter more than 2 default values where custom values are not allowed DataLink Viewer presents a multi row dialog with one row for each default value designed for that parameter This allows the user to quickly change the value for that parameter To quickly select an item the user can simply double click it To quickly locate an item in the list the user can type the first few characters and the list will automatically scroll to the first i
90. now supports specifying Default as the printer name DataLink Viewer can now prompt amp switch the report to a different Data Source when running reports that use UDL files as the OLE DB data source method For detail see Changing Data Source in UDL Files Use_Saved_Data command line argument now overrides the ini file option of Saved Data Action When viewing the report grid the help window triggered by F1 shows that Ctrl Delete removes rows or groups Also Ctrl Delete provides a different confirmation dialog allowing the user to abort depending on whether the selected row is a group header or a detail row 2002 2015 Millet Software Page 109 FIXES When starting DataLink Viewer with a command line argument of ODBC_DSN but no report path or other arguments the ODBC DSN argument now applies to all reports opened during that session rather than just to the first report opened This allows a desktop shortcut for example to launch DataLink Viewer with a DSN target specified for all reports opened during that session HTML Tooltip windows are now automatically closed when you refresh or navigate away from the report preview window When you trigger a report from a command line using a v View Only window you can now use View_Mode NoBarsNoTitle to remove not only the toolbar and status bar but also the title of the window in order to maximize the space available for the report The application now loads faster wh
91. nt Fixed an issue with Oracle_Server command line argument Fixed data refresh issue Also when refreshing without changing parameters the preview returns to the same page if the new preview contains at least that number of pages Logging DLV processing to an ODBC table can now handle database targets with limitations on number of characters in each field in a SQL statement The new mode using bind variables to pass potentially long strings capturing the parameter values and the report SQL is enabled by setting the following entry in the Options section of DataLink_Viewer ini Log ODBC_Type Oracle 2002 2015 Millet Software Page 117 ODBC_DSN_From_To now support multiple pairs separated by Il This addresses use scenarios where a report uses multiple ODBC DSNs e g when the main report DSN is not the same as subreports DSNs Also you may now specify ODBC_DSN_From_To as a global entry in the Options section of DataLink_Viewer ini If you interactively switch between DSNs Integrated Authentication functionality is now available by setting to True a new ini option of Enable_Integrated_Authentication_For_DSN_Changes This is a rare scenario so for more detail contact Millet Software During forced login scenarios Integrated Authentication now automatically sets the Password in the login dialog after the User ID is manually set When the rpt has saved data Preview Report Force Login now always
92. nt on I can refer to that password inside my command line arguments as Encrypted_Password_FTP and DataLink Viewer would make the appropriate substitution If you need to change a previously saved password use the drop down to select the previously saved password name and enter a new password 2002 2015 Millet Software Page 52 Command Line Arguments for Parameter Values Since parameter values can have different data types and structures discrete multi value range mixed this section explains how you can specify parameter values via command lines All arguments must be enclosed in double quotes and separated by a single space A numeric or string parameter would be specified as A date parameter would be specified as DataLink Viewer handles the data type conversion to match the parameter data type The syntax is constructed as the word Parm followed by the number of the parameter according to the order of parameters shown in Crystal followed by a colon and the value Here s how you would specify the 1 and 3 parameter values RANGE AND MULTI VALUE PARAMETERS DataLink Viewer supports all parameter types including multi value range and mixed parameters A multi value discrete parameter value is specified as follows A range parameter in this case a date range is specified as follows The 3 at the end indicates the start and end points are included A 0 at the end would indicate the start and end points a
93. ntegrated authentication run a report and get to a login dialog Note if you already have integrated authentication for yourself use Forced Login Alternatively discard your integrated authentication using the Trash Can button in the Options dialog Make sure you turn on the Remember Me option in the login dialog just like setting up integrated authentication for yourself Step 3 Because of the Enable_Shared_Machine_Authentication TRUE you would get a dialog asking you if you wish to share your integrated authentication functionality with other users who logged in to the same machine This ensures a user can t be tricked into sharing integrated information without their knowledge and expressed consent Click YES If you then open the DataLink_Viewer ini file you would notice this process generated a new entry in bold Integrated_Authentication Enable_Integrated_Authentication TRUE ixm7 SOBPC02 scpocar3psBF3484000123301DD155638EAD4AD6B4D622C04DF125B7404BCBC4717ASDA2FBCD94314A7CE63BBE7357E Enable_Shared_Machine_Authentication TRUE Shared_Machine_Authentication cssscp373pspsappCorE9F379521C7318F A297CBS9SB992C That entry in my particular case points to the ixm7 SOBPC02 integrated authentication entry Notes 1 The Enable_Integrated_Authentication True or False setting is always taken from the user ini file This allows the user to turn it off if they wish For example they may wish to switch between ODBC Data Sources by us
94. ob A strla 990 2 0 Bkes R Us USA 313 6 0 B ke A Holbs Arorymots USA 957 55 Othe rs USA 143 881 27 Rapel Craze 161 854 23 D Gloves 12 166 2 9 Kids 51 696 2 9 Saddles 10 206 2 9 Hybrid 265 533 3 2 You are not limited to 1 drill down path several branches can be expanded at the same time see video demo at http www milletsoftware com Download DLV_InPlace_DrillDown wmv The installation of DataLink Viewer includes a sample report for example DLV_In_Place_Drill_Down_12 rpt if you installed version 12 To learn how to create your own report with this functionality open the sample report and look at the comments and expressions in 1 DLV_Expand_Button_1 and DLV_Expand_Button_2 formulas 2 DLV_Current_Group_1 and DLV_Current_Group_2 formulas 3 DLV_Expanded_Group_List formula 4 Suppress expressions for the sections a GH1b acts as column headers for level 2 and GH2a b GH2b acts as column headers for level 3 and GH3 The same approach can be extended to any number of group levels This functionality is enabled only in the main report view not in Crystal s drill down tabs Note using my CUT Light UFL you can persist to an ini file the information in DLV_Expanded_Group_List so that the report remembers its collapse expanded state 2002 2015 Millet Software Page 39 Converting Section Double Click to In Place Drill Down When you implement In Place Drill Down as discussed above you may
95. oducts rpt Again DataLink Viewer detects that such a report exists and links to that report as the basis for prompting the User However before presenting this report to the user the viewer detects that the Prompt_Products rpt itself is designed with a parameter of its own Prompt_Product_Types rpt What we have here is a hierarchy of links whereby the values selected by the user in response to the Prompt_Product_Types rpt parameter restrict the values available for selection in the Prompt_Products rpt parameter DataLink_Viewer_Year_and_Product_Prompts rpt Parameter 1 Single Value Prompt_Order_Year rpt Parameter 2 Multi Value Prompt_Products rpt Parameter 1 Multi Value Prompt_Product_Types rpt DataLink Viewer always starts from the bottom of the hierarchy for each parameter Hence we are going to be prompted first for Product Types before we select Products within those Product Types 2002 2015 Millet Software Page 24 RESPOND TO MULTI VALUE LIVE PROMPTS DataLink Viewer detects that the parameter called Prompt_Product_Types rpt was designed to accept multiple values and hence it presents you with the linked report Select Product Types to be included in the Report Main Report Product Types Competition Gloves Helmets Hybrid Locks Mountain Saddles All Product Types Delete All Cancel HU Prompt_Product_Types rpt inside a dialog that allows you to click and select mult
96. ogin_ Window ODBC_Groups iXtreme 9liXtreme 1 If iiNorthwind_2IINorthWind_6llXtreme oll Each ODBC Group is enclosed in brackets A single space separates the groups Each ODBC DSN is enclosed in a d delimiter including at the start and end of the group report that by default uses an ODBC DSN that is NOT in any of the specified groups will experience no restrictions in the choice of alternative ODBC DSNs A report that by default uses an ODBC DSN that is in only one of the specified groups will be restricted to a choice among the DSNs of that group A report that by default uses an ODBC DSN that is in more than one of the specified groups will be restricted to a choice among the combined list of DSNs from all these matching groups FORCING LOGIN FOR DSN GROUP MEMBERS In the scenario above where a DSN can be a member of an ODBC Group you probably want to force a login dialog with a restricted DSN list to be displayed so the user can select the desired DSN This is true even if the report can connect to the data source without login information To achieve this behavior set the following entry in the DataLink_Viewer ini to True Options Always_Force_Login_If_In_DSN_Group TRUE In a similar manner if you wish to force a login dialog for all reports regardless of membership in ODBC groups you can set the following entry to True Always_Force_Login TRUE 2002 2015 Millet Software Page 71 Specify the ODBC DSN
97. oors Lycra Glove InFlux Crochet Glove Triumph Pro Helmet Delete All Cancel v While you can click on any field formula to add its text to the selection list it s good practice to use color font and box effects to highlight the column you intend the user to click When you click on a field However S After clicking on some product names move your cursor over these items in the list of selecte Display Values Notice that a popup text reflects the underlying Data Value Product IDs for 2002 2015 Millet Software Page 26 each product You can resize the dynamic parameter dialogs select a zoom level and turn the group tree on or off for each dynamic report DataLink Viewer remembers these settings and will apply them the next time the same dynamic parameter dialog for the same dynamic parameter report is loaded VIEW THE REPORT When you click OK DataLink Viewer uses the selected values for both the Prompt_Year rpt and Prompt_Products rpt parameters to display the requested report DataLink Viewer DLV 12 Sample Report Dynamic Cascading Parameters Select Report Preview Competition 0 Gloves 2D Helmets Product Sales by Type in 2004 Competition 291 560 DLV_Run_Here v Product Type Catalog V12 rpt Parm1 Competition DLV_Run v c Program Files DataLink Viewer 12 Product Type Catalog V12 rpt Parm1 Competition Descent 134 057 18 Mozzie 102 477 22 Endorphin 55 025 87 R
98. open that report without needing access to the database e TTX provides export to Tab Separated Values SCHEDULING EXPORTING Since you can trigger exporting using the Export command line argument you can use the Windows Task Scheduler or any other scheduler application to trigger exporting of the report For detailed instructions on how to use the free windows task scheduler see the section on Scheduling in my Visual CUT User Manual Visual CUT provides much more powerful report scheduling options at www milletsoftware com visualcutManual htm 2002 2015 Millet Software Page 59 FULLY AUTOMATED EXPORTING OF DATA VISUALIZATIONS Imagine you need to schedule a data refresh and export of this data visualization created for a Crystal report inside the DataLink Viewer data visualizer a Sas Ged ov r DO r D Rate by Lead Time Find Joes leed Time 7 Late v dammen Levelof Detail me EIE Attributes E FE eroun H Keel Mon 99 J Eiai e 23 Customer Customer Name 20 To 3 2 Product M F 3 Product Product Class Marking Circle X 70 e e 28 Product Product Name Label IT i Product_Type Product Type Name 60 Toa Caor S 7 Market eil 2 are Sie 3 a ege Diter Color Employee ast E S Wrong E Dodsworth a 40 i A D Levering E TT e e P Suyama LE 30 D i al Discount
99. ow and hit Ctrl Delete The grid information in maintained in a plain text file ReportList txt The other options in the popup menu allow you to launch a report to a new window force a login dialog allowing a choice of a different data source and printing or exporting the report without previewing it When adding a report to the grid DataLink Viewer populates the title and subject columns automatically if it finds that information in the summary information for the report You set that information for the pt file in Crystal under the file Summary Information menu 2002 2015 Millet Software Page 10 Preview Report Window The preview window looks similar to the preview window in Crystal except for a few enhancements DataLink Viewer DLY 12 Sample Report Dynamic Cascading Parameters SEE Select Report Preview gt mw 1 i M AP IN Competition IN Gloves e D Helmets Product Sales by Type in Export Button The export button remembers the last export format and file destination you used for each report If this is the first time you are exporting a report the export format and folder will default to those used in the last export 3 Print Buttons Instead of a single print button DataLink Viewer gives you 1 aregular print button which invokes a printer selection and setup dialog 2 a Quick Print button which immediately sends the report to the default printer or 3 a Print Current Page but
100. r the current month DLV can do this for discrete or range number not currency parameters The supported constants are MONTH_PLUS_N or MONTH_MINUS_N YEAR_PLUS_N or YEAR MINUS_N YEAR_AT_PLUS_MONTHS_N or YEAR_AT_MINUS_MONTHS_N YearMonth_AT_PLUS_MONTHS_N or YearMonth_AT_MINUS_MONTHS_N e eleng Where N is the number of months years to be added subtracted from the current month year For example if the current date is January 6 2005 then Month_Plus_0 1 Month_Minus_1 12 Year_Plus_0 2005 Year_Minus_2 2003 Year_AT_Minus_Months_1 2004 YearMonth_AT_MINUS_MONTHS_3 200410 year 2004 and month 10 You can specify a Number constant as the parameter value in a command line invocation of DataLink Viewer For example Benefits these constants allow you to use the same report interactively as well as in scheduled mode This can also lead to faster report execution since using formulas within the report can force record selection to be performed by Crystal instead of by the DBMS 2002 2015 Millet Software Page 57 Argument for Using Saved Data In cases where another process for example Visual CUT generates the rpt file with saved data you can launch a report and include a Use_Saved_Data True command line argument to indicate the saved data should be used instead of retrieving the data from the database Specifying Parameters When Using Saved Data Some parameters don t participate in data selection Such Non
101. re NOT included A 2 at the end would indicate the start point is included and the end point is not A 1 at the end would indicate the start point is not included and the end point is Add 4 to these values if there is no Upper Bound Add 8 to these values if there is no Lower Bound For example this would indicate all dates up to and including 7 15 2003 The 12 00 00 AM value is just a place holder Any date value would work will be ignored 2002 2015 Millet Software Page 53 OPTIONAL PARAMETERS WITH NO VALUE To specify no value for an optional parameter provide a blank value e g Parm2 HasValue function within the Crystal report would then return False as if the user didn t specify any value for the optional parameter NULL VALUES Null parameter values for stored procedures are specified in command lines by using the constant VC_NULL For example to specify that the first parameter value is null use Parm1 VC_NULL IGNORING SAVED PARAMETER VALUES In order to ignore saved parameter values use the following command line argument Tgnore_Saved_Parameter_Values ALL The user would then get prompted for unspecified parameter values skipping the saved parameter values dialog 2002 2015 Millet Software Page 54 DATE CONSTANTS When triggering viewing printing or exporting via a command line for a report that has Date or DateTime parameters you can set the parameter to dates relative to the cur
102. rent date DLV can do this for discrete or range date parameters The supported constants are 1 TODAY or YESTERDAY 2 TODAY PLUS Nor TODAY_MINUS_N or TODAY_MINUS_N_MINUS_M or TODAY_MINUS_N_MINUS_M_EOM or TODAY_MINUS_N_MINUS_M_SOM START_MONTH_PLUS_M or START_MONTH_MINUS_M END_MONTH_PLUS_M or END_MONTH_MINUS_M Top START_YEAR_PLUS_Y or START_YEAR_MINUS_Y END_YEAR_PLUS_Y or END_YEAR_MINUS_Y Nth_N_PLUS_M or Nth_N_MINUS_M LAST_MM_DD or NEXT_MM_DD Sch ON 9 Now_Plus_S or Now_Minus_S Where N days M Months Y Years and S seconds to be added or subtracted For example if the current date is March 6 2004 then Today 3 6 04 Nth_16_MINUS_1 2 16 04 the 16 of the previous month Today_Minus_3 3 3 04 Last_04_01 April 1 2003 End_Month_Plus_0 3 31 04 End_Month_Minus_1 2 29 04 Start_Year_Plus_0 1 1 04 Start_Year_Minus_1 gt gt gt Today gt gt gt 3 Inclusive range of 1 1 03 to 3 6 04 In the case of Today_Minus_N_Minus_M N is the Days and M is the Months so Today_Minus_1_Minus_2 1 5 2004 one day and two months earlier Adding _EOM or _SOM to the end of a Today_Minus_N_Minus_M constant returns the End of Month or Start of Month so Today_Minus_1_Minus_2_SOM 1 1 2004 Start of Month for 1 5 2004 Today_Minus_1_Minus_2_EOM 1 31 2004 End of Month for 1 5 2004 For DateTime parameters Now_Plus_S or Now_Minus_S returns the current datetime adjuste
103. rmula value e Click to prompt for and pass a value to another process 15 Selective Parameter Refresh When refreshing a report users can select which parameters they wish to change This avoids tedious re entering of values for the other parameters The parameter refresh choices are stored for each report and can be easily reused or changed at a later session 16 Integrated Authentication use Windows User Login and Machine ID to remove the need to repeatedly authenticate to data sources 17 Reduced Memory Requirements compared to Crystal and other viewers 18 Select Different Data Sources for the same Report 2002 2015 Millet Software Page 7 Install Remove The exe file you downloaded self extracts to 2 files a setup exe and an msi file First it will prompt you to provide a password DataLink Viewer 2011 Self Extracting Installer L ZS m a a Ee This self extracting EXE is encrypted Enter a password to unzip Ir Cancel It automatically triggers the setup exe to check for and download install any missing prerequisites such as the NET framework and the Crystal 2011 runtime components It then triggers the msi install of DataLink Viewer itself DataLink Viewer 2011 is installed under the Program Files Millet Software Avoid Installation on a Crystal Enterprise Machine Due to the risk of rare runtime component conflicts you should avoid installing the software on a machine that also runs Crystal Enterprise
104. rt D l 75 e 1 of Preview Product Types Competition All Product Types AN Product Types lt All Product Types Delete Delete All Cancel This was implemented by adding a formula to the report footer with a static text value of All Product Types The desired effect is obtained by specifying the following record selection criterion in Prompt_Products rpt Product_Type Product Type Name in Prompt_Product_Types rpt all Produc Types in 2Prompt Product Fern 2002 2015 Millet Software Page 29 SHARING VALUES ACROSS CASCADING PARAMETERS Parameter values are automatically reused if the same Parameter name is used more than once in the chain of cascading parameters The diagram below shows a situation where Prompt_Order_Year rpt is used to first ask the user to specify which orders should be shown in the report That same parameter is then also used to limit the dynamic list of products Prompt_Products rpt such that only products that actually sold in that year are available for selection DataLink Viewer now reuses the year specified by the user the first time Prompt_Order_Year rpt is invoked to avoid asking the user the same question twice DataLink_Viewer_Year_and_Product_Prompts rpt Parameter 1 Single Value Prompt_Order_Year rpt Parameter 2 Multi Value Prompt_Products rpt Parameter 1 Multi Value Prompt_Product_Types rpt Parameter 2 Single Value Prompt_Order_Year rpt
105. run the report against a different database DataLink Viewer supports selection of anew ODBC data source even when the database name is different from that used in the original ODBC DSN To ensure this works even when the table names in your report are fully qualified set the following line under the Options section in DataLink_Viewer ini to True Strip_Table_Qualifiers True 2002 2015 Millet Software Page 74 Overriding the Server in Native Oracle Connection When a report uses a native connection to Oracle you can edit the Server name in the login dialog and run the report against a different server rather than the one the report was designed against Alternatively if you are launching a report from a command line you can override the Oracle server name by using the Oracle_Server command line argument For example C Program Files Millet Software DataLink Viewer 2011 DataLink_Viewer_2011 exe v C temp test rpt user_id dba password sql Oracle_Server Server2 Note This functionality is not available in the Crystal 8 5 version of DataLink Viewer Selecting an Alternative SQL Server OLE DB Data Source wom The parameters after the are separated by a gt gt and are as follows 1 DataSource is the Server Name the report should connect to 2 InitialCatalog is the Database Name within the given server 3 Integrated_Auth is a True or False argument indicating if Microsoft SQL Server Integrated
106. rypted and can be used only if the specified Windows User ID manages to log into the specified Windows Machine Name Automated setting of Integrated Authentication information can be particularly useful for Citrix or TS server farms Such deployments allow each user to launch DataLink Viewer on the least busy machine within the server farm Any changes made to the DataLink_Viewer ini file in the user s Home folder are automatically replicated to the other machines participating in the server farm However integrated authentication information is stored encrypted per user amp machine combination So as an administrator when you add a user to the server farm you may need to generate Integrated Authentication entries for that user amp all machines in the server farm Multiple ini file entries for the same user amp different machines look like this Integrated_Authentication User33 Server101 148580D7008FB47042E07958BB8884A7BAD32B2B7C268A6 User33 Server102 0AA0F62E3F8091CD90AD9D87F4F5279102439D2432134BF725 To facilitate the automated generation of such entries you can call DataLink Viewer using a command line all in 1 line argument as follows C Program Files DataLink Viewer 11 DataLink_Viewer_11 exe Integrated_Authentication_Set_Entry nn H DataLink_Viewer ini gt gt Server1011 Server102 gt gt User33 gt gt joe3 gt gt sesame gt gt After the Integrated_Authentication_Set_Entry key word and the colon the
107. s 3 possible values ViewMode NoStatusBar only the status bar at the bottom of the window is removed ViewMode NoToolBar only the toolbar at the top of the window is removed ViewMode NoBars both the toolbar and the status bar are removed ViewMode NoBarsNoTitle toolbar status bar and window title are all removed A typical scenario for using this option is in combination with the Auto_Refresh command line argument For example C Program Files Millet Software DataLink Viewer 201 1 DataLink_Viewer_2011 exe v C temp Report rpt Auto_Refresh 300 ViewMode NoBars 2002 2015 Millet Software Page 34 Cycling Through Several Auto Refreshed Reports Assume you want your monitor to cycle through 2 different auto refreshed reports every 15 seconds You can take advantage of the fact that as a report gets auto refreshed its window becomes the active one So you can trigger auto refresh every 30 seconds for both reports but separate the start times by 15 seconds Here s how you can automate the whole process Step 1 Use notepad to create a batch file that can be called from within another batch file to delay processing by a given number of second Call it WAIT bat if you d like to understand the logic see http malektips com dos0017 html ping 127 0 0 1 n 2 w 1000 gt nul ping 127 0 0 1 n 1 w 1000 gt nul Step 2 Use notepad to create the following text file Call it invis vbs
108. s candidates for change of grouping 3 If you try to invoke the Group Swap expert for a report grouped on a field formula that is not on the report layout you get a detailed message box like this Grouping Field Formula Not On a J i please place the following grouping field formula HZCTRFIL_SQL alt_wc on the report layout Note the field formula section may be suppressed CR To enable the Group Swap Expert for this report 4 To make a field formula participate in this dialog it must be placed on the report layout Its name must not end with NOK an indication it s Not OK to include it If the field formula is suppressed or is placed in a suppressed section it gets loaded into the list of candidate Fields Formulas only if it s name ends with OK This approach is designed to avoid exposing suppressed information 5 Conditional formatting formulas using group summaries are not adjusted 6 Groups sorted Descending by total field may become sorted Ascending To avoid that behavior use a TopN sort with a large N instead 7 You may disable this functionality by adding this to the master DataLink_Viewer ini Options Disable Group Swap True Optional Technique for Gaining Formula Access to the Dynamic Grouping If the report contains formulas names as DLV_Group_L1 DLV_Group_L2 etc DataLink Viewer will set the expression of each of these formulas to return the grouping Field Formula at that level a
109. s into report parameters this functionality allows report developers to distribute rpz files and restrict their use to only those where a license code matches the company to which Windows is registered DLV_HD_SERIAL_N If a report has a single value string parameter called DLV_HD_Serial_N DataLink Viewer automatically sets the value of such a parameter to the serial number of the current hard drive In conjunction with the ability to load ini values into report parameters this functionality allows report developers to distribute rpz files and restrict their use to only those where a license code matches the machine on which the report is running DLV_RpT_PATH If a report has a single value string parameter called DLV_Rpt_Path DataLink Viewer automatically sets the value of such a parameter to the path to the rpt or rpz file This is particularly useful in the case of rpz files 2002 2015 Millet Software Page 21 Control Data Access according to PC Login Assume you have several Sales Reps who need access only to their own sales information DataLink Viewer can limit the data shown in a report according to who is logged in to the PC To achieve this functionality you need two elements 1 The report must have a String parameter named DLV_User_ID as shown below DataLink Viewer automatically sets the value of such a parameter to the User ID who is currently logged in to the PC Field Explorer SSlasz X t se Database
110. shows a login dialog even if the default action for saved data is to simply display it Fixed a problem with Printer command line argument Online Version Update functionality was removed due to the component Update exe being mistakenly flagged by virus protection software When using the Options dialog to change the default location of ReportList txt if the target folder already contains a ReportList txt file the user can now elect to load that file into the grid or upon exiting DataLink Viewer overwrite the content of the file with the list of reports currently loaded into the grid Document2ini command line argument now allows calling DataLink Viewer 2011 from another application and requesting that documentation about key file DataLink_Viewer ini ReportList txt location as well as report parameters be written to a specified ini file Added XML_Path_From_To command line argument allowing users to override the stored path to XML files as data source for the report Database_Path_Selection can now be specified via a command line argument Database_Path_Selection can now be used for Paradox data sources by specifying just the path not including the DB file name For example using a command line argument such as Database Path Selection C Old gt gt c New e Fixed an issue with Database_Path_Selection when used to change the location of Excel files as a data source Fixed in place drill
111. so called UTC or Zulu Time Proc_End_GMIT Text Processing End DateTime in Greenwich Mean Time GMT also called UTC or Zulu Time Windows User_ID Text The Windows User ID running the process Machine_ID Text The Windows machine running the process Parameter_Values Memo Param_Name Param_ Value s subreport Name gt Param_Name Param_ Value s Connection _Properties Memo Delimited List of Connection Property Names amp their Values not including passwords Report SOL Memo The SQL Query for the main report Live_Data_1_0 Number lif user retrieved data from Database 0 if saved data inthe report was used Records Read_N Number Number of Records Read into the Main_Report Export_Activity_1_0 Number 1 es or 0 False Print_Activity_1_0 Number 2002 2015 Millet Software Page 89 SQL SERVER DATA STRUCTURE Here is a script for creating the table in Microsoft SQL Server CREATE TABLE dbo DLV_Log LogN int IDENTITY 1 1 NOT FOR REPLICATION NOT NULL Rpt_Path nvarchar 255 COLLATE SQL_Latin1_General_CP1_CI_AS NULL Rpt_Name nvarchar 255 COLLATE SQL_Latin1_General_CP1_CI_AS NULL Proc_Start_Local nvarchar 255 COLLATE SQL_Latin1_General_CP1_CI_AS NULL Proc_End_Local nvarchar 255 COLLATE SQL_Latin1l_General_CP1_CI_AS NULL Proc_Start_GMT nvarchar 255 COLLATE SQL_Latin1_General_CP1_CI_AS NULL Proc_End_GMT nvarchar 255 COLLATE SQL_Latin1_General_CP1_CI_AS NULL Windows_User_ID nvarchar 255 C
112. ssseasonssonsssnsssssoes 15 REMEMBER PARAMETER VALUES FROM A PREVIOUS bESsION 15 SELECTIVE PARAMETER REFRESH 3 lt sscsscsseecesgacsscavsesue cas saciscaevacse EEEE Er EEEE AEE har TEE ENTE ER erie rerai ee 15 SAVE AND REUSE NAMED PARAMETER ETS 16 CLICK TO CHANGE A PARAMETER VALUE krne a e a N e a a a aer EE ar e teere EaR Ete 18 Toggling Between 2 Parameter Values ode EEEEEEEENEE EE EEEEEEEE AEN EEEEEEEEEEEEEER ENEE EEENEEEE EES NEE 18 Special Date and DateTime Parameter Dialoge 18 Input Box alogge geseet nek e ee ati BE ite ad ie dovetail ao 19 ListBox Dial g aces renens hah oe wena ee 19 Changing a Parameter by Clicking on a Related Formula 19 LOAD INI VALUES INTO PARAMETERS eraren ni r a e a Ea ER E E EaR 20 SECURING REPORTS AGAINST UNAUTHORIZED Up 20 LOAD MACHINE COMPANY REPORT INFORMATION INTO PARAMETERS n sssssssssseesseeeerteesereessrreessreerereessrreessrreesse 21 DEN Machine Name seco vs csdsccgececs evista a a a OR 21 DLV Registered Oppasse EE Ee EE ee Heese eet wees 21 RI ER Serial KEE 21 DEV Rpt EE 21 CONTROL DATA ACCESS ACCORDING TO PC Loom 22 DYNAMIC amp CASCADING PARAMETERS sssssssssseessesetssttttetttttttt etste ettr tetett tS tte Sssttt tette EEEE ESSE EEES Sre essees sereen stees se teenet 23 Respond to Single Value Live Prompts ceescsseccssseecssecseesecseesecneesecsaeeeesecsessecsevsecsaeeecsaecasssesaeesesnesseeeaees 23 Link back in a Hierarchy of Live Prompts ccesccssecsseeseeesees
113. ssssscescsesesssssssccnsssesecssssesecnsssesesnsssesesnessesesnessesees 49 LAUNCH REPORTS FROM FILE EXPLORER siipi e eonenna eaaa r n a e A e a i a ss 49 LAUNCH REPORTS FROM COMMANDLINES 50 SAMSTEN EEN 50 CALL DATALINK VIEWER FROM ANOTHER APPLICATION esesesesesesseeetesstesseesstteteretesttssttestesstessresteseeseteseessrsst 31 REFERRING TO SAVED ENCRYPTED PASSWORDS sseeesseseeesesssseressrsessesttsettestesstessessstessesteesetssteestosttessesseesreeseteseeeee 52 COMMAND LINE ARGUMENTS FOR PARAMETER NALUES 53 Range and Multi Valute Parameters 0 cceesesssccsessecesesecseceeesecseesecneesecsaeeeesaecaeesecsevseenaeeecsaecessaecaeeseeneseenaees 53 Optional Parameters with NO Malte egeeg atin eed Apts SAL eee Mt ee ea ee Sheree 54 TIET 54 Isnorng Saved Parameter EE 54 RECHNEN Ee CT 55 Number Constanits need of dgcceestycccagscvadecs succes sy dee dE del dE degt E EEE deed e NEE Se deed ENER odes 57 ARGUMENT FOR USING SAVED DATA oniiir ea a AEE ETE A Aea E aE ES 58 SPECIFYING PARAMETERS WHEN USING SAVED DATA 58 2002 2015 Millet Software Page 3 ARGUMENT FOR SETTING FORMULA EXPRESSIONS sseseseseseseseseseserererererirertrtttrtrttttttttttttttttttt rererere rerererererererererere 58 COMMAND LINE ARGUMENTS FOR TRIGGERING SCHEDULING EXPORTING ccccccccecesecesecesecececesesesesesesseeeseseeseuees 59 Tate ractr ve WSS asic E E E eas E A vaes ae ba E E ce cegsepeeeasoee ce A E E E Fully Automated Exporti
114. st information about report parameter gets added to the ini file providing summary info as well as dedicated section for each parameter based on its position in the report Parameters c temp test rpt 11I City llStringllFalsellFalse 2Il Country IStringllFalsellFalse 1 Name City InUse True Type String PromptText Enter City Single Value False Range Value False AllowEditing False Optional False 2 Name Country InUse True Type String PromptText Enter Country Single Value False Range Value False AllowEditing False Optional False 2002 2015 Millet Software Page 63 Launch a Report while Viewing another Report DataLink Viewer allows you to view a report and launch another report into its own Viewer window or in the current Preview tab by double clicking a report section containing a string formula specifying the report to launch parameter values and even User ID and Password The general structure of the String formula no naming restrictions is 1 DLV_Run vy launch specified report in a new Preview Only window or DLV_Run s launch specified report in a new full DataLink Viewer window or DLV_Run_Here s launch the second report within the current Preview Tab 2 the report path and file name 3 Optional command line arguments parameter values login information etc as discussed in the Launch Reports from Command Lines section of this user manual Notes The User ID amp Passwor
115. taLink Viewer user interface INTERACTIVE USE If you want the user to be prompted for the export format and file name the syntax is constructed as the word Export followed by a colon and the word Dialog For example C Program Files Millet Software DataLink Viewer 201 1 DataLink_Viewer_2011 exe v C temp Report rpt user_id dba password sql Parm1 Gloves Export Dialog FULLY AUTOMATED EXPORTING If you want to export the report with no user interaction you can specify Default in the command line argument to use the export format and file name last used for the report when a user clicked on the Export button from the GUI For example C Program Files Millet Software DataLink Viewer 201 1 DataLink_Viewer_2011 exe v C temp Report rpt user_id dba password sql Parm1 Gloves Export Default Alternatively you can specify the export file name and export format like this C Program Files Millet Software DataLink Viewer 201 1 DataLink_Viewer_2011 exe v C temp Report rpt user_id dba password sql Parm1 Gloves Export e temp Labels pdfl BDR Note that the export file name and export formats are separated by Valid export formats include XLS XLSX XLS Data Only XLSX Data Only PDF CSV HTML 32 HTML 40 TTX DOC DOC Editable RTF TXT XML RPZ RPTR and RPT Notes e RPT exports the report to a Crystal Report format with saved data A user can then
116. ted by gt gt as a delimiter 1 The path amp name of the ini file 2 The ini section name typically Options 3 The Password Name 4 The Password to be Encrypted 2002 2015 Millet Software Page 106 Known Issues and Limitation The preview window doesn t provide a Select Expert option That option is not available in the new runtime components Export types are only to disk If you wish to email a report first export it and then use your regular email client to email the resulting file While this approach may take a few more seconds it also gives you more control over the attachment names and email options Note if you need direct export to email capabilities you can use DataLink Viewer XI R2 or Visual CUT Linked Dynamic Parameters applies only to the special DataLink Viewer linked dynamic parameter reports not to the regular Crystal Reports dynamic parameters Data value in linked dynamic parameter reports is set via the tooltip property instead of via a different formula This is not a limitation but users of prior versions should be aware of this change It requires a change in linked parameter reports design if you wish to reuse old reports Footer formula can t be used to control the default value in a linked dynamic parameter reports Similarly a footer formula can t be used to require a value for a linked dynamic parameter report Exports to pdf may result in smaller font size This is a Crystal
117. tem starting with these characters To quickly select an item the user can simply double click it ES Product Class Accessory CHANGING A PARAMETER BY CLICKING ON A RELATED FORMULA In some cases you may wish to invoke a parameter change by clicking on a related formula For example you may wish to embed the parameter inside some text or perhaps the parameter may have an empty value making it impossible to click on the parameter object by itself To use a formula as a proxy for clicking on a parameter the formula name must start with DLV_Param_Click followed by the parameter name you wish to change when a user clicks on that formula For example DLV_Param_Click Customers The formula itself may display any values you wish For example you may concatenate static text with the parameter value or you may wish to return No Value if the parameter value is null and a nicely formatted value if the parameter is not null 2002 2015 Millet Software Page 19 Load ini Values into Parameters Specially named parameters get loaded automatically from DataLink_Viewer ini file entries For example you may use this with parameters that change only once per quarter Another case could be a situation where you develop and sell reports probably pt files converted to rpz files to clients in a vertical market These reports are designed to work against a known database structure but each client may need to customize the reports
118. that machine to have their own ini file c User s Roaming App Data folder that location allows each user to have the same ini file follow them to other machines If DataLink_Viewer ini was not found in any of the 3 locations above which is typical in 1 time installation scenarios DataLink Viewer will copy it as well as ReportList txt from the application folder to the Common App Data folder and notify the user that the redirect has occurred The location of ReportList txt would also be set to the same redirected location Notes an ini file that was redirected to one of the locations above due to a write protected application folder is considered a Master ini file As usual that Master ini file can be redirected further to a slave ini file by manually setting its ini_file location option under File_Locations A blank option for ReportList txt location in a redirected ini file is considered as an indication that the ReportList txt file should be automatically copied to if missing and used at that location 2002 2015 Millet Software Page 99 CHECKING AND NAVIGATING TO KEY FILE LOCATIONS To check the locations of DataLink_Viewer ini and ReportList txt you can click on the Version Information amp Updates button The textbox at the bottom of the dialog shows the current file locations DataLink Viewer 2011 Version 6 2 2044 www MilletSoftware com e 2002 Millet Software E mail ido MilletSoftware com System
119. the Delta ini file is deleted o NEVER the file will not be deleted o USE the file is deleted after being used once o yyyyMMdd the file is deleted after the specified date e Update_Master_INI controls whether the Master ini file is updated e Update_Slave_INI controls whether the User ini file is updated 2002 2015 Millet Software Page 104 Explicit Assignment of Default Printer To address a rare printing failure scenario under Citrix and Windows 2003 the following Datalink_Viewer ini option allows an explicit assignment of the default printer when the user clicks the print button before the printer selection dialog is displayed Options Set Report To Default Printer TRUE 2002 2015 Millet Software Page 105 Setting Encrypted Password Entries The Encrypted_Password_Set_Entry command line argument can automate encrypted storage within DataLink_Viewer ini of passwords This allows an administrator to set or change encrypted passwords for DataLink Viewer or Visual CUT that can later be referenced from command line arguments To generate such entries in a targeted ini file you call DataLink Viewer using a command line all in 1 line argument as follows C Program Files DataLink Viewer 11 DataLink_Viewer_11 exe Encrypted_Password_Set_Entry H DataLink_Viewer ini gt gt Options gt gt Encrypted_Password_FTP gt gt sesame After the Encrypted_Password_Set_Entry key word and the colon the 4 arguments are separa
120. the clipboard In Crystal the tooltip can be set via a dynamic expression Use Scenario Imagine you have Customer Support Representatives CSRs who use Crystal reports to view order history information for calling customers Frequently these CSRs need to grab order history information for a specific order within the report and email that information to the customer You don t want to display all that history information inside a single field on the report because of formatting and space utilization considerations But you can accumulate that content using Crystal formula logic into the tooltip expression for a field or a formula After selecting that field or formula the CSR can simply hit Ctrl Shift C to copy the content of the tooltip They can then paste it to an email message using Ctrl V 2002 2015 Millet Software Page 14 Parameter Functionality Remember Parameter Values from a previous Session Video Demo If you refresh or reload the same report the values you specified last time for each parameter are already selected allowing you to accept or replace them Selective Parameter Refresh Video Demo When refreshing a report that has parameters a special dialog allows users to select which parameters they wish to change These choices are stored for each report for reuse change at a later session Unlinked subreport parameters participate in this process and are listed as subreport name gt Parameter Name
121. tion and to the Options dialog For certain databases scenarios this avoids database connection failure when refreshing a report You can now change folder location for ACT pad data source files See Changing Folder Location for Access Excel Pervasive Paradox ACT Files 2002 2015 Millet Software Page 112 FIXES When auto refreshing a decrementing progress bar at the bottom of the page reflects the of the refresh interval remaining until the next refresh A click on that progress bar pauses resumes the auto refresh process If a user is on a drill down tab auto refresh is placed on hold When the user closes the drill down tab or moves back to the main report tab auto refresh resumes Added Auto_Refresh_Use_Saved_Data command line argument This allows multiple users to quickly auto refresh a report and reload its saved data which is refreshed in the background through a scheduled export to a Crystal rpt format You may specify parameter values as command line arguments in such a scenario if those parameters are not involved in fetching data Added a user manual section about the Use_Saved_Data command line arguments ODBC DSN choice grid now also shows DSN Descriptions Added the option Always_Force_Login_If_In_DSN_Group to force selection of data sources In such a case if the data source uses Integrated Security NT Authentication for SQL Server then the login dialog displays only the ODBC DSN choice grid and allows s
122. tomatically assigns a web link to lines that contain only a url ia About DataLink viewer x DataLink Viewer SS Version 3 5601 90 Copyright 2002 Millet Software waw MilletSoftware com By Ido Millet www acme com For Technical Support contact Jane Doe Jane_Doe acme com 888 1234 4567 System Info 2002 2015 Millet Software Page 98 File Location amp Redirect Logic Each time DataLink Viewer loads the location of the Master DataLink_Viewer ini is redirected by following these steps 1 If the ini file in the application folder has a value specified for ini_file in the File_Locations section that location is used for the DataLink_Viewer ini note this allows an administrator who has write permissions on the application folder to manually set the location More typically the value in step 1 would be found as blank DataLink Viewer then determines if a redirect is needed by testing to see if a ReportList grd doesn t exists in the application folder or b user doesn t have write permissions to DataLink_Viewer ini in the application folder If a redirect is needed the application tries to locate and use DataLink_Viewer ini in one of the following app data folder locations under a MilletSoftware DLV_2011 folder a Common App Data folder that location allows all users on that local machine to share the same ini file b User s Local App Data folder that location allows each user on
123. ton which immediately prints just the current page to the default printer Refresh Button DataLink Viewer allows you to auto refresh a report every N seconds and to selectively change the values of only some parameters Refresh Report Data C Use current parameter values Refresh Every Seconds Prompt for new parameter values Cancel Change Parameter Current Yalue O Name Ido Millet IT min_quantity 2 4 Month Ga 2002 2015 Millet Software Page 11 Interactive Parameter Button Just like in Crystal the interactive parameter panel allows you to change parameter values without refreshing the whole report DataLink Viewe 2002 2015 Millet Software Page 12 REPORT GRID HELP If you hit F1 or Ctrl F1 while on the Select Reports tab the following Help window displays o Click Column Header to Sort o Right Click Column Header for Options menu o Drag Column Header to Grouping Area to group the grid o Right click Top Left Corner for Column Selection and Grid Style o Right click Row for Options menu o Right click Group Area for Options menu o Ctrl F to Find text in grid REPORT PREVIEW HELP If you hit F1 or Ctrl F1 while on the report Preview tab the following Help window displays F5 Refresh Ctrl F5 Refresh with Same Parameter Values Ctrl C Copy Text of Clicked Field Ctrl Shift C Copy Tooltip Text of Clicked Field Ctrl F Find Text Ctrl G Group Swap Ctrl P Print
124. ty issue or as a tech support issue They can simply keep the rpt files and distribute only the rpz files to their users Note rpz files should not be renamed Within DataLink Viewer amp Visual CUT rpz files behave just like rpt files except that in order to protect the report design exporting rpz files to rpt format is not possible Note DataLink Viewer provides a special export format of Protected Report rpz This allows users to export the report with saved data to another rpz file 2002 2015 Millet Software Page 83 Make_Rpz Command Line Argument If you need to automate the conversion of rpt files to rpz files using scheduled or automated processes DataLink Viewer provides a command line API Your command line call should look like this all in one line C Program Files Millet Software DataLink Viewer 2011 DataLink_Viewer_2011 exe Make_RPZ gt After the Make_RPZ key word and the colon the arguments are separated by gt as a delimiter The three arguments are 1 The path to the rpt file s to be converted you may specify wild cards as demonstrated in the example above you may specify multiple paths separated by a semi colon For example Make_RPZ e rptFolderl rpt c rptFolder2 rpt gt e rpzFolder gt 120 The target folder where the rpz files should be deposited The maximum age in minutes of the rpt file in order to be included Older files would be skipped This allo
125. uns The user choice will be added after the and will become the new default value in the path selection dialog If the report uses a database file that can t be found on the machine DataLink Viewer prompts the user to select a valid location creates the Database_Path_Selection section if it doesn t already exist and creates adds the pair information to the Paths entry These options are designed to address typical deployment scenarios when a report developer sells reports to users who may have their data source location at a different folder than the one used when the reports were developed USING COMMAND LINE ARGUMENT TO AVOID PATH PROMPT By default pairs with two question marks before the new default path old_path gt gt new_path cause a prompt each time the old path is encountered in a report You may wish to avoid such repeated prompts when launching one report from within another report or when scheduling printing The following command line argument will cause DataLink Viewer to ignore the two question marks and simply use the new_path 2002 2015 Millet Software Page 78 Changing Data Source in UDL Files Crystal reports can use text files with udl Universal Data Link extension as the source for OLE DB connection information If you need to override the Data Source property stored in the UDL file you can use the following section in DataLink_Viewer ini OD Data Source Targets CAMBISLLC YOATCO NESTOR
126. wal Discourt Sie ka de e See eene zi i gall Cust_Qs Se _ al Lead_Time lt Competition gt 10 mi Revenue 8 ml Orders_Detail Quantity deb sk S e yy ON ml Values Q D i 0 1 2 3 4 5 6 7 8 Lead_Time You can use a command line argument to specify the and C Program Files Millet Software DataLink Viewer 201 1 DataLink_Viewer_2011 exe v C temp Report rpt Export _ Viz PAJALA Dy bead Timelle temp Viz7 png 7 Competition Color Employ The resulting png file gt E Dodsworth E Leverling E Suyama Note Valid export file Ss extensions are png H Peacock jpeg and bmp Using Visual CUT you can use a batch file to first export to an image file from DLV 2011 and Late then 2002 2015 Millet Software Page 60 Command Line Arguments for Triggering Scheduling Printing Using the Printer command line argument you can trigger printing for a given report in an unattended mode the user doesn t need to preview the report or see the DataLink Viewer user interface The syntax is constructed as the word Printer followed by a colon and the word Default if the report should be sent to the default printer or the word Dialog if the user should be prompted to select a printer or the printer name if the report should be sent to a specific printer Here s how you would send a report to the default pr
127. wish to allow the user to trigger this behavior by double clicking anywhere in the section rather than just by clicking the DLV_Expand_Button_N formula placed in that section To override the default double click behavior in Crystal drill down to a new tab and divert the double click action to an In Place Drill Down simply use all Upper Case when naming the button formula for example instead of DLV_Expand_Button_1 use DLV_EXPAND_BUTTON_1 Note Verify that if you move the mouse cursor over the formula placed in the report section the correct upper lower case is shown If you already created the formula and you wish to change it to upper case you may need to propagate that change to the actual formula object in the report section by copying the formula Ctrl drag and then deleting the old clone Note 2 if only the 2 click on the button is recognized you can correct that problem using the same procedure as above copy the button formula using Ctrl drag and then delete the old clone Hiding the 7 Buttons If you use an upper case formula name for any of your DLV_Expand_Button_N formulas you can hide the formula by using the section background color as the font color This would allow you to use double clicks exclusively for In Place Drill Down actions the user will not see the ir Buttons 2002 2015 Millet Software Page 40 Dynamic Grouping Group Swap Expert
128. ws the command line to be placed in a batch file and scheduled while avoiding the conversion of older files that have already been converted Use a value of zero to convert all files regardless of age 2002 2015 Millet Software Page 84 Create rpz Files with Expiration and License Keys You can apply expiration date and or license keys to rpz files by setting the following entry in the DataLink_Viewer ini file Options Enable Advanced RPZ Options True When that option is enabled the dialog you get when clicking on the Compress amp Encrypt Rpt to Rpz button looks like this jon and license key options c temp Cust_Report rpt CATEMP Replenishment Report rpt C Users ixm7 SOBHWP0397 1 Documents Crystal Reports test1 rpt Include Sub Folders with WildCard Expressions Destination Folder for rpz File s c Mtemp rpz 7 Expire rpz on 7 Enable License Key Options 6 29 2010 v Our Code 42345678 ini Entry Name illetSoftware_License_Key How to Contact Us rpz File License Info contact us at www MilletSoftware com 814 825 6009 ido MilletSoftware com ask for Ido or Genevieve 4 Generate License Key with Options as Shown Above Client Company Name as per Windows Acme o the Client and instruct them to D67C538 1DOECB2AASBECSCABFDC730FECA2 4C388ASSA0CED14 pz that you crested with CAASBOE4BE82C2A6182D390D0680F842DDA367611B9D148AF8 EE BC13F55495C25CF9E065A0D9926C2D2A98
129. y number of secure data sources in the main report as well as the subreports Here is what the login dialog looks like Server Database User ID Remember Me Select Alternative ODBC Data Sources for the Same Report When running reports that use ODBC data sources you can select which ODBC data source should be used Clicking a button to the right of the Server name expands the display to include a listing of all available ODBC data sources grouped by ODBC driver type The original ODBC data source is initially selected and the driver group it belongs to is expanded and prefixed with a Server CUT_Customers E sample dd og JL ges Jr Select Server ODBC Data Description Database User ID ixm7 Password l Xtreme Sample Database Sample Database 11 To force the list of ODBC DSNs to display by default set the following option in the DataLink_Viewer ini Options Display_DSN_List_in_ODBC_Login True 2002 2015 Millet Software Page 70 Restricting the List of ODBC DSN Choices The default ODBC DSN used by a report may belong to what you may consider to be a group of alternative ODBC DSNs You may wish to restrict the list of ODBC DSNs options shown for such a report to only those that belong to that group This can be accomplished by specifying an ODBC_Groups entry under a Login_Window section in the DataLink_Viewer ini file Here is an example of such an entry L
130. you have multiple database with the same structure You create several ODBC DSNs and can control via a command line which database is used C Program Files Millet Software DataLink Viewer 2011 DataLink_Viewer_2011 exe v C temp MyReport rpt ODBC_DSN Company1 2002 2015 Millet Software Page 50 Call DataLink Viewer from Another Application 4 Here s a code example of invoking DLV from a visual basic application with only a Preview tab no Select Report tab and specifying a parameter value Note that double quotes are escaped by using instead of Dim RetVal Les Cemp C Program Files Millet Software DataLink Viewer 2011 DataLink_Viewer_2011 exe amp v c temp Lab2 Chase rpt Darm1 800 RetVal Shell ls_temp 5 Here s a code example for invoking DLV from a vba event and dynamically setting the report path name and parameter value Private Sub Combo0 AfterUpdate Dim rs As Object Set rs Me Recordset Clone rs FindFirst txtReportName amp Me Combo0 amp If Not rs EOF Then Me Bookmark rs Bookmark Dim myreport As String Dim stAppName As String Dim myvalret As String me fullrep is a field that concatenates the report path and name myreport Me fullrep myvalret Str MyCaseno stAppName C Program Files Millet Software DataLink Viewer 2011 DataLink Viewer 201l exe amp LU s wy amp myreport amp wy wee Parmi k LU amp myvalret amp TWP ay DoCm

Download Pdf Manuals

image

Related Search

Related Contents

golden disk Datasheet  Betriebsanweisung - ReinigungsBerater.de  7000LA XGA Proyector de Instalación  Talk electronic Thunder 2.2 User's Manual  Português  Mappus bleibt hart  3 - Dynabook  IMPERIA_1450-@1@ (Page 1)  Scosche FJ1550B mounting kit  Color image forming apparatus and color misalignment adjusting  

Copyright © All rights reserved.
Failed to retrieve file