| Author |
Topic |
|
1kingstonr
Starting Member
7 Posts |
 Posted - 2009-10-01 : 08:16:03
|
| I have a simple report with one group.I need to show each group in different table.like below col1 col2 Group1 id test1 id test2 col1 col2Group2 id1 test1 id2 test2The above two group should be in two different table.I saw there is anoption for page break for groups,But I need to know how to break groups in different tables. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-01 : 15:30:36
|
| keep the table inside a matrix with row group set as your grouping field and adding required columns in table. then check option place a page break after table |
 |
|
|
1kingstonr
Starting Member
7 Posts |
Posted - 2009-10-02 : 10:49:20
|
| Visak thanks.I tried your suggestion,Not able to find page break after table.ALl i see is page break and all the groups are coming in different pages.can you pl tell me how to do a break on table Thankskingston |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-02 : 11:01:52
|
| you've an option to insert page break after table. right click on left hand corner of table and view properties to find it |
|
|
|
1kingstonr
Starting Member
7 Posts |
Posted - 2009-10-02 : 12:04:42
|
| sorry I am using ssrs 2008 there they show just insert after anyhow i done that but still it's not giving a space after the group.It just shows everything in one table. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-02 : 12:20:23
|
| can you try putting table inside matrix column and adding your reqd columns inside. retain your current group expression in matrix |
|
|
|
1kingstonr
Starting Member
7 Posts |
Posted - 2009-10-02 : 13:26:09
|
| I tried adding in column but that one just displays the detail not show with grouping result.I tried to Include row below the group(empty row).It shows the space break in detail but not in the group. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-02 : 13:54:44
|
| have you given aggregate expressions in table? |
|
|
|
1kingstonr
Starting Member
7 Posts |
Posted - 2009-10-02 : 14:15:40
|
| No.Here I am not aggregating. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-03 : 14:36:29
|
| but you need to since it happens inside matrix group |
|
|
|
1kingstonr
Starting Member
7 Posts |
Posted - 2009-10-05 : 10:06:26
|
| HI,I treid Aggreate also but it doesn't help.all comes in the same table. |
|
|
|
1kingstonr
Starting Member
7 Posts |
Posted - 2009-10-05 : 14:04:29
|
| Hi visak,I got it.first i wrongly tried the aggregate.Thanks a lot for your tips. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-05 : 14:25:38
|
welcome  |
|
|
|
|
Break by group