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
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…]
If you have spent any amount of time with Crystal Reports along with any third party tool, you will would have come across the “database logon failed” error at least once.
On the face of it, this error is self-explanatory; your report is unable to log into the database. It can also manifest itself with a “failed to open connection” message.
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.
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.