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.
How To Send SQL Query Results To Email
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.
Prevent Blank SSRS Subscription Reports From Being Sent
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…]How To Convert Crystal Reports to SSRS Reports
It is no secret that a lot of organizations are either considering to or already migrating from SAP Crystal Reports to Microsoft SSRS Reports. The reasons for this change vary from the feeling that Crystal Reports is nearing EOL, pricing or change in technology stack.
What is also not a secret is that most organizations have had Crystal Reports in use for many years and therefore they have in that time created hundreds (if not thousands) of very useful and business-critical reports. The question then arises; how do you convert all your Crystal Reports to SSRS Reports so that you do not have to do it all manually? [Read more…]
How to Embed a Report in Your Emails
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.
Top 5 Crystal Reports Schedulers
There are quite a few tools that you can pick from to automate and schedule Crystal Reports. We, of course, are very proud of our Crystal Reports scheduling tool, remiCrystal. Not only is it light and easy to use, it is also very reliable and powerful. We, however, acknowledge that it might not fulfill some needs that some users have. [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…]