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.
| Author |
Topic |
|
hungyeetan
Starting Member
8 Posts |
 Posted - 2005-09-07 : 03:42:29
|
| After report is generated, Can we Just Drag And Drop the Column And Rows. For example we wan to Drag the Column Item to Rows. |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-09-07 : 12:52:34
|
| What you're talking about is called a Pivot Table. Reporting Services does not do this natively, but Excel can do it, and you can export from Reporting Services to Excel and then create the Pivot Table from the data you just exported.On the other hand, you might want to just have Excel query the data source directly. This allows you to design the Pivot Table once in Excel, and then it can refresh the display from the data source on command. In Excel see the Data Menu.---------------------------EmeraldCityDomains.com |
 |
|
|
|
|
|
Drag And Drop the Column And Rows