by Izertis

Create documents in docx, xlsx (MS Office Word and Excel), odt, ods (LibreOffice and OpenOffice) and pdf format without MS Office or others plugins installed from any module and subpanel using templates.

Includes a 30 day guarantee
Try it Now

By clicking you consent to share your profile with the developer

#1696 - Calculated Fields Usage

Closed General Question created by raskew 6 years ago

I have subpanel data that I need to segment in a report based on the type of one of the field. Each row in the panel has a column that I can use to filter the data. I undestand how to filter data using the BeforeMergeBlock. However, the filtered data must be rendered on separate pages. For example: High Priority panel rows in the High Priority Page. Medium Priority panel rows in the Medium Priority Page and Low Priority panel rows in the Low Priority Page. Is, there a way to capture the rows as Calculated Fields and if so, how would you render each section in the subsequent page blocks?

  1. dharma member avatar

    Izertis Provider

    6 years ago

    Hi there,

    Yes, there is. I am going to send you a template that works as you need by email. It is necessary to repeat the subbloque declaration as many subpanels you have, for example: [a;block=w:body;sub1=contacts;sub2=contacts;sub3=contacts;sub4=contacts]

    Let me know please if the template works when you test it.



  2. raskew member avatar


    6 years ago

    Thank you Anabel for your assistance. I was able to generate the report as you suggested. The email that you sent was very helpful.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
  • "The single biggest downfall of the community edition of SugarCRM or SuiteCRM is the lack of creating a report form a custom module for a single event...." - ian

    Read More Reviews