locked
columns order reverses in matrix when exported to excel RRS feed

  • Question

  • Hi eb

    I haver a simple matrix with header that holds description for every column

    in matrix. Lets say header looks like:

    col1Desc col2Desc col3Desc.

    My problem: when report is exported to pdf or excel columns order reverses! so now it is:col3Desc col2Desc col1Desc

    The only workaround i found to keep columns headres in place was to place header in a table on top of matrix.

    This is fine but now matrix itself has no header so i can't display the columns header in every page of the report just on the first one..

    I would very much appriciate a hint for solving any of these problems

    either prevent columns reverse in matrix header when report is exported

    or some how force the column to appear on top of each page

    when contained in a separate table.

    Thanks alot!

    Rea

     

     

    Tuesday, October 12, 2010 11:14 AM

Answers

  • Try to use ORDER By clause in your query or set sorting property in you matrix.
    • Proposed as answer by Jerry Nee Thursday, October 14, 2010 2:01 AM
    • Marked as answer by Jerry Nee Thursday, October 21, 2010 1:49 AM
    Tuesday, October 12, 2010 11:21 AM