By: Jeff | October 30, 2017

When a user runs a Crystal Report from the home page of Ripplestone, the report is displayed within the users web browser. They have the option to manually save the report by exporting the report output to a file or they can print the report. But if they would like the report saved to a file every time the report is run they can take advantage of the Send To feature.


The Send To feature is used to either create and save a file of the report or to email a copy of the report via email. This action will be performed each time the report is run on demand from the home page of Ripplestone.


This can be useful when you need a physical copy of the report or another system will be looking for a copy of the report. Perhaps in an Excel or CSV format.


...

By: Jeff | February 11, 2016

When exporting from the Crystal Reports Runtime Engine, some reports will have a smaller font size when exported to pdf.  This can also happen when printing a report since browsers such as Chrome, Firefox and Edge will first export the report to pdf and then print the pdf file.  Internet Explorer can either print using an ActiveX control or by also first exporting to a pdf file.  When using the ActiveX control the fonts retain the correct size.


To force the engine to maintain the font size you will need to make a change to the Windows Registry.  To make the change open the Registry Editor by typing RegEdit.exe in the Run dialog box.


 


Once the Registry Editor is open, find the Crystal Reports key using the following path:


HKEY_LOCAL_MACHINE\S...

By: Jeff | February 02, 2016

When trying to send a Crystal Report directly to a printer from the Ripplestone scheduler, you will need to change some settings to allow the scheduler service to have permissions to the printer.


Changing the Login for the Service

By default the Ripplestone scheduler runs as a local system account.  This account usually doesn’t have permissions to print to network printers.

  


To allow the service to have permissions to print, change the Log On to a user that does have permissions.  This will require a re-start of the service.


 


 

Install the Printer on the Ripplestone Server

To make sure that the server has the correct driver you will need to install the printer on the Ripplestone server.

By installing the printer, you should also get the prin...

By: Jeff | September 24, 2015

 

Using Crystal Reports Designer

When using dynamic parameters within Crystal Reports you can easily have more parameter values than Crystal Reports can display.  The default number of values that can be displayed is 1,000 and if you are using cascading parameters the number of values is the sum of the values in all the parameters used in the cascade. In the screen shot below, the values should go to the ZM, but the list stops at ME since the combination of the Customer Code parameter and the Date Range parameter is greater than 1,000. LOV-Default To fix this problem in the Crystal Reports designer you need to edit the Registry.  The location for Crystal Reports 2008 is below.  Normally the last key of LOV is not created and will need to be created ...

By: Brenda | February 12, 2015



This feature, called RSExpress, allows a report to be run and viewed in the report viewer without first logging into Ripplestone. This allows users of Ripplestone to run reports that are published in Ripplestone from external applications without the users first logging into Ripplestone and running the report from the Ripplestone application.

This feature uses a query string that is appended to the URL to provide information that the viewer and report need to run. This information is normally provided by the Ripplestone application, but will now be provided using the query string

Below are instructions on how to use this feature

1. The query string can take up to 5 parameters. The first 2 are required and the others are optional. The name and description of each are listed below.


Parameter nameRequiredDescription
DocIDXThe ID of the published document.
Note: The report must already be published within Ripplestone.
UserXThe name of an existing user within Ripplestone. For example, AdministratorThis can also be the encrypted user name described below.
ParamsThis is used to pass in values for report parameters. If the report has multiple parameters each parameter is separated by a comma.Range parameters can be passed in and are separated by a semi-colon (;).
For example if a report had two parameters, a Country parameter and a HireDate parameter and the Hire Date parameter is a range type, then the syntax would be Params=USA,4/1/1992;8/15/1992. This would pass “USA” into the Country parameter and would pass in the two dates as the start value and end value for the HireDate parameter.
KeyA system generated key to make this unique. This helps make the query string more secure.
ExtFileNameThis is used to pass in a file name that will be used to save a copy of the report. This External File Name feature needs to be turned on in the Edit Document page to be used.

1.2. To create the URL you create a valid URL to the CRViewer.aspx page. For example, www.ripplestonedemo.net/CRViewer.aspx

or
//servername/ripplestone/CRViewer.aspx


3. Then to append the query string; add a question mark (?) followed by the parameters for the query string. These are the parameters listed above. The parameters are separated by a “&”

 

RS Express Tab


To help with creating the query string we have added a tab called RS Express to the Edit Document page. This tab allows you to turn on or off the RS Express feature for this document, create a unique key and view a template for the query string.

image

 

System Options for RS Express


The RS Express feature can be controlled at a system level on the System Setup and Configuration page.

RS Express – Active: This option allows you to turn the RS Express feature on or off. Turning the feature off will not allow any published reports to use RS Express, unless the report overrides this option at the report level.

Require Unique Key: This option will require that a unique system generated key be used in the query string. Using the key makes the query string more secure by eliminating the ability for a use to guess different DocID values.

Use Encrypted User Name: This option uses an encrypted user name instead of the plain test user name. This increases the security when the user name is used for Row Level Security and you do not want users entering other names into the query string

image

 

Encrypted User Name


To get the encrypted user name for the query string, go to the Edit User page and then the User Options tab. This will contain the user’s name in an encrypted format. This can then be used instead of the normal user name.

For example, the URL below is using the encrypted user name:

http://localhost:52663/CRViewer.aspx?DocID=53&User=cfRiKypX6cI=

image