Hi,

Reports in Creatio are stored in the SysModuleReport and SysModuleReportTable tables, just like other records in the database. 

They can be transferred using Databindings (for more details about this mechanism, please refer to the article - https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/development-tools/packages/bind-data/bind-data-overview).

Please check the necessary bindings.

The print forms are stored in two tables:

• SysModuleReport (Print form of the section);
• SysModuleReportTable (Table part of the print form).
•  

Thus, for the correct transfer of the entire print form, it is necessary to perform the bindings of all the specified tables.
When transferring, make sure all print forms' titles are unique.

More details about the functionality can be found at the following link:

https://academy.creatio.com/docs/8.x/no-code-customization/customizatio…

Hello,
 

Unfortunately, the functionality you mentioned with the button is not being implemented. 

Printed forms work so that they print the information contained in a single record of a section. One section record equals one report. If the task is to include information about multiple records in one report, it is better to create a separate section for this purpose, where you can add fields and details that will reference specific records via reverse relationships. This way, you can include data from multiple records in the report.
 

Printable forms are generated as one document per section record. If you want to implement your own logic for working with printed forms using development tools, you can look into the client schema "PrintReportUtilities," which interacts with "ReportService" on the server side.
 

It would be best if you implemented something similar to ReportService.

Dear Sasori,

As of now, it's not possible to correctly display the field with HTML formatting in the printable.  

We registered a query for our R&D team and await a fix in the upcoming versions. 

As a workaround suggestion, you can replace the Notes field with a simple text field. I understand that it's missing the format settings and cannot be applied to tables, but it should work for a sentence or two simple comments. 

Thank you for making Creatio better!

Здравствуйте,

К сожалению, в приложении нет возможности отображать значения полей в отчете на языке, отличном от текущей локализации пользователя, а так же делать отчеты на разных языках (чтобы можно было выбрать язык значений полей, отображаемые в отчете (независимо от локализации) во время создания отчета).

Все значения в отчете будут отображаться на языке текущего пользователя.
Чтобы значения печатались на английском или другом языке, необходимо сделать соответствующие переводы в системе и изменить локализацию пользователя на английский или другой язык соответственно. Затем значения будут подтянуты в отчет на выбранном языке.

Распечатать сам отчет или значения в нем на языке, который не установлен для текущего пользователя, пока невозможно.

При этом задача по добавлению этого функционала уже передана ответственной команде. 

Hello, 
 
Thank you for your question. In order to implement your business task, you need to perform the following steps: 

1. You need to implement source code of a macros, you can find out how to do it in more detail in the following article: 

https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/platform-customization/classic-ui/ms-word/examples/create-ms-word-report-custom-macros 

2. In the source code of this macros, you need to implement the following changes, which will receive a localized value from database: 
 
var sysCulture = new SysCulture(_userConnection); 

                if (!sysCulture.FetchPrimaryInfoFromDB("Name", "ru-RU")) 

                { 

                    return "No culture found"; 

                } 

                Guid russianCultureId = sysCulture.Id; 

                esq.SetLocalizationCultureId(russianCultureId); 

... 

if (entities.Count > 0) 

                { 

                    Entity entity = entities[0]; 

                    var type = entity.GetTypedColumnValue<string>(columnType); 

                    return type; 

                } 

                return String.Empty; 
 
 
 
You can learn more about how to work with localized values in the article: 
 
https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/back-end-development/localizable-resources/operations-with-localizable-resources/examples/retrieve-localizable-resources-from-the-database 

Hello,

Unfortunately, there is no such option at the moment. 

However, we understand that this is not ideal for your specific needs.

We want to assure you that we have created a request for our development team to implement this functionality in future versions of our application. We understand the importance of providing our clients with the best possible experience and will work hard to implement the changes you have suggested.

Thank you again for bringing this to our attention, and please do not hesitate to reach out if you have any further questions or concerns.
However, we understand that this is not ideal for your specific needs.

 

Halyna Parkhomenko writes:

Hello,

Unfortunately, there is no such option at the moment. 

However, we understand that this is not ideal for your specific needs.

We want to assure you that we have created a request for our development team to implement this functionality in future versions of our application. We understand the importance of providing our clients with the best possible experience and will work hard to implement the changes you have suggested.

Thank you again for bringing this to our attention, and please do not hesitate to reach out if you have any further questions or concerns.
However, we understand that this is not ideal for your specific needs.

 

Thanks for the info! Is there an ETA on when the feature might be available? Also something like "not in the next x versions" would already be of help!

Thanks,

Robert

Robert Pordes,

Unfortunately, there is no ETA at the moment, but we have increased the priority of this implementation with your case.

Have a great day!

Best,

Alina

Hello!



I'd suggest to approach the support team via support@creatio.com to have a closer look at the error.

It is hard to determine the root cause without having the access to the Word plugin itself. 

Thank you,

Kate

Hi,

it seems that you are trying to add the macro straight from the table column. In this case, such scenario should be changed.

Please, make sure you added the column to the "Set up report data" section in your Report template in Creatio before you add this column to the report template in Word, then in Word you will have to find this columns in the list and drag it to the field where you need it.

For example, if now the macro looks something like "Object1.Column1.Currency", then you need to go to your Report in Creatio and add the column in such way:

- Set up report data -> "+"

- Object1 -> "+"

- In the second field you need to find your Column1

- In the last window you should have a list from the Column1 and there you should be able to find your Currency column.

In this case, it should work fine.

Regards,

Gleb.

Thank you for your replay.

Yes, we have created VIEW and added this object as report table.

And if report is based on Order, a lot of Order's calculated fields are taken from VIEW.

When we add 'Currency' field to the 'report data', it realy works - thank you.

But we also have some fields, that are calculated in VIEW, so they cannot be added to the 'report data', only to 'report table'. As I understand, they cannot be used in other table header?

And only option is to add new field to Order object, calculate and store this value in the object?

Kind regards,

Vladimir

Vladimir Sokolov,

if the field is calculated in View, it cannot be added to the header, I'm afraid.

However, you can try to add another field to your object and simply populate it with the value from the second field. In this case, it should work fine.

Regards,

Gleb.

Gleb,

Thank you!



Would be nice to have Word reports based not only on Section, but on any other objects, also objects on View

Hello,

As for now, unfortunately, there is no possibility to use word formulas in compose with printables and our R&D team has a problem regarding this functionality and we hope that it will be updated in one of future versions of the application. 

As for now you can try using this marketplace application that can fit your needs https://marketplace.bpmonline.com/app/excel-reports-builder-bpmonline.