Cross-tab; how-to repeat master data on each line
artiscommunications
Montr?©al, Canada
Hello,
In a multi-level cross-tab report, the master fields which generate lines are only shown once.
Is it possible to let it be simply repeated on each lines, like this?
I know this is not necessarly interesting but, the client want the cross-tab report exported in Excel and want to be able to apply filters on any columns. And, for a filter to work properly in Excel, the data must be repeated on each lines. [img]style_emoticons/<#EMO_DIR#>/unsure.gif" style="vertical-align:middle" emoid=":unsure:" border="0" alt="unsure.gif" /> Thanks for your help. Regards, Jacques[/img]
In a multi-level cross-tab report, the master fields which generate lines are only shown once.
Is it possible to let it be simply repeated on each lines, like this?
I know this is not necessarly interesting but, the client want the cross-tab report exported in Excel and want to be able to apply filters on any columns. And, for a filter to work properly in Excel, the data must be repeated on each lines. [img]style_emoticons/<#EMO_DIR#>/unsure.gif" style="vertical-align:middle" emoid=":unsure:" border="0" alt="unsure.gif" /> Thanks for your help. Regards, Jacques[/img]
Comments
it actually produces merged cells when exported to xl.
however they can be edited in xl.
select the cell then set the format unchecking the merge cell options, then copy the cell and paste into desired range.
I'll look into it.
Regards.