Розібрався. 

1. 1. Потрібно створити пусту строку в таблиці FastReportTemplate
2. 2. Новий запис в таблиці FastReportDataSource
3. 3. Запис в SysModuleReport
4. 4. Запис в SysModuleAnalyticsReport
5. 5. звіт можна відкрити в сторінці "Налаштування звіту" і продовжити роботу

App connection always returns "Supervisor" since this user is a system operations user. If you need to get the current user who manually triggered report generation and the custom code you need to use the same approach but with using UserConnection instead of appConnection (as Ryan described in his first example):

var currentUser = UserConnection.CurrentUser;
var userId = currentUser.Id;
var userName = currentUser.Name;

Or maybe I didn't understand the required result:)

Oleg Drobina,

My bad! I misunderstood his statement. Since I was trying it out in a source code schema and not a script task, I only tried using the 2nd method. The 1st method correctly returns the required information. Thanks for pointing that out, Oleg!

Hi Vladimir!



Fonts should be installed on the IIS side and the template also needs to be set up correctly to make them available.



The following instructions can help you to achieve the result you are looking for:

https://www.fast-report.com/en/blog/show/custom-fonts-online-designer/

Pavlo Sokil,

Thank you, Pavlo!



We have installed fonts on our Dev IIS server and it works.

But when customer has done the same, on their Test server it works, but on Production - not.



Can you give any idea what can be checked more?



Thank you!

Vladimir

Hi Vladimir.



There are several possible reasons why a custom font added to IIS for Fast Reports may work for one site but not for another, even with the same settings. Here are a few possible reasons:

1. Different versions of IIS: If the two sites you are configuring the custom font for are running on different versions of IIS, this can cause compatibility issues. Therefore, depending on which version of IIS your sites are running on, you should use the corresponding version of the custom font.

2. Different IIS settings: Another possible issue is different IIS settings on different sites. For example, if one site is working with custom fonts over HTTP, and another is over HTTPS, this can affect how the fonts are displayed on the site.

3. Different font locations: It's possible that the fonts are not located in the same place on two different servers, and this can cause issues with loading the fonts on one of the sites.

4. Caching: If the font is added to one site, and then you add it to another, the browser may have a cached copy of the old version of the font. This can cause the font to not change when you switch to the other site.

5. If this is a self-hosted font, it may be necessary to modify the hosting settings of the font to allow access from other domains (perhaps by adding the instance address of Creatio to the Allowed domains list).

To address these issues, make sure you are using the correct version of the font, check if the settings are the same on both servers, make sure the fonts are located in the same place, and clear the browser cache.

I am also curious if there will be a replacement. 

However, we've been doing some very complicated Word printables using a combination of macros and db views. It's turned out to be pretty powerful. 

You can create custom macros for Word docs. The macros can do queries, calculations, even return conditional text as needed. Here's a very simple example in this article: https://customerfx.com/article/creating-custom-macros-to-format-values-…

That example in the article only takes a value and returns it formatted. However, we typically will pass an Id to the macro, do queries and other complex calculations and return values, text, etc. Note, to do queries in a macro you'll need a UserConnection which you can get from the session:

var userConnection = (UserConnection)System.Web.HttpContext.Current.Session["UserConnection"];

Hope this help, it doesn't answer your original question, but wanted to mention that macros for Word printables is possible and does at least bridge the gap with creating more complex Word reports with FastReports being retired. Also, creating db views and exposing as entities has been very useful for more complex Word reports as well.

Ryan

It would be nice to have normal Report designer/generator, cause not all customers use MS Word in their organizations. 

Vladimir Sokolov,

I do agree. Plus, there are some scenarios where a Word report will just not cut it. I have some customers that are producing government forms which have extremely strict formatting requirements (that are just not possible to recreate as a Word document) or they will be rejected.

I do hope there will be a replacement for FastReports at some point. It's possible to do some complex things with a Word report, but it's still no replacement for a full reporting solution.

Hello Team

Any news on FastReport's replacement?

I have been using FastReport editions for my opportunities for two years (10 models), my edition models were stable and I had not seen this future deletion pass...

Except that today, I need to create a new model and I can't...

So I'm stuck... But above all, I would like to anticipate the future...

Best regards

Vincent

Hello Nicola,



Your question is related to the functionality available within the marketplace application.



This add-on was developed by support@crm-bpm.ru. 



So, please, feel free to ask your questions regarding this functionality. 



Best regards,

Bogdan

 

Bogdan,

many thanks Bogdan

Hi Vincent, 



Unfortunatelly there are currently no option to automatically download the attachment using the business process. 

As a workaround you can set up an autogenerated page that would show the link to the file, so you'd need to make one more click to download the file rather then going to the section and downloading it from there. 

In order to build the link please refer to this community post: https://community.creatio.com/questions/link-attachment-file



I'll also register an idea for our developers to implement such functionality in future releases of the app. 



Best regards,

Yurii

Yurii Sokil,

I'd love to see a download trigger in Business Process as well.

This would be a useful addition, it looks like we may have to build this ourselves.

Would be nice to see this in a future update

Hello Akash!



In order to solve the issue, it's necessary to do the following steps:

 

On the Creatio side:

1. Create the fast report record in the "Reports" section and create the FastReport data provider source code in configurations.

2. Create the DataProvider source code. 



Once the DataProvider is created data was sent to the FastReport template for further processing. From now development starts which is not related to Creatio functionality - FastReport template logic modification.



On FastReport side:

3.  There is a "Code" tab in the FastReport template designer. There you need to write logic for String formation (here you can find some examples of how to do it https://docs.microsoft.com/en-us/dotnet/api/system.string.format?view=n…)

Here is the link to the article on Creatio Academy for your reference https://academy.creatio.com/docs/developer/elements_and_components/repo…

 

In addition, please check the link of FastReport academy https://www.fastreport.ru/public_download/html/UserManFrNET-en/index.ht… where you can find information on how to operate with data sources, system variables, report parameters and so on.

Best Regards,

Tetiana Bakai

Just confirming- Do I need to make a table in RTF by writing logic for String formation in Code tab of Fast Report?

Hello Akash!



Yes, you are right. You need to make a table in RTF in the Code tab of Fast Report.



Best Regards,

Tetiana Bakai

Thank you Tetiana for your solution. It will be easier to work for small tables. But I work mostly with complex tables of 8" size and it will be quite time-consuming to prepare each cells by code. In such a case, is there any other lesser time-consuming solution?

Hello,

As for now there is no option to change the file name dynamically or assign some particular name at least Opportunity Quote. We have this task registered in our backlog so this option will be available in future application versions.

Regards,

Dean

Hello Julio,

I've noticed that you've already found the solution to this question in terms of this community post. Please specify if additional help is needed in this thread.

Thank you!

Best regards,

Oscar