Cross-tab; how-to repeat master data on each line

artiscommunicationsartiscommunications Montr?©al, Canada
edited 3:26AM in FastReport 4.0
Hello,

In a multi-level cross-tab report, the master fields which generate lines are only shown once.

fast-report-cross-tab.jpg

Is it possible to let it be simply repeated on each lines, like this?

jyb-cross-tab.jpg

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

  • gordkgordk St.Catherines On. Canada.
    edited 3:26AM
    unfortunately no.
    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.
  • artiscommunicationsartiscommunications Montr?©al, Canada
    edited 3:26AM
    Thanks for the info.
    I'll look into it.

    Regards.

Leave a Comment