Crystal Reports new release Ripplestone

What’s New in Ripplestone Version 3.3

Ripplestone 3.3 – Summary

Home Page

Home Page Data Caching

Most of the data used by the home page is now being cached by the system. This increases the performance of the home page by reducing the number of calls to the Ripplestone database. This option can be controlled by the administrator in the web.config file.

Fixed a problem when updating the home node

When changing the root/home node on the home page there was a bug that would not allow the administrator to change the node name.


Scheduler Changes

New FTP Library

Ripplestone is now using a new and improved FTP library and provides more options


Fixed bug to display the Schedule time correctly

When a scheduled job was set to run between 1 – 9 minutes after the hour the display would not display the 0 (zero) before the minute. It would look like 4:5 PM; in the new version it is displayed as 4:05 PM.

New Output type

A new output type has been added to the scheduler. The Editable RTF Export type has been added to the Output Format dropdown.

Fixed bug for Jobs between midnight and 1:00 AM

There was a bug for any jobs scheduled between midnight and 1:00 AM. The job would not always get started at the correct time.


New icons on the list schedule page

The Scheduled Documents page now uses icons to save space on the page. The page also added a Run Now button (the Green Arrow) to run a scheduled job now and bypass the scheduler. This is good for testing or when you need to run a job outside of the scheduled time.



Fixed a problem when Emailing a scheduled job to multiple addresses

There is an option in the System Setup and Configuration page to turn on an option to email messages from the scheduler one at a time. If this is turned on then emails are sent to each recipient as a separate email. If the option is unselected then all the email addresses are added to the email and the email is sent once. All recipients can see who else the email was sent to. There was a bug in the system that stopped the email from being sent. This bug has been fixed and all email addresses will be added to a single email.

Below is the option from the System Setup and Configuration page.


Database Connections

Added new fields to allow new Server and database

The Database Connection page has been change to allow the administrator to change the database server and the database name that the report will use. This helps when the Crystal Report need to get the data from a new server or from a new database name without needing to change and republish all the Crystal Reports that use that database connection.

The example below shows the original database connection using the RipplestoneTestServer and then with the new option the reports will login and use the RipplestoneProduction server.


Alternate Database Login and Password

This new option is set on the Edit Document page and allows the Crystal Report to have a different database login and password that will override the login and password stored in the database connection for that report.




Windows Integrated Security Users

If the Ripplestone application is configured to use Windows Integrated Security the users are required to have the checkbox checked for Integrated Security to work. If the user does not have the checked box checked then they will be redirected to the sign on page.

Crystal Reports General new release Ripplestone Ripplestone Tips Tutorial

Ripplestone 3 – Home Page Tour

With the release of Ripplestone version 3, we have added many new features to the home page and to how you view and interact with Crystal Reports.

Below is a quick tour of the new features.


Performance and Usability Improvements


