repeat break column value on each line

building reports webintelligence
1

Hi,
Is it possible to repeat the break value on each row instead of getting it on the header and footer of the break or at the center? My report will be downloaded to excel and filtering will be an issue for merged/ rows with null value. Also I donÂ’t want a hidden column as the same will appear on excel.

Thanks,
Sbhusan

sbhusan :canada: (BOB member since 2006-06-26)

2

Hi sbhusan,
Remove duplicate values,
Center Values across break
When you click on the column break is applied and select the properties on left side,then expand the Breaks section… there you will find these option to apply for breaks.

GNK_BO (BOB member since 2007-07-17)

3

Yes, simply set the attribute on the break. By default the “Remove Duplicates” option is marked. Open the properties tab, select the break, and remove that checkbox and it will repeat the value on each row.

[edit - GNK_BO beat me to the answer :slight_smile: ]

Dave Rathbun :us: (BOB member since 2002-06-06)

4

thanks guys …i didn’t try that option as the wording is bit misleading…“remove duplicates”.

sbhusan :canada: (BOB member since 2006-06-26)