I want to create an APEX report or table that has 2 sheets on the same report and extract it as 2 sheets in the same excel

19 views Asked by At

I want to create an APEX report or table that has 2 sheets on the same report and extract it as 2 sheets in the same excel , how to make something like that as in detailes as i am new to apex

i have tried to make it but it doesn't work

1

There are 1 answers

0
Koen Lostrie On

Apex has a component called "Region Display Selector". That is a native component that allows regions on the same page to be shown/hidden with a tab. Here is an example in the Universal Theme. So for your requirement, a simple solution is to create 3 regions

  1. Region 1: Type "Region Display Selector"
  2. Region 2 and 3: Type: (depending on your requirments) Classic Report/Interactive Report/Interactive Grid with attribute Advanced > Region Display Selector: "On"