Two new links have been added to the top menu bar.

  • Favorites allows users to quickly get to the documents marked as favorites. The favorites view loads quicker than the home page and is simpler to use.  There is an option to have the Favorites view be the default view when starting Ripplestone.
  • Scheduled History give the users a quick way to view all the scheduled history without needing to click on each Crystal Report on the home page.  This is helpful for the users that need to check the history of many reports.
    The navigation tree on the home page has been updated with AJAX and Data Caching to allow a smoother and quicker navigation experience.  The page will no longer flash as the user is clicking on the folders and documents in the tree.


          Multiple Reports

        With the new version of Ripplestone users can open multiple reports from the home page and then switch between them using the tabs.  The reports also open within the home page and not as a new browser window allowing the user to view the report more easily.  The reports new feel more integrated in the Ripplestone application.




      New Crystal Reports Viewer


      Ripplestone 3 is using a new web viewer and new parameter page for running Crystal Reports.  Below is an example of the new parameter page, this opens within the home page and not as a separate web browser window.  It has a more integrated feel and a new indicator is displayed to let the user know that the report is being run.



      The new web viewer allows the user to refresh the report and they will be prompted to enter new parameter values or if the report is written in Crystal Reports 2008 or 2011 they will have the option to open the Parameter Panel shown below.  This new panel will allow the user to view and change the parameter values without closing the report.



      With these new features the home page of Ripplestone has become easier to use and more productive in viewing your Crystal Reports and Office Documents.

      Crystal Reports General new release Ripplestone

      Ripplestone Release 2.9.12




      With version 2.9.12, Ripplestone continues to improve Crystal Reports Parameters Page and the Scheduler.

      Report parameters

      Fixed issue with parameters with no value

      If a parameter has no value the parameter will still be sent to the report.

      Additional Improvements For Stored Procedure Parameters

      This version continued improvements, started in version 2.9.11, for parameters that are coming from a Stored Procedure and when to display the Set to Null checkbox.

      Fixed Issue for Parameter Default Values

      Added code to check if a Crystal Report parameter has any default values; if the parameter doesn’t have any default values Ripplestone will display a text box for the user to enter a value.

      Fixed Issue for Parameters That Allow Multiple Values

      This version improved the code that displays the parameters values that were saved for a scheduled job.


      Scheduler Changes

      A bug was Fixed to Check if the Scheduled Job Has Saved Parameters

      Fixed a bug where a Crystal Report was saved into the Scheduler without parameter values and then opened at a later time and the program would try to fill the report parameters with values. The page would get an error because there were no parameter values found in the Ripplestone database.

      A Bug Was Fixed During Saving of Parameter Values

      If a Crystal Report was scheduled in the Ripplestone Scheduler and it had parameters the parameter values were saved in the Ripplestone database. If the report was then changed and the number of parameters was changed the application would not be able match the parameter values in the database with the new parameters in the report. This fix will now attempt to match the parameters in the database with the updated parameters in the Crystal Report.


      General items

      Changed the Format for Dates

      This version changes the format for dates to allows store the dates in the database in the format of yyyy/mm/dd hh:mm:ss. This will help with countries that don’t follow the USA standard of mm/dd/yyyy.

      Added Logging When A Report Or Folder Gets Deleted Or Moved

      Added code to log in the trace logs anytime a Crystal Report, Document or Folder gets deleted or moved. With this feature there is an audit of when items are moved or deleted.

      Added new RS Express tab to the edit document page

      A new tab was added to the Edit Document page that will display the RS Express values needed to use the RS Express feature.

      Added new RS Express Option to enable the feature

      A new option was added to enable or disable the RS Express feature.

      Added new RS Express Option to enable the Unique Key Feature

      A new option was added to enable or disable using the RS Express Unique Key feature.

      Crystal Reports General new release Ripplestone

      Ripplestone Release 2.9.11




      With version 2.9.11, Ripplestone continues to improve the scheduler and add features to give you more information about the reports and users within Ripplestone.

      We will continually strive to look for ways to make Ripplestone the easiest tool for managing Crystal Reports and Microsoft Office Documents.


      Report parameters

      Fixed issue when Report is getting a parameter from a Stored procedure

      The parameter display was updated when a report is getting parameters from a store procedure it displays a “Set to Null” checkbox on the parameter page.



      Fixed issue with date parameters with default values

      If a parameter is of type Date or DateTime and it has a list of values, the parameter page will display a list of the date values.


      Fixed issue with text parameters with no default value

      If a parameter has no default value the parameter page will display a text box to allow the user to enter a value.


      Scheduler Changes

      Added option to Use the users within a role for row level security

      This allows the scheduler to loop through the users within a role and use the UserID or User ID tokens for the Row Level Security value. This simulates the process of when a user runs the report. When this report is run from the scheduler, it will be run once for each user in the role using the Row Level Security information to filter the report data for each user.


      Adding option to use the email address stored in the user profile to send report

      This allows the scheduler to loop though the users within a role and use their email address to send the report. This allows the administrator to manage the users in the role and saves them from managing the email list in the scheduler. Additional email addresses can still be entered into the To box for people that are not in the Role.



      General items

      Added field on the edit document page to display the document id

      A new field was added on the Edit Document page to display the Document ID field. This is useful when using the RS Express feature.

      Added new usage tab to the edit document page

      A new tab was added to the Edit Document page that will display usage statistic for that document. The tab will display the number of times that the Crystal Report or document was run, the date that it was last run, display information on the last 10 runs and the top 10 users that run this Crystal Report or document.



      Added new usage tab to the edit user page

      A new tab was added to the Edit User page that will display usage statistic for that user. The tab will display the last date the user logged into Ripplestone, how many times they has logged in, display the last 10 Crystal Reports or document they have run and the top 10 Crystal Reports or document they run.


      Changed the system setup & configuration page for administrator

      Permissions were changed on the System Setup and Configuration page for Administrators. Users that are in a Role with Administrator permissions can now only change the Troubleshooting Tab. Users that are in a Role with Super User permissions can change the other options.



      Bug Fixes

      Adding a new report will use the default viewer

      When publishing a new Crystal Report, the system will use the default viewer set in the System Setup & Configuration page.

      Fixed issue with logging into crystal reports that have a sub report

      Fixed an issue on some reports that had sub reports where they would not correctly login to the data for the sub report.

      Fixed issue with System using Access for the Ripplestone database

      Fixed an issue that occurred when an Administrator was creating a new Folder and needed to assign the security to the administrator and the Ripplestone application was using Access for the database.

      Fixed issue with security for administrator

      Fixed a bug when Administrators where getting a list of users that the administrator is allow to see. They were able to see all the users in the system and this is only available to the Super User.

      Fixed issue with Folder security for administrator

      Fixed a bug when Administrators where opening or viewing a folder where they didn’t have permissions to view the folder.

      Crystal Reports new release Ripplestone

      Ripplestone Release 2.9.10

      With Ripplestone version 2.9.10 we have concentrated on improving the Report Parameters page and the Scheduler.  These two are some of the most used sections of Ripplestone and benefit the most of getting new features

      Report Parameters

      • Changed the Format for Date Ranges – When a report parameter is a date range type, the display for the dates will be in a more user friendly format.
      • Changed the Format for Parameters with a Single Default Value – When a report has a parameter that only has one default value, the display will be more like the display in Crystal Reports XI.
      • Changed the Format for Discrete and Range Type Parameters – When a report has a parameter that is a discrete and range type, the parameter page will look more like the parameter page that is displayed by Crystal Reports XI.
      • Updated the JavaScript to Fix Changes in Internet Explorer 8 – Internet Explorer 8 is stricter in how it uses JavaScript so the JavaScript code was updated to allow Internet Explorer 8 to work better with the parameters.
      • Parameters That Have Commas in the Parameter Value – If the report parameter is a single discrete value and the value has a comma in it, Ripplestone will correctly use the comma and not split the value into two or more values.

      Below is a screen shot of the new parameter page with examples of some of the new formats.

      Improved Parameter Page

      Example of our newly improved Parameter Page


      Scheduler Changes

      • Added Daily Option to Select Which Days of the Week to Run – When a scheduled job is set to run daily, the scheduler can specify which days of the week they would like the job to run. For example, they could have the job only run Monday – Friday or they could have the job run on Saturday and Sunday.
      • Adding New Scheduled Jobs From the Home Page Made Easier – When adding a new scheduled job from the home, the scheduled job will select the report on the Folder & Parameters tab so you don’t have to find it within the tree. It will also have the parameters for the report displayed.
      • Changed Run As Role Dropdown to Show All Roles for the Super User – If the scheduler is a Super User, then they will see all the roles in the Run as Role dropdown list. If they are an administrator or Scheduler they will only see the Roles they are allowed to see.

      New Daily Option – This allows the scheduler to select the days of the week that the job should run.



      Email System

      • Added an Option to use SMTP Authentication – Added a new option for systems that use a SMTP Authentication and need to supply a user name and password to send email.


      • Add Correct User Security When Adding New Folders – Changed the adding of new folders to use the current user to determine if they are a Super User or an Administrator. If they are an Administrator then they will get access to the newly created folder. Before only the Super User would get access to the new folder.

      Bug Fixes

      • Hide the Password Fields in the Edit User Page – If the user has been marked as an Integrated Security user, then the password fields will not be displayed since they are not needed.
      • Updated the Record Selection Formula for Alert Reports – In some cases adding the alert code to the report’s record selection would cause an error. The formula has been changed to allow the alert code to be correctly added in those cases.
      Crystal Reports Ripplestone

      Ripplestone Release 2.9.9 – Summary


      With version 2.9.9, Ripplestone continues to improve the user experience with changes to the home page that make it easier for users to navigate and find the Crystal Reports and Office Documents that they use most often. For the administrator we have added many new features that allow them to provide more flexibility for their users.

      We will continually strive to look for ways to make Ripplestone the easiest tool for managing Crystal Reports and Microsoft Office Documents.

      Home Page Improvements

      Added Search to the Home Page

      Added a search function to the home page that will allow users to enter a value into a Search Box and any reports with the value in the Title will be displayed in a list on the right side of the Home page.

      Added My Document Feature

      Allow user to select documents or reports that they use often as favorites and these documents and reports will be listed on the home page for the user.

      Display the published documents when a folder is clicked

      On the home page, when a folder is clicked the right pane will display all the documents and reports for that folder and allow the user to run/open then from the list. This allows the user to quickly run the report without first clicking on the report in the left side tree and then clicking the Run Report link.

      Right Click Support

      On the Home page users can right click on the navigation tree and get context menus with common actions.

      Scheduler Changes

      Performance Tune the Scheduler

      The time it takes for the scheduler to check for jobs to run will be faster.

      Added New Export Options to the Scheduler

      Added new export options that were made available in Crystal Reports XI.

      Clean the list of scheduled documents in the history folder

      Allow an Administrator or Super User to set a number of documents to keep in the scheduled history or to set the duration in days for documents to be kept in the scheduled history. This can be set globally and then over ridden for individual documents.

      Added “First Day After” Option to the Scheduler

      For scheduled jobs that run Monthly or Quarterly, there is a new option to run the report on the first day of the month or quarter.

      Administrator Document And Home Page Changes

      Add option to open a report in pdf format

      Allow a report to be opened in a pdf viewer instead of the Crystal Reports Web Viewer. This will be an option on the Edit Document page.

      Added a new tab called Published Folder on the Edit Document Page

      On the edit document page, a new tab was added called Published Folder. This new folder is used to select the document or report to be published and to select the folder that the document or report will be published to. The folder select is now using a tree that makes finding the folder easier.

      Move a published document or report from the Edit Document Page

      Added the ability for a Publisher or Administrator to move a document or report to another folder from the Edit Document Page. Before the document would need to be deleted and then re-published to move the document or report.

      Edit the Web Viewer Print and Export options from the Edit Document Page

      If the report is using the Crystal Reports Web Viewer, allow the user to edit the print and export options from the Edit Document page. The list of reports that are using print and/or export restrictions can still be viewed from the Administration page, but the Adding and Editing is now done on the Edit Document page.

      Allow the Title and Text for the right side of the Home page to be changed

      Using the System Setup and Configuration page allow an Administrator or Super User to change the title and the text that is displayed on the right pane of the Home page when Ripplestone is started and when the root node of the tree is selected.


      Allow the administrator to define what a role can do

      When an administrator creates a role, let them have a list of tasks that can be assigned to a role. For example, the administrator could create department administrators that can add users and folders but only to their defined list of folders.

      Allow role security to be at a folder level

      Allow the administrator to assign the role security (Admin, Publisher, and Scheduler) at a folder level. For example, a role might allow users to view 3 folders within Ripplestone, but only allow them to be a scheduler on one of those folders. On the other two folders they can only view the reports.

      Check the user’s security for each folder

      When a folder is selected the security is checked for the user to see if they can publish, schedule or only run the documents and reports published in that folder.

      Bug Fixes

      Fixed a bug for saving the Password

      On the Edit User page, there was a bug that did not save the password when a password was entered and then the user moved to another tab and then saved the User page. This page now correctly saves the password.


      Added a link to Delete All Trace Logs

      On the Trace Logs page, a link was added to delete all trace logs.