Post reply

Matrix with fixed number of columns

  • August 11, 2008 at 6:25 am

    #190924

    I am facing a problem, were if my matrix expands beyond 10 columns, it starts generating remaining columns on new page without displaying its header details.

    Is it possible to restrict a matrix up to certain number of columns?

    For Ex.. If my matrix crosses 10 columns, either it should stop displaying remaining data...

  • August 11, 2008 at 6:50 am

    #856042

    yes, it is.

    one solution is to redesign the report. instead of doing the matrix in the report, do it before the report, in sql, using the PIVOT clause (if you post your sql query here, i, or any number of people here, can help you rewrite it). once you've got your table pivoted, you can INSERT it into a temp table, then SELECT that temp table (with the 10 columns you want) and pass that data set to your report. viola! 10 (and only 10) columns of data.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply