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)
 Drill-Down

Author  Topic 

mikebird
Aged Yak Warrior

529 Posts

Posted - 2008-08-19 : 05:11:27
I'm a Crystal guru, stifled by SSRS. OK

Asked to expand a current report where grouped rows are shown red on particular conditions, and it's wanted to have a breakdown for these, so open up and show real rows under these red conditions. Can do this with my back turned in Crystal Reports. hehe

However, in this case it's all PDF output, so no interactivity - good and bad. It's not really drill-down, is it? Set the conditions and show the rows...

All I can see in these ghastly properties is RED when a group is shown but whn the report is run, some results are red, some black. Can you tell me when I can find the conditions / parameters are set above or below this magic figure or equation while reading records or something, which I can translate further than just making red, and display the rows?

Thanks a lot!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-19 : 05:27:35
the color can be changed by setting an expression for color property. some thing like
=IIF(Inscope("group1name"),"Red","<Othercolorname")
the hierarchy data can be shown by seting the toggle property for lower real data based on higher level data report item. Also give default behaviour as expanded.
Go to Top of Page
   

- Advertisement -