Drill down display issue

Question

Post reply

Drill down display issue

WayneS

SSC Guru

Points: 95460
More actions
June 5, 2008 at 11:53 am

#380921

Report has grouping rows. Visibility is set to visible on all rows, and visibility can be toggled by parent row.
When displaying the report, it shows the drill-down icon as [+], even though the row is visible. If you collapse the row, the icon shows [-]. In other words, it's not considering the initial visibility of the row(s) under it that it toggles.
Is there any way to make this appear correctly?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 1

There is another property on the toggle item. It is toggle state or something like that.

WayneS SSC Guru Points: 95460 More actions · Answer 2

Okay, I found it.

On the item that toggles the visibility, on IT'S visibility tab you can set it's initial appearance of the toggle icon to [+], [-], or use an expression.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2