remiWare

Report Scheduler for Crystal Reports, SSRS Reports and more.

  • Features
  • Download
  • Pricing
    • Renew Maintenance
  • Version History
  • Contact Us/Support
  • Become a Partner
  • Blog

Top 5 Reasons PDF Bursting Is Better Than SSRS Data-Driven Subscription

October 20, 2019 by remiware

As defined by Microsoft, this is what an SSRS Data-Driven subscription is:

A data-driven subscription provides a way to use dynamic subscription data that is retrieved from an external data source at run time. A data-driven subscription can also use static text and default values that you specify when the subscription is defined. You can use data-driven subscriptions to do the following:

– Distribute a report to a fluctuating list of subscribers. For example, you can use data-driven subscriptions to distribute a report throughout a large organization where subscribers vary from one month to the next, or use other criteria that determines group membership from an existing set of users.

– Filter the report output using report parameter values that are retrieved at run time.

– Vary report output formats and delivery options for each report delivery.

PDF Bursting is similar to data-driven subscriptions in what it achieves as the end result however it is completely different in how it goes about getting the job done.

PDF and Excel Bursting is better than SSRS Data-Driven subscription in many ways

Here are the top 5 reasons PDF Bursting, and by extension, Excel Bursting, is better than SSRS Data-Driven Subscriptions.

  1. Considerably Cheaper: In order to use SSRS Data-Driven subscriptions, you must be using SQL Server Reporting Services Enterprise Edition and the cost for that tier is at minimum $3717. It will cost more if want to host it on a server with more CPU cores. In contrast, remiCrystal with PDF/Excel Bursting costs only $999.
  2. More Efficient: If your report has to be data-driven for 1000 rows of data, in the SSRS scenario, the report will need to be run 1000 times and each time taking up database, processing and network resources. For PDF Bursting, the report is run only once and then using our algorithm split up and bursted into separate reports for delivery.
  3. Much Faster: As the SSRS Report is run only once for PDF Bursting, the entire process is unbelievably faster. When we compared running a data-driven subscription of 100 records with that for PDF Bursting, the latter was up to 230% faster.
  4. Access To In-Report Variables and Formulas: When using PDF Bursting in remiCrystal, all you need to do is add a special bursting tag that will be read by the the application at run time. You can therefore include any formula or variable into the bursting tag so that it can be accessible by remiCrystal without having to recreate it outside the report.
  5. Data Consistency: When running a data-driven subscription, the report’s data is fetched for every report run and what this means is that if you are using a very active transactional dabatase as the source, the results may differ between the first record and the 1000th. With PDF Bursting, the report is run only once and the data represents a real snapshot of that moment in time regardless of whether it is the first or 1000th record being processed.
  6. Bonus: Easier Maintenance: When dealing with SSRS Data-Driven subscriptions, you have to maintain 2 sets of data; one or more for the report itself and another for the data-driver. You must always always make sure that these 2 sets of data correlate at all times otherwise you could run into unforeseen issues. Making changes to the report also means that you have to consider its effect of the data-driver recordset. With PDF Bursting on the other hand, you only need to worry about the datasets in the report itself.

As you can see, PDF (and Excel Bursting) can save you and your organization money, time and resources in real meaningful ways. To get started and see what a difference it will make, download the free unlimited trial of remiCrystal today.

Extra Reading:

  • How to set up PDF Bursting
  • What is Excel Bursting
DOWNLOAD NOW

Filed Under: database, Microsoft Excel, SSRS, Tech Tagged With: data-driven, data-driven subscription, excel bursting, pdf, pdf bursting, sql server reporting services, ssrs

Exciting Times Ahead for remiCrystal

November 26, 2018 by remiware

First of all, we would like to take this opportunity to thank you for choosing us as the solution provider for your report distribution needs. We value our partnership with you very much.

As we approach the end of the year, we think it is a good idea to share with you a few of the exciting updates that we are planning for remiCrystal in 2019.

Upgrade to Microsoft .NET Framework 4.x

