Drilldowns

I have a list of items. Some of the items would be a good candidate for the
drilldowns because the item name is the same. How can I only enable the
items with the same item name to be group together with a drilldown?I am not sure I truly understand your question, but I'll give this a stab
Create a grouping within your table. and Group on the name. Add the Name
field to the group header row. Select the Detail row and set the visibility
hidden to true, and choose the textbox with the group value (from the group
header) as the toggle item.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"David" wrote:
> I have a list of items. Some of the items would be a good candidate for the
> drilldowns because the item name is the same. How can I only enable the
> items with the same item name to be group together with a drilldown?|||I created a sample RDL which does what you want, and posted it on
www.msbicentral.com, it is in the downloads section
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"David" wrote:
> I have a list of items. Some of the items would be a good candidate for the
> drilldowns because the item name is the same. How can I only enable the
> items with the same item name to be group together with a drilldown?