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

Harry,

can you please go to the Workplace setup, delete any existing Section, save, then add it again along with the Mailbox section?

Please, let us know whether it helped.

Kind regards,

Gleb.

Hi Gleb,

Thank you for the suggestion, it is appreciated.

We have attempted your solution and unfortunately it doesn't resolve this issue.

Any other potential solutions are appreciated.

Dear Harry,

unfortunately, it is difficult to analyze the problem in such a way.

I would recommend creating a case for the Support team so we can take a closer look at the issue.

Regards.

Gleb.

Hi,

If you want to add a photo to your custom section then there is instruction on how to do it.

Take a look at this conversation, there you can find an article and example.

Hello,



Please contact our support team (support@creatio.com) for further investigation. 



Best regards,

Bogdn

Hello,

The object "BaseObject" has those fields ("MdrName") and if your object was inherited from "BaseObject" it must have had those fields in inherited columns. If your object doesn't contain those fields, those fields must have been removed.

Please try to update database structure, generate the source code for all and compile all in the configuration section.

Hi Adriana, 

You can create VIEW in the database (Access rights to Contact are stored in the table SysContactRight) and object based on that view. Then you can use this object for report or for tagging records.



A little bit more complicated situation is when record has access rights for group (e.g. All Employees). That means that this record is shared with more users and you need to calculatate all of them

 

Hello Vladimir

Thank you so much for your reply, I have also consulted internally and I got the same solution so I guess thats the best alternative!

Hello,



Please make sure that portal users have access to your web service.

More details on the academy website:



https://academy.creatio.com/docs/developer/application_components/porta…



https://academy.creatio.com/docs/developer/application_components/porta…

Cherednichenko Nikita,

I have followed the provided academy pages. Though when trying to compile, I receive the errors.

" The type or namespace name 'SspServiceAccess' could not be found (are you missing a using directive or an assembly reference?)"

"The type or namespace name 'SspServiceAccessAttribute' could not be found (are you missing a using directive or an assembly reference?)"

Try to generate source code for all schemas and run compilation again.

After generating source code for all schemas and compiling again, I am still receiving the same errors. Is there a namespace I am missing?

namespace Terrasoft.Configuration.KeenGlbInterviewService
{
	using System;
	using System.IO;
	using System.Collections.Specialized;
	using System.Globalization;
	using System.Runtime;
	using System.Runtime.Serialization;
	using System.ServiceModel;
	using System.ServiceModel.Web;
	using System.ServiceModel.Activation;
	using System.Threading;
	using System.Threading.Tasks;
	using System.Web;
	using Terrasoft.Core;
	using Terrasoft.Core.Factories;
	using Terrasoft.Configuration.GlbInterviewService;
	using Terrasoft.Web.Common;
    using Terrasoft.Web.Common.ServiceRouting;
 
	#region Class: KeenGlbInterviewService
 
	[DefaultServiceRoute] 
	[SspServiceRoute]
	[SspServiceAccess(nameof(BatchQuery))]
	[ServiceContract]
	[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Required)]
	public class KeenGlbInterviewService : BaseService
	{
 
		#region Methods: Public
		private static readonly GlbInterviewService _baseService = new GlbInterviewService();
 
		[OperationContract]
		[WebInvoke(Method = "POST", RequestFormat = WebMessageFormat.Json, ResponseFormat = WebMessageFormat.Json)]
		public InterviewServiceResponse Start(InterviewServiceRequest request)
		{
			return _baseService.Start(request); 
		}
 
		[OperationContract]
		[WebInvoke(Method = "POST", RequestFormat = WebMessageFormat.Json, ResponseFormat = WebMessageFormat.Json)]
		public InterviewServiceResponse Complete(InterviewServiceRequest request)
		{
			return _baseService.Complete(request);
		}
 
		#endregion
 
	}
 
	#endregion
 }

Please see another community post:

https://community.creatio.com/questions/call-web-service



Perhaps there is an answer to your question.

Cherednichenko Nikita,

Thank you for the recommended page. However I have already looked through this page and it makes no mention of using SspServiceAccess which is the piece I'm having difficulty with.

Hello Susan,

Your business task can be achieved via custom business process. You'd need to use [Process file] and [Send email] elements to achieve this business task. 

More detailed information about these elements can be found on our Academy:

https://academy.creatio.com/docs/user/bpm_tools/process_elements_refere…

https://academy.creatio.com/docs/7-17/user/bpm_tools/process_elements_r…



Best regards,

Anastasiia

Hi Adharsh,

you can try such a script, just use names of DCM you want to deactivate:



Update "SysSchemaProperty"

Set "Value" = false

WHERE 

    ("SysSchemaId" IN

        (SELECT s."Id" 

        FROM  "SysSchema" s 

        WHERE s."Name" IN ('DocumentCase','ContractCase')

    )



​​​​​​​Kind regards,

Vladimir

Vladimir Sokolov,

I could see 6-8 records when we run the query. As "SysSchemaProperty" contains many records for each SysSchemaId of different properties. Which column should be updated to "False".



Also I have attached below the image for reference which is the query result of deactivated DCM Case in local development environment. I could not able to find any column with value as "False".



Image -1 : "Result query of deactivated 'LeadCase' DCM"

Image-2: "Result query of newly activated 'LeadFlowCase' DCM"





Result of both queries seems to be similar. Not major difference. Initially I thought, Enabled property defines the Active/InActive state of DCM case. But in this case both values are True.



Kindly help us with it.



Best Regards,

Adharsh S

Adharsh writes:

Yes, you are rights. Enabled property should be set to false.  



... AND "Name"='Enabled'



But I don't know why they both are Enabled if one of them is deactivated.

Also I see in our project, that Enabled property for LeadCase didn't exist in production enviroment, so script just adds new one:



INSERT INTO "SysSchemaUserProperty"

("Id","Name","Value","SysSchemaId")

VALUES 

('0a16d853-9e01-4544-8a6f-3ebde5d3bbed','Enabled',false,'4944ebb5-1881-46a9-85df-b93d092424ad')

ON CONFLICT DO NOTHING

Vladimir Sokolov,

Thanks for it. I am able to deactivate the existing OOTB - Lead case stages. But the columns "Which column to build the stages by?" and "Which column determines which case to use with a record?" are not updating, Retains the same state. 



Ref Image,





Kindly help us, how to update these values! Am I missing any other thing?



Best Regards,

Adharsh S

Adharsh,

You should find SysDcmSettings in bound data (the easiet way to to find by Modified On date) and set 'Forced update' for column Filters. 

I think it can help

Kind regards,

Vladimir

Hello Joseph, 

This function is not available for the Pivot tables as mentioned in this academy article.

This function is available only  for business rules. 

Best regards,

Anastasiia