Mail Merge Reports

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 9 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?

Izertis Provider
9 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

reply
raskew
9 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.

reply