Report Analysis Services 2008 Olap

Good afternoon,

I ne开发者_StackOverflow中文版ed to display the information splitted in columns in Analisys services 2008 OLAP report as follows:

IdNumber Name  LastName  IdNumber Name  LastName  IdNumber  Name   LastName
1        Ana   Perez     3        Pedro Perez     5         Carlos Perez
2        Jose  Jose      4        Carlo Carlos    6         Ana    Rijo

Any ideas?

Thanks.

---

It looks what you are trying to achieve is a "newspaper-style" report.

This is possible in Reporting Services 2008 (and also in 2005).

See "How to: Create a Newsletter-Style Report" from SQL Books Online for complete instructions, but basically you need to set the Columns property of the Report to indicate how many columns you wish the report to have.

Also note the restriction that only the Image and PDF renderers support newsletter-style layout. Other renderers just render the output as a single column