cancel
Showing results for 
Search instead for 
Did you mean: 

XLReporter hide repetitive field

Former Member
0 Kudos

Does anyone know how to hide repetitive fields in XLReporter ? For example I want my report to look like this ;

Product group Item Number Whse code Qty on hand

-


GROUP1 A0001 01 25

A0002 02 10

A0004 01 10

GROUP2 B7778 01 5

A0002 02 2

.

.

.

Currently my report repeats the group code on each line.

Thank in advance

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Why didn't you do a grouping in the Report Composer with Totals? That is the easiest solution.

Jim

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Agree with JIM.

rgds,

Premraj

Former Member
0 Kudos

Since XLR is Excel based application, you can take advantage of Excel to achieve it. A conditional formula is all your need. To hide a cell, you could make the font with white color. Formula is easy to set up because you just need to check if the column value for GROUP changed or not.

Thanks,

Gordon