Is it possible to create a named query in the DSV that is the result of a pivot (e.g. cross tab?). The number of columns as a result of the pivot are based the number of records in one of the driving tables - in other words, it is not fixed.
You got to go dynamic SQL and use some fancy report datasets and expressions to display or not the columns.
Then you would have to create a report were you define as many columns as possible and control the visibility of these columns based on some expression stored in the Column Visibity hidden property.
Lot of work. May be you would be better off sourcing your report out of a cube.
Philippe
No comments:
Post a Comment