Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Change Report Header Content based on Table Grouping
Vishnupriya
<p>hi,</p><p>Is it possible to change the Report header content when the value of a Table Grouping field changes..<br />
The default behavior is that when a Grouping field data changes, it can be shown as a Subheader in the Table. But I want to change the contents of my report header based on the Table Grouping Data field.</p><p> </p><p>pls consider this example</p><p> </p><p>1. Data Set</p><p> </p><p>Category | Food | Color | Name | Produce |Export Qty<br />
<br />
Natural | Fruit | Red | Cherry | 53 | 12<br />
Natural | Fruit | Red | Apple | 43 | 14<br />
Natural | Fruit | Orange | Orange | 78 | 22<br />
Natural | Veg | Green | Spinach | 43 | 8<br />
Artificial | Bread | White | Burger | 89 | 29</p><p> </p><p> </p><p>2. I need the generated output pdf to be of this format</p><p> </p><p>[color=#0000ff;]<strong>PAGE1</strong>[/color]<br />
Summary Report <strong>Category: Natural</strong><br />
Sub Title <strong>Type : Fruit </strong><br />
+++++++++++++++++++++++++++++++<br />
Name | Produce | Export Qty +<br />
+++++++++++++++++++++++++++++++<br />
RED<br />
<br />
Cherry | 53 | 12<br />
Apple | 43 | 14<br />
_______________________________ <br />
ORANGE<br />
<br />
Orange | 78 | 22<br />
_______________________________<br />
<strong>Total </strong> 174 48<br />
<strong>Fruit</strong></p><p> </p><p><strong>[color=#0000ff;]PAGE2[/color]</strong><br />
Summary Report <strong>Category: Natural</strong><br />
Sub Title <strong>Type : Veg </strong><br />
+++++++++++++++++++++++++++++++<br />
Name | Produce | Export Qty +<br />
+++++++++++++++++++++++++++++++<br />
GREEN<br />
<br />
Spinach | 43 | 8<br />
_______________________________<br />
<strong>Total</strong> 43 8<br />
<strong>Veg</strong><br />
_______________________________ </p><p><strong>Total </strong> 217 56<br />
<strong>Natural</strong><br />
_______________________________ </p><p> </p><p><strong>[color=#0000ff;]PAGE 3[/color]</strong><br />
Summary Report <strong> Category: Artificial</strong><br />
Sub Title <strong>Type : Bread</strong> <br />
+++++++++++++++++++++++++++++++<br />
Name | Produce | Export Qty +<br />
+++++++++++++++++++++++++++++++<br />
WHITE<br />
<br />
Burger | 89 | 29<br />
_______________________________<br />
Total 89 29<br />
Bread<br />
_______________________________<br />
Total 89 29<br />
Artificial<br />
_______________________________ </p><p> </p><p> </p><p> </p><p> </p><p>Thanks,</p><p>Vishnupriya</p>
Find more posts tagged with
Comments
BRM
<p>Just use a multi-line group header and don't use the table header</p>