I am trying to create a basic printable report that includes data from Section as well as the detail of that section

 

and I have created the template in Word,

 

and the report setup in creatio is as below,

But the output only has data from the main section but not from the detail,

Can you please help with this?

Like 0

Like

0 comments
Show all comments

Dear Creatio Team,

I am working on Creatio reports using FastReport. It is required to create tables inside rich text of Fast report and upload frx file to generate the output. But the output doesn't show the table in the rich text as it gets shrunk to a single cell every time. I have attached the snapshot of the RTF table in the fast report and its output in creatio.

RTF Table

Creatio output of this table

It can be seen in the output file that all 6 cells of the table are shrinking to a single cell. Is there any problem with the RTF code or in Creatio Fast report integration.I have attached the RTF code used to build this table in the Fast report.Please provide a solution to my query.

File attachments
Like 0

Like

4 comments

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?

Show all comments

Is there a way to make a certain report export automatically on a schedule? Any marketplace add on's anyone is aware of that would accomplish this?

Like 0

Like

1 comments

Dear Mitch, 

An option how you can do it is to send it as an email instead of downloading it. You can create a process that would start on a timer and email you (or any person needed) the report. Here is the community article on how to do that: 
https://community.creatio.com/articles/generate-printable-and-send-it-a…

Best regards,
Dennis 

Show all comments

Hi,

There is an error message which occurring on save of script in report designer.

I'm not sure what is missing. Any help will be highly appreciable.

 

Regards

Like 0

Like

2 comments

it's hard to say what's wrong by the screenshot. Somehow the system can't find the report schema. Try to find an answer in the development guide

https://academy.bpmonline.com/sites/default/files/documents/docs_en/technic/SDK/7.10.0/bpmonline_development_guide.pdf

Eugene Podkovka,

Thanks. Its already resolved

 

Regards

Show all comments