One of the most common challenge that SSRS subscription users face is that their reports are sent out on schedule regardless of whether or not they contain data. As you are aware, SSRS reports are typically based on one or more datasets and sometimes these datasets can be empty. When using normal or data-driven subscriptions, the reports are executed and delivered even when the report is blank. This is undesirable as time is wasted by end-users who opens up these reports only to find that there is no data present.
[Read more…]Getting Started with remiCrystal
Getting Started with remiCrystal
We are very proud of is how easy it is to get started with remiCrystal. Once you have downloaded and installed the app, you can open it by going to the Start Menu, select “All Programs” and then choose “remiCrystal” under the “remiWare” menu.
[Read more…]What is the Difference Between Crystal Reports and SSRS Reports
When users are faced with reporting software options, there will most likely have to decide whether to go with SAP’s Crystal Reports or Microsoft’s SSRS (SQL Server Reporting Services) Reports.
At remiWare, we have extensive experience working with both Crystal Reports and SSRS Reports. We have built hundreds of reports using both tools and integrated them into remiCrystal. It is with this understanding that we feel we can help in deciphering the major differences between the two reporting platforms. [Read more…]
Building HTML Tables from a SQL Dataset in remiCrystal
Sometimes, creating an entire report can be overly complicated and time consuming. There are indeed times when all you need is just a basic HTML table with your data embedded in an email or HTML document.
In remiCrystal, you can bypass the entire report creation and configuration process and just use your SQL query to create an HTML table that can be used in one or more tasks. You can even style it with your CSS scripts.
Here is a short video that shows exactly how to do that.
Bursting a Crystal Report in remiCrystal
Do you have a single Crystal Report that you would like split up by Group and have each one sent to a different recipient? remiCrystal’s Crystal Report bursting feature couldn’t be simpler to set up.
The steps involved include:
- checking the box to state that you would like to enable report bursting. Tasks with report bursting can only contain one report.
- adding the Crystal Report file and specifying the name of the field that is used by your report’s Group Header 1 (GH1)
- optionally, you can specify to only burst for certain group values
- you can add a target and then populate it with fields from your Crystal Report. For example, if your Crystal Report contains an email address for the group value, it can be used in the email target.
Check out this video below for a walk- through