Currently, remiCrystal runs on the Microsoft .NET Framework v3.5. This version of .NET is very mature and stable and has allowed remiCrystal to remain compatible with older operating systems such as Windows XP and Windows Server 2003.
However, in order to continue to offer innovative new features, better security and faster performance, we are going to shift and base remiCrystal on Microsoft .NET Framework 4.x. This change will mean that future versions of remiCrystal will require Windows Server 2008 R2 Service Pack 1 or above.

The first version of remiCrystal to be based on .NET 4.x will be version 5 and is slated to be released in Q1 2019.

Some of the features that will be enabled by this migration to .NET Framework 4.x include

  • higher level of password encryption for Zip and PDF files for better security
  • better parallel execution of reports and tasks will lead to faster performance
  • better UI responsiveness
  • better UX design 
  • higher application stability

remiCrystal Server Edition

One of the most distinguishing and innovative features of remiCrystal is that all the tasks are stored as individual self contained files (.rctx). These self-contained files are easy to manage since they can be treated like any other file on your PC and as they are all self-contained, there are reduced points of failure.

One feature that has been requested a lot by our users, is a way to have a central management application for all remiCrystal tasks. I am excited to tell you that we have began developing this central management application, remiCrystal Server, and plan to launch it in Q2 2019.
remiCrystal Server Edition will be a FREE add-on to all our existing Advanced Edition customers.

remiCrystal Server Edition

More Cloud Integrations

As you are probably already aware, the world of technology has shifted to a cloud-centric approach for almost everything. As more and more of our users utilize cloud services, we are going to be building more integrations into cloud services such as Slack, Google Sheets, Dropbox and more.

Thanks to you, the future of remiCrystal looks brighter than ever and I can’t wait to get all the exciting new features into your hands.

Filed Under: remicrystal, SSRS, Tech Tagged With: .NET Framework, crystal reports, platform, remicrystal, remiware, ssrs, updates

How to Move a remiCrystal Installation To A New Server

November 26, 2018 by remiware

remicrystal migration

remicrystal migrationHow to Move a remiCrystal Installation To A New Server

Moving remiCrystal to a new server is relatively straight forward affair.

  1. Copy Your remiCrystal Tasks
    As you are most likely aware, all the remiCrystal tasks are actually files with the extension .rctx and you can just copy them to your new server. To make the move more straight forward, we suggest storing them in the same location/path as the old server.
  2. Copy The Windows Tasks 
    To move the triggers from the old server, if you are using the v1 of the Windows Scheduler API (options > Advanced in remiCrystal) you can copy them from “C:\windows\tasks” from the old machine to the new one. If you are using v2 of the Windows Task Scheduler API, you should copy these from “C:\windows\System32\Tasks\remiCrystal” into the same folder on the new server. For newer operating systems like Windows 10 or above, follow the instructions here
  3. Move Your License
    Moving the license requires that you deactivate it on the old server and activate the new one. You can deactivate the license on the old machine by going to Start Menu > All Programs > remiWare > remiCrystal > Deactivate remiCrystal. This will give you a special code that you should email to us.
    You can then activate it on the new server by going to Start Menu > All Programs > remiWare > remiCrystal > Activate remiCrystal.
  4. Transfer Your Settings and Task History
    In order to keep your settings such as email configurations and task history, copy the following files and folders from “%programdata%\remiWare\remiCrystal\ to the new server

    • dataObjects.dbx
    • sentmail.dbx
    • settings.xml
    • ssrsaccounts.xml
    • Data Cache (folder)
    • History (folder)
    • Sent Emails (optional, folder)

[Read more…]

Filed Under: Crystal Reports, Latest posts, remicrystal, SSRS, Tech Tagged With: faq, help, how-to, migration, remicrystal, tips

How To Schedule SSRS Reports to Email

October 5, 2018 by remiware

The ability to schedule SSRS reports to email can be a game changer for your business. Once your reports are scheduled, they are guaranteed to be delivered to the people that need the information when they require it.
Scheduling SSRS reports to run manually means that you don’t have to worry about forgetting to send the reports and that there is little to no chance for human error.

[Read more…]

Filed Under: database, SSRS, Tech

How To Send SQL Query Results To Email

December 1, 2017 by remiware

When it comes to report design and creation, you are spoiled for choice. You can choose from a plethora of tools such as Microsoft Access Reports, Crystal Reports and Microsoft SSRS Reports.

There are times however when these tools are too heavy and too time consuming to just, say, send SQL query results to email.
There are ways to do this that may not involve the full blown report designer such as using SQL Server’s stored procedures such as “sp_send_dbmail” however your output formats are limited and most users do not have the right access to their database systems.

[Read more…]

Filed Under: Crystal Reports, database, Microsoft Excel, SSRS, Tech Tagged With: access send email, access vba send email, msaccess send email, send query results via email, send sql query results to email, sp_send_dbmail, sql email query results html, sql send email, sql server export to excel

How to Embed a Report in Your Emails

November 7, 2016 by remiware

A picture is worth a thousand words. A graphic can relay your information and be consumed by its audience in seconds instead of minutes. It is therefore important that your reports contain a mix of charts and more detailed information. Any reporting tool is measured by how well and how easy it is to create compelling analytical charts and graphs.

One of the challenges that users face when distribution reports, whether manually or automated, is to have the report embedded as the body of the email so that the recipient views the data as soon as they open it. remiCrystal allows you to pick which of your report in a remiCrystal task you can have embedded in your email as the message body. The report can be embedded either as plain text or as standard HTML where any images and links in your reports are preserved as part of the email.
Embedding your report into an email is a simple one step process.

[Read more…]

Filed Under: Crystal Reports, SSRS, Tech Tagged With: crystal reports, email, email lists, HTML, information, kpi, ssrs, ssrs reports, text

How to Automate and Schedule Microsoft Excel Workbooks

August 8, 2016 by remiware

Microsoft Excel is one of the oldest and most powerful peaces of software ever written. In fact, there are more than 1 billion users of Microsoft Office to date and a good number of those use Microsoft Excel. Lots of businesses also utilize Microsoft Excel on a daily basic to store data as well to carry out data analysis. [Read more…]

Filed Under: database, Microsoft Excel, Tech Tagged With: automate Microsoft Excel, Excel Refresh, Microsoft Excel, Microsoft Excel Email, Microsoft Excel Macros, Microsoft Excel PDF, Microsoft Excel Power Pivot, Microsoft Excel Reports, Microsoft Excel Workbook, Microsoft Excel Worksheet, Microsoft Power Query, schedule Microsoft Excel, Workbook

5 tips to Speed Up Your Crystal Reports

July 28, 2016 by remiware

We have all been there. Staring at the screen, watching the little counter, waiting as Crystal Reports takes its time exporting what should be a simple report to a file format of your choosing. Worse still, the report takes so long that when you schedule it to run, you have to schedule it to run in the middle of the night just so the data is ready when you walk into the office in the morning.

[Read more…]

Filed Under: Crystal Reports, database, Tech Tagged With: automate crystal reports, crystal report scheduling, crystal reports, crystal reports delivery, crystal reports distribution, crystal reports email, crystal reports FTP, crystal reports print, crystal reports runtimes, crystal reports slow, deliver crystal reports, ODBC, OLEDB, Oracle, schedule crystal reports, slow crystal reports, speed up crystal reports, sql, SQL Server

Next Page »

 remiCrystal is Reliable

remiCrystal utilizes the Windows Task Scheduling system for all its automation. This means that your reports will be delivered as long as Windows is running. No ifs or buts.

 remiCrystal is Easy To Use

With remiCrystal, you do not have to spend money on training your staff on how to use the software. We believe that if you can use MS Word, then you can use remiCrystal.

 remiCrystal is Cost-Effective

When you purchase remiCrystal, you will begin to realize the return on investment immediately. You will save time money and human resources. Automating your processes will reduce errors in your reporting immensely.

COPYRIGHT ©REMIWARE 2018