reporting service repeating tabular, matrix

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

reporting service repeating tabular, matrix

Author

Topic

vamp81
Starting Member

2 Posts

Posted - 2009-02-03 : 23:20:12

hi, i'm new to SSRS, currently using 2005 reporting service. first of all sorry if i hv posted this in the wrong thread. i hv been trying to make a report using tabular and repeating the table accross 1 page til is it full. i hv tried this on matrix also but it doesn't seems to work :

Sample report that i would like to make.

IT dept                       F&B Dept
name tel extention         name2 tel2 extention2
name1 tel1 extention1         name3 tel3 extention3
                                    name4 tel4 extention4

Operations Dept               Management dept
name5 tel5 extention5         name6 tel6 extention6

Sample report i try to make using tabular : unable to bring up the details, to fill up an A4 page(right side, landscape base)

IT dept
name tel extention
name1 tel1 extention1

F&B Dept
name2 tel2 extention2
name3 tel3 extention3
name4 tel4 extention4

Operations Dept
name5 tel5 extention5

Management dept
name6 tel6 extention6

sample report i try to make using matrix : second line details and onwards are not showing.and also the matrix is not repeated.

IT dept F&B Dept Operations Dept

name tel extention name2 tel2 extention2 name5 tel5 extention5

is this possible to be done? does tablix (reporting service 2008)would enable me to do this.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-02-07 : 09:35:51

isnt it just matter of providing four levels of grouping in your table and also bring data consolidated to various levels from table?

vamp81
Starting Member

2 Posts

Posted - 2009-02-11 : 01:44:50

well i have group it according to department and the detail of it is 4 different fields.
the grouping is successful but then the layout of the grouping was not able to be alignment as sample 1.

so back to my original question would SSRS 2008 (Tablix) be able to enable the layout of grouped fields as sample 1

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources