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)
 Expanding groups on bookmark selection

Author  Topic 

harlingtonthewizard
Constraint Violating Yak Guru

352 Posts

Posted - 2008-10-01 : 01:14:40
I have two tables on a report layout each with there own query and hence dataset. Each table contains a row of data with three group headers. Each header from header group 1 through to the row are set as collapsed by default. The groups are set to hidden via row with a field/cell from the group above used to expand. My question is if you have expanded to say group 2 in the first table and everything is collapsed in the second table and a bookmark is set via the eventid.value can you make it jump between tables to the bookmark cell and expand to the correct cell. At the moment it seems to jump to the correct table but not expand to the correct cell in the second table. The cell of interest is the same data in each table, eventdetails.eventid. SQL2005.
   

- Advertisement -