I'm working on drill down functionality in SSRS report with reference to tututial given at http://ssrs2008.blogspot.in/2010/09/creating-drill-down-report-with-sql.html
But I'm getting error
Toggle items must be textboxes that share the same scope as the hidden item or are in a scope that contains the hidden item , and cannot be contained within the current report item unless current grouping scope has a Parent.
How can i overcome this issue? Please suggest.
I had the same error after deleting a Row Group (Group16).
[rsInvalidToggleItem] The grouping ‘Group17’ has ‘Group16’ as a toggle item. Toggle items must be text boxes that share the same scope as the hidden item or are in a scope that contains the hidden item, and cannot be contained within the current report item unless current grouping scope has a Parent.
Resolved the issue by doing the following:
Try it.
I had the same problem, but I figured that I changed the wrong group properties:
Step 4: From Row groups > select Product group details (group Details and not group header) > go to Group Properties > select Visibility tab > select Hide > click on Display can be toggled by this group item and select the name of the group then click on OK
Once I change the settings for the group details it worked fine!
rg
i think thats is the visible problem
The grouping ‘Group17’ has ‘Group16’ as a toggle item. Toggle items must be text boxes that share the same scope as the hidden item or are in a scope that contains the hidden item, and cannot be contained within the current report item unless current grouping scope has a Parent.
Try This :
Enable Advanced Mode by clicking the rightmost down arrow above the Column Groups window.
In the Row Groups window, Right Click at ‘Group17’ > Group Properties
In the Properties Window, go to Visibility tab
Checklist the 'Display can be toggled by this report item:'
than chose the group of the first data example 'Purchase ID'
click ok. see thats problem is solved.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With