Blogs

Email Crystal Reports with Smart Report Organizer

One of the most popular features of the Smart Report Organizer is the ability to automatically email Crystal Reports to other people. As soon as a report has been scheduled for automatic dispatch, it is regularly generated and sent by e-mail.

You can define the settings for your e-mail account here:

E-Mail Settings Report Distribution


Here you can store your SMTP server, username and password and which port should be used.
In addition, you set here whether the e-mail should be sent via SSL and whether the e-mail should be sent in HTML format.

The settings for the individual Crystal Reports are defined here:

Job Settings Report Distribution
Here you can store the sender, recipient, email subject & email body for each individual report job.
You can also use HTML in the e-mail message to send beautiful and well-formatted messages (with images, links and text formatting, etc.).

Here is an example of how a message in HTML format can look:

Email Example

You can also use automatically calculated variables (Dynamic Text Feature) in the e-mail subject and in the message, for example to display the time span of the report in the e-mail subject.
The Dynamic Text Browser helps you with countless examples and you can also test your texts there, which are then immediately converted and displayed.

Dynamic Text Feature

I hope you enjoyed the short blog.

If you have any questions, feel free to contact us.

 

Crystal Reports & StoredProcedures

Crystal Reports & StoredProcedures

Easily Create Reports with StoredProcedures and Crystal Reports

Crystal Reports is a powerful reporting tool that allows you to easily create and export interactive and attractive reports from any type of data source. For example, you can use it to visualize your company data in a sophisticated way and make it available to your decision makers.

SAP Crystal Reports supports almost all common data sources such as databases (Microsoft SQL Server, Oracle, MySQL, Microsoft Access), files (Microsoft Excel, text files, XML) and also other data sources accessible via ODBC, JDBC or OLAP. Reports can be equipped with graphics and tables and can be directly converted into various publishable formats.

In this article, I would like to show you a way to further optimize the use of Crystal Reports and improve your workflow: Crystal Reports & StoredProcedures

How to Use Crystal Reports with StoredProcedures

With SAP Crystal Reports, you can build your reports not only by using tables, views or SQL queries, but also directly by using StoredProcedures. StoredProcedures are server-stored SQL queries. These queries can be equipped with parameters which allows for them to be used even more flexibly. The advantage is that, within the StoredProcedure, the company data can already be prepared in the way as the SAP Crystal Reports report will require it. This makes it very easy to link different data with each other.

Using Microsoft SQL Server Integration Services (MS SSIS), I first copy the company data relevant for my reports (from the various applications and database servers) to a separate central report server.
On this separate central report server, a unique StoredProcedure is created for every SAP Crystal Report. 
The advantage is that now, within my StoredProcedure, I can divide the sometimes extensive and complex SQL queries into several small, easy-to-understand, easy-to-maintain and thus expandable individual sections. 

My Conclusion:

By using StoredProcedures, I can create very complex, extensive, powerful, flexible and, above all, at a later point easy to understand & thus expandable queries, which I can then display perfectly with SAP Crystal Reports.

I hope you enjoyed these articles!

Crystal Reports Scheduler

Crystal Reports Scheduler Blog Image

Smart Report Organizer is a Crystal Reports Viewer and Scheduler that saves you time and money by distributing your SAP Crystal Reports automatically.

To do so, you simply create delivery jobs for your Crystal Reports and define when (time interval), how (file format) and where (destination) your reports are to be sent.

The 3 steps of planning:

  • When (Time Intervals):

    First, you create a delivery job for your Crystal Report and choose which time intervals the report should be exported in.
    You have endless options. Choose from, for example, monthly, weekly, daily, hourly, by the minute or by the second
    You can also choose the end of the month, certain days of the week, or certain intervals. Example: Your report should be exported hourly between 8am and 5pm, Monday through Friday.

  • How (File Format):

    Next, choose which file format your report should be exported as. .
    You can choose from all common formats such as Word, Excel, Pdf, Txt, Rpt, Csv, Xml, Html etc
    You can further set additional Excel and CSV file format parameters here.

  • Where (Destination):

    Lastly, you choose the destination for your Crystal Reports job.
    Again, you have plenty of options: You can send your reports directly to an e-mail recipient,
    save it to a folder (local hard drive, network folder, DropBox/OneDrive etc.),
    send it to a printer or upload it to an FTP server.

Try it for free today – risk free: Download here...
We are sure that you will love it!