We are glad to announce that TMC, a global, integrated media company, has awarded our Stimulsoft Reports.Web a 2015 Communications Solutions Product of the Year Award.

“Congratulations to Stimulsoft for being honored with a 2015 Communications Solutions Product of the Year Award,” said Rich Tehrani, CEO, TMC. “Stimulsoft Reports.Web is truly an innovative product and is amongst the best solutions that facilitate data processing brought to market in the past twelve months. I look forward to continued excellence from Stimulsoft in 2015 and beyond.”

TMCNet Award
We would like to announce that we have done successful tests of our reporting tools on recently released Windows 10, Visual Studio 2015 and .NET 4.6. Our products work as expected. The only issue that we met was related to crashing of printing task from WPF in .NET Framework 4.6 that was described in our knowledgebase. Now the issue is fixed in our latest prerelease build 2015.1.16 from 2015.08.07.
Sometimes it is necessary to predefine the subject and text in the email. But what if you need to specify your company contact details, a subject and text in every email you send? This can be easily done using email templates. There are four templates in Stimulsoft Reports.Server. Each template is used for a certain action in the report server.

· Register an account.
· Password recovery.
· An email with the link to the file.
· An email with an attached file.

Each of these templates can be edited. Click the Administration button on the Home tab. In the window that opens, click the Templates Email tab, select the required template and click Edit.

Email Templates

In this article we will discuss an example of editing the Item Send Email Attachment template. For those who know HTML there will be no issues in editing that template. But for those who are not familiar with HTML we will try to explain, as simple as possible, how to edit the template. Users often ask about how to change the details of Stimulsoft Report on your own? It is easy to out your details.

1. To change the subject, you should change the text between the tags <title> and </title>. For example, type Your Theme.

Email Templates

2. In order to change the title Stimulsoft Reports on your own, then change the following variable {PRODUCTS} between the tags
and, to your text. For example – YOUR COMPANY NAME.

Email Templates

3. Change URL, replacing the variable {HOME-URL} to the desired URL. For example, replace it to http://YourSite.com

Email Templates

4. In addition to the URL you should specify the link text. For example, this is Click Here.

Email Templates

Notice: After changes done, click the Save button.

The email template will looks like on the picture below.

Email Templates

As you can see, all the details have changed. Thus other text of the email template can be edited. For example, you need to change the phrase "In the attachment to this message you can find following files", you need to find this text in the code of the email template and edit this.

Email Templates

Notice: Just above the text "In the attachment to this message you can find following files", you can see a variable {MESSAGE} using what the message is transmitted when the Send action in the viewer is executed.

It remains only to change the text of the email "List of Products-8/1/2015 6:19:04 AM". It is not hard to guess that here is the name of the document and the date-time of its change. There are several options to change this line.

· Replace in the variable {FORMATED-FILE-NAME} by the corresponding text.
· Or to set up the Result name leaving the {FORMATED-FILE-NAME} variable unchanged.

Here is such a brief educational program how to edit the email templates. You can cancel all changes and return the pattern to its original state, by setting all the default values by clicking the Reset button.

We have reviewed editing template Item Send Email Attachment. If you have any questions about editing email templates, you can post your questions here or send comments to technical support. We also have a corresponding section in the forum.
How to create a report having only a web-browser at hand? And, at the same time, the report should be dynamic, and its creation should be as simple as possible? We are preparing a solution for you – Stimulsoft Reports.JS. It is a platform for creating reports using JavaScript and HTML5, including designer and report viewer. The viewer is already here.


js.stimulsoft.com


After the announcement of Stimulsoft Reports.JS, most users ask us one question – what are the advantages of this reporting tool? A we are answering you).
  • No need to install additional .NET and Java applications and add-ons.
  • You can use the software in any JavaScript application.
  • A wide range of devices on which it can run – from the desktop computers to mobile devices (there is support for touch interface).
  • Does not require any servers. It works on the client side.
  • It has all the components, and tools for creating reports. From the simplest to the most complex lists, dynamic reports.
  • Compatibility of products. Reports designed for Stimulsoft Reports.JS can be viewed and edited in our other products, and vice versa.
  • Source code is available.

And the most important advantage of this product is that only a web browser with support for HTML5 and JavaScript is required.

Another issue of concern to some users is whether it is possible to have Stimulsoft Reports.JS on the server side? The answer is – yes, it is possible. In this case, the main thing is to choose the right platform. For example, Stimulsoft Reports.JS will work perfectly with node.js.

Perhaps you have your own ideas and suggestions? We will be glad to consider them. Leave your comments below or contact us through our web form. Also you may discuss the product on our forum.
The report represents a structured data obtained from the file (e.g. XML or CSV) or database. Therefore, the process of transferring data from a source to a report should be as simple as possible. Considering this, we have made a significant improvement. Earlier, in Stimulsoft Reports, data adapters were divided into embedded ones and external. The built-in ones were SQL, OLE DB, ODBC, XML, MS Access, and the rest were external. In order to use external data adapters, it was necessary to perform some actions – download the adapter from the web site, unzip the file, add a reference to the dll, etc. And only after that you can work with a particular type of data source.

Certain problems occurred, if the report was created on one device, its rendering was carried out on another device, while using different versions of Stimulsoft Reports. In this case, it was necessary to recompile the adapter.

Now we have simplified the process. We have embedded all the data adapters. You create a connection to a data source directly from the dictionary. To do this, simply copy the necessary assembly to the bin folder, for example, for MySQL – MySql.Data.dll, Oracle – Oracle.DataAccess.dll, SQLite – System.Data.SQLite.dll etc. Consider the example of passing data to the report from MySQL source. First, create the MySQL connection. The picture below shows the window for selecting the type of connection.

Connection

Select the type of MySQL

Note that the frequently used types of connections can be attached to the top of the list. To do this, click the Pin icon.

In the next window, specify the connection string and click the Test button to test the connection.

Connection

After a successful test, click OK. Now the created connection will be displayed in the data dictionary. Based on this connection, it is necessary to create a new data source. To do this, select New Data Source in the Actions menu of the data dictionary. In the opened window, select the created MySQL connection or the point Data from MySQL. In the first case all database schema (tables, views, and procedures) it will be obtained, and in the second, it will be necessary to create a request.

Data Source

After you click OK, the next window appears. You can select data or create a request.

Data Source

After you click OK, the selected data will be displayed in the data dictionary.

Dictionary

Now, on the base of these data, you can create a report.