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

#1696 - Calculated Fields Usage

Closed General Question created by raskew 3 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

    3 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.

    Regards,

    Anabel

  2. raskew member avatar

    raskew

    3 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...
Rating

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.