SQL Server Reporting Services - SQL Server Forums

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

SSIS and Import/Export (2005)

SQL Server Reporting Services

Author

Topic

Dev@nlkss

134 Posts

Posted - 2009-01-03 : 00:27:15

Hi All,
Can Anybody tell me how to merge the cells in report when i use table control and group clause.
Thanks in advance.

Satya

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-03 : 06:58:24

merge the cells? for what? for grouping you just need to right click on row and choose add group from menu.
for merging cells you just need to select multiple cells, right click and choose merge cells.

Dev@nlkss

134 Posts

Posted - 2009-01-04 : 23:26:23

I have to display as follows

ProductName1
Jan-08
item1Sale item2Sale item3Sale
item1Sale item2Sale item3Sale
Feb-08
item1Sale item2Sale item3Sale
item1Sale item2Sale item3Sale

ProductName2
Jan-08
item1Sale item2Sale item3Sale
item1Sale item2Sale item3Sale
Feb-08
item1Sale item2Sale item3Sale
item1Sale item2Sale item3Sale

For The ProductName of each distinct group i want to merge all the cell vertically which includes all the months(another group) and its items same for each month which includes all the items in that month
Am I clear.

Satya

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources