Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Change Report Header Content based on Table Grouping
Migrateduser
<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
There are no comments yet