Drilldown in RS?

I have structure like this:
A1
B1
C11
C12
C13
B2
C21
C22
A2
Currently, I set up so at C level, it will appear only if its value > 0. I
would like to have a drilldown structure so when I click on A level, B level
will appear but not the Cx. B will have the + only if it has child items (if
one of its child items has value > 0). If B has the + sign, it indicates it
has child items and when I click on the + sign, the C level appear only if
its value >0.
Please advice if this is doable (please show how) or this is a no-no in RS.
ThanksAlthough I have never done exactly what you wish , I think it is doable...
Set C to initially Visible = false
Set A as the Visibility Toggle for B
Set B as the Visibility Toggle for C, AND use an expression for the initial
appearance of the toggle item
All of this is set in the Advanced Textbox properties.
Good luck... This sounds nice!
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John R" <JohnR@.hotmail.com> wrote in message
news:uyXGnAIEFHA.624@.TK2MSFTNGP15.phx.gbl...
>I have structure like this:
> A1
> B1
> C11
> C12
> C13
> B2
> C21
> C22
> A2
> Currently, I set up so at C level, it will appear only if its value > 0. I
> would like to have a drilldown structure so when I click on A level, B
> level will appear but not the Cx. B will have the + only if it has child
> items (if one of its child items has value > 0). If B has the + sign, it
> indicates it has child items and when I click on the + sign, the C level
> appear only if its value >0.
> Please advice if this is doable (please show how) or this is a no-no in
> RS. Thanks
>|||I tried this before I posted initially but it didn't work. The toggle always
switches the hidden state of items. So if an item has the hidden initial
state set to false, toggle will set it back to true and it doesn't take the
expression into account. What I'm looking for is a way to set the toggle
item in a expression, not statically assigned..
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23c3GSSqEFHA.2756@.TK2MSFTNGP15.phx.gbl...
> Although I have never done exactly what you wish , I think it is doable...
> Set C to initially Visible = false
> Set A as the Visibility Toggle for B
> Set B as the Visibility Toggle for C, AND use an expression for the
initial
> appearance of the toggle item
> All of this is set in the Advanced Textbox properties.
> Good luck... This sounds nice!
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "John R" <JohnR@.hotmail.com> wrote in message
> news:uyXGnAIEFHA.624@.TK2MSFTNGP15.phx.gbl...
> >I have structure like this:
> >
> > A1
> > B1
> > C11
> > C12
> > C13
> >
> > B2
> > C21
> > C22
> >
> > A2
> >
> > Currently, I set up so at C level, it will appear only if its value > 0.
I
> > would like to have a drilldown structure so when I click on A level, B
> > level will appear but not the Cx. B will have the + only if it has child
> > items (if one of its child items has value > 0). If B has the + sign, it
> > indicates it has child items and when I click on the + sign, the C level
> > appear only if its value >0.
> >
> > Please advice if this is doable (please show how) or this is a no-no in
> > RS. Thanks
> >
>|||VNN,
This is possible, I do it all the time. RS does this function well,
it's just not that obvious. Just perservere, you'll get there in the
end.
Be careful WHERE you are setting these properties. You can set them at
line level and/or cell level. The differences may seem subtle but
produce completely different results.
Set it at line level by using the row selector, this generally works
better and also transfers to Excel well.
You can set both the initial state of the +/- symbol programatically as
well as hiding/showing a row programatically, but these two things are
completely seperate as far as RS is concerned.
If in the visibility tab of the advanced properties of a cell you set
the toggle image to be expanded or collapsed or use an expression, it
has absolutely no affect on any rows toggled by that cell. It just sets
the view of the toggle to + or -.
If your rows are not behaving correctly, then the expression on the
rows 'Hidden' property is wrong. It has to evaluate to True or False,
and don't forget to start the expression with =
If you are setting the visibility at cell level, you will just get
empty cells not hidden rows.
Hope that helps.
Regards
Chris
VNN wrote:
> I tried this before I posted initially but it didn't work. The toggle
> always switches the hidden state of items. So if an item has the
> hidden initial state set to false, toggle will set it back to true
> and it doesn't take the expression into account. What I'm looking for
> is a way to set the toggle item in a expression, not statically
> assigned..
> "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
> news:%23c3GSSqEFHA.2756@.TK2MSFTNGP15.phx.gbl...
> > Although I have never done exactly what you wish , I think it is
> > doable...
> >
> > Set C to initially Visible = false
> > Set A as the Visibility Toggle for B
> > Set B as the Visibility Toggle for C, AND use an expression for the
> initial
> > appearance of the toggle item
> >
> > All of this is set in the Advanced Textbox properties.
> >
> > Good luck... This sounds nice!
> >
> > --
> > Wayne Snyder, MCDBA, SQL Server MVP
> > Mariner, Charlotte, NC
> > www.mariner-usa.com
> > (Please respond only to the newsgroups.)
> >
> > I support the Professional Association of SQL Server (PASS) and it's
> > community of SQL Server professionals.
> > www.sqlpass.org
> >
> > "John R" <JohnR@.hotmail.com> wrote in message
> > news:uyXGnAIEFHA.624@.TK2MSFTNGP15.phx.gbl...
> > > I have structure like this:
> > >
> > > A1
> > > B1
> > > C11
> > > C12
> > > C13
> > >
> > > B2
> > > C21
> > > C22
> > >
> > > A2
> > >
> > > Currently, I set up so at C level, it will appear only if its
> > > value > 0.
> I
> > > would like to have a drilldown structure so when I click on A
> > > level, B level will appear but not the Cx. B will have the + only
> > > if it has child items (if one of its child items has value > 0).
> > > If B has the + sign, it indicates it has child items and when I
> > > click on the + sign, the C level appear only if its value >0.
> > >
> > > Please advice if this is doable (please show how) or this is a
> > > no-no in RS. Thanks
> > >
> >
> >|||I have a similar visibility issue. I have the following report parameters
(This is not my actual report but I recreated the problem using Northwind to
keep it simple)
Sort Order = Customer, Contact, Contact Title
Use drilldown = True/False
I have two groups
1st: SortOrder
2nd: Customer
I want the second group row to stay hidden when the sort option selected is
â'Customerâ' otherwise it should print and toggle. I want to be able to expand
all toggled items optionally.
Is this possible?
If you choose Sort Order: â'Customerâ' the 2nd Condition is displayed when it
should be suppressed based on and expression for the row IIF(SortOrder =â'Customerâ', True, Use drilldown)
Hope this is clear
Any thoughts?
See attached rdl
RRRRRRRRRRRRDDDDDDDDDDDDDLLLLLLLLLLLLLLLLLL
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="Northwind">
<rd:DataSourceID>350a5864-d0e6-4264-b05e-c0bd850548d8</rd:DataSourceID>
<DataSourceReference>Northwind</DataSourceReference>
</DataSource>
</DataSources>
<rd:ReportID>cd305670-04e9-4365-90d1-cc642e18fe5b</rd:ReportID>
<Body>
<ReportItems>
<Table Name="table1">
<DataSetName>DataSet1</DataSetName>
<KeepTogether>true</KeepTogether>
<TableGroups>
<TableGroup>
<Footer>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox13">
<rd:DefaultName>textbox13</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>8</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox14">
<rd:DefaultName>textbox14</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>7</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox15">
<rd:DefaultName>textbox15</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>6</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Footer>
<Grouping Name="table1_Group1">
<GroupExpressions>
<GroupExpression>=Fields(
Parameters!SortOrder.Value).Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<rd:DefaultName>textbox6</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<FontWeight>700</FontWeight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>16</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Fields(Parameters!SortOrder.Value).Value</Value>
</Textbox>
</ReportItems>
<ColSpan>2</ColSpan>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox12">
<rd:DefaultName>textbox12</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>15</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Header>
</TableGroup>
<TableGroup>
<Footer>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox19">
<rd:DefaultName>textbox19</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>5</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox20">
<rd:DefaultName>textbox20</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>4</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox21">
<rd:DefaultName>textbox21</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>3</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Footer>
<Grouping Name="table1_Group2">
<GroupExpressions>
<GroupExpression>=Fields!CompanyName.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Header>
<TableRows>
<TableRow>
<Visibility>
<Hidden>=iif( Parameters!SortOrder.Value="Company",True,
Parameters!SuppressDrildown.Value )</Hidden>
<ToggleItem>textbox6</ToggleItem>
</Visibility>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox16">
<rd:DefaultName>textbox16</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>14</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="CompanyName">
<rd:DefaultName>CompanyName</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>13</ZIndex>
<CanGrow>true</CanGrow>
<Value>=Fields!CompanyName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox18">
<rd:DefaultName>textbox18</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>12</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Header>
</TableGroup>
</TableGroups>
<Width>5.95833in</Width>
<Details>
<TableRows>
<TableRow>
<Visibility>
<Hidden>=Parameters!SuppressDrildown.Value</Hidden>
<ToggleItem>textbox6</ToggleItem>
</Visibility>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<rd:DefaultName>textbox4</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>2</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox5">
<rd:DefaultName>textbox5</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>1</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Phone">
<rd:DefaultName>Phone</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Phone.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Details>
<Style />
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox1">
<rd:DefaultName>textbox1</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>19</ZIndex>
<CanGrow>true</CanGrow>
<Value>Sort Order</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<rd:DefaultName>textbox2</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>18</ZIndex>
<CanGrow>true</CanGrow>
<Value>Company Name</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox3">
<rd:DefaultName>textbox3</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>17</ZIndex>
<CanGrow>true</CanGrow>
<Value>Phone</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<TableColumns>
<TableColumn>
<Width>1.625in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
<TableColumn>
<Width>2.16667in</Width>
</TableColumn>
</TableColumns>
<Footer>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<rd:DefaultName>textbox7</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>11</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<rd:DefaultName>textbox8</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>10</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox9">
<rd:DefaultName>textbox9</rd:DefaultName>
<Style>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<ZIndex>9</ZIndex>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Footer>
</Table>
</ReportItems>
<Height>1.75in</Height>
<Style />
</Body>
<rd:DrawGrid>true</rd:DrawGrid>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="CustomerID">
<DataField>CustomerID</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="CompanyName">
<DataField>CompanyName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ContactName">
<DataField>ContactName</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ContactTitle">
<DataField>ContactTitle</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Address">
<DataField>Address</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="City">
<DataField>City</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Region">
<DataField>Region</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="PostalCode">
<DataField>PostalCode</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Country">
<DataField>Country</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Phone">
<DataField>Phone</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Fax">
<DataField>Fax</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>Northwind</DataSourceName>
<CommandText>SELECT * FROM Customers</CommandText>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
</DataSet>
</DataSets>
<Language>en-US</Language>
<RightMargin>1in</RightMargin>
<BottomMargin>1in</BottomMargin>
<TopMargin>1in</TopMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Width>6.5in</Width>
<LeftMargin>1in</LeftMargin>
<ReportParameters>
<ReportParameter Name="SortOrder">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>CompanyName</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Sort order</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>CompanyName</Value>
<Label>Customers</Label>
</ParameterValue>
<ParameterValue>
<Value>ContactName</Value>
<Label>Contact</Label>
</ParameterValue>
<ParameterValue>
<Value>ContactTitle</Value>
<Label>Title</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="SuppressDrildown">
<DataType>Boolean</DataType>
<DefaultValue>
<Values>
<Value>True</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Use drilldown</Prompt>
</ReportParameter>
</ReportParameters>
</Report>
RRRRRRRRRRRRRDDDDDDDDDDDDDDDLLLLLLLLLLLLLLLLLL
"Chris McGuigan" wrote:
> VNN,
> This is possible, I do it all the time. RS does this function well,
> it's just not that obvious. Just perservere, you'll get there in the
> end.
> Be careful WHERE you are setting these properties. You can set them at
> line level and/or cell level. The differences may seem subtle but
> produce completely different results.
> Set it at line level by using the row selector, this generally works
> better and also transfers to Excel well.
> You can set both the initial state of the +/- symbol programatically as
> well as hiding/showing a row programatically, but these two things are
> completely seperate as far as RS is concerned.
> If in the visibility tab of the advanced properties of a cell you set
> the toggle image to be expanded or collapsed or use an expression, it
> has absolutely no affect on any rows toggled by that cell. It just sets
> the view of the toggle to + or -.
> If your rows are not behaving correctly, then the expression on the
> rows 'Hidden' property is wrong. It has to evaluate to True or False,
> and don't forget to start the expression with => If you are setting the visibility at cell level, you will just get
> empty cells not hidden rows.
> Hope that helps.
> Regards
> Chris
>
> VNN wrote:
> > I tried this before I posted initially but it didn't work. The toggle
> > always switches the hidden state of items. So if an item has the
> > hidden initial state set to false, toggle will set it back to true
> > and it doesn't take the expression into account. What I'm looking for
> > is a way to set the toggle item in a expression, not statically
> > assigned..
> >
> > "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
> > news:%23c3GSSqEFHA.2756@.TK2MSFTNGP15.phx.gbl...
> > > Although I have never done exactly what you wish , I think it is
> > > doable...
> > >
> > > Set C to initially Visible = false
> > > Set A as the Visibility Toggle for B
> > > Set B as the Visibility Toggle for C, AND use an expression for the
> > initial
> > > appearance of the toggle item
> > >
> > > All of this is set in the Advanced Textbox properties.
> > >
> > > Good luck... This sounds nice!
> > >
> > > --
> > > Wayne Snyder, MCDBA, SQL Server MVP
> > > Mariner, Charlotte, NC
> > > www.mariner-usa.com
> > > (Please respond only to the newsgroups.)
> > >
> > > I support the Professional Association of SQL Server (PASS) and it's
> > > community of SQL Server professionals.
> > > www.sqlpass.org
> > >
> > > "John R" <JohnR@.hotmail.com> wrote in message
> > > news:uyXGnAIEFHA.624@.TK2MSFTNGP15.phx.gbl...
> > > > I have structure like this:
> > > >
> > > > A1
> > > > B1
> > > > C11
> > > > C12
> > > > C13
> > > >
> > > > B2
> > > > C21
> > > > C22
> > > >
> > > > A2
> > > >
> > > > Currently, I set up so at C level, it will appear only if its
> > > > value > 0.
> > I
> > > > would like to have a drilldown structure so when I click on A
> > > > level, B level will appear but not the Cx. B will have the + only
> > > > if it has child items (if one of its child items has value > 0).
> > > > If B has the + sign, it indicates it has child items and when I
> > > > click on the + sign, the C level appear only if its value >0.
> > > >
> > > > Please advice if this is doable (please show how) or this is a
> > > > no-no in RS. Thanks
> > > >
> > >
> > >
>|||I use another parameter, 'Expand All' True/False. Then use that
parameter in the Initial Visibilty properties.
You could use an exression something like this;
=Not Parameter!Expand.Value Or Parameter!Sort.Value = "Customer"
Chris
John wrote:
> I have a similar visibility issue. I have the following report
> parameters
> (This is not my actual report but I recreated the problem using
> Northwind to keep it simple)
> Sort Order = Customer, Contact, Contact Title
> Use drilldown = True/False
> I have two groups
> 1st: SortOrder
> 2nd: Customer
> I want the second group row to stay hidden when the sort option
> selected is â'Customerâ' otherwise it should print and toggle. I
> want to be able to expand all toggled items optionally.
> Is this possible?
> If you choose Sort Order: â'Customerâ' the 2nd Condition is
> displayed when it should be suppressed based on and expression for
> the row IIF(SortOrder = â'Customerâ', True, Use drilldown)
> Hope this is clear
> Any thoughts?
> See attached rdl
> RRRRRRRRRRRRDDDDDDDDDDDDDLLLLLLLLLLLLLLLLLL
> <?xml version="1.0" encoding="utf-8"?>
> <Report
> xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/report
> definition"
> xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesig
> ner"> <DataSources> <DataSource Name="Northwind">
> <rd:DataSourceID>350a5864-d0e6-4264-b05e-c0bd850548d8</rd:DataSourceID
> > <DataSourceReference>Northwind</DataSourceReference>
> </DataSource> </DataSources>
> <rd:ReportID>cd305670-04e9-4365-90d1-cc642e18fe5b</rd:ReportID>
> <Body>
> <ReportItems>
> <Table Name="table1">
> <DataSetName>DataSet1</DataSetName>
> <KeepTogether>true</KeepTogether>
> <TableGroups>
> <TableGroup>
> <Footer>
> <TableRows>
> <TableRow>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox13">
> <rd:DefaultName>textbox13</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>8</ZIndex>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox14">
> <rd:DefaultName>textbox14</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>7</ZIndex>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox15">
> <rd:DefaultName>textbox15</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>6</ZIndex>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> <Height>0.25in</Height>
> </TableRow>
> </TableRows>
> </Footer>
> <Grouping Name="table1_Group1">
> <GroupExpressions>
> <GroupExpression>=Fields(
> Parameters!SortOrder.Value).Value</GroupExpression>
> </GroupExpressions>
> </Grouping>
> <Header>
> <TableRows>
> <TableRow>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox6">
> <rd:DefaultName>textbox6</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <FontWeight>700</FontWeight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>16</ZIndex>
> <CanGrow>true</CanGrow>
> <Value>=Fields(Parameters!SortOrder.Value).Value</Value>
> </Textbox>
> </ReportItems>
> <ColSpan>2</ColSpan>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox12">
> <rd:DefaultName>textbox12</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>15</ZIndex>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> <Height>0.25in</Height>
> </TableRow>
> </TableRows>
> </Header>
> </TableGroup>
> <TableGroup>
> <Footer>
> <TableRows>
> <TableRow>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox19">
> <rd:DefaultName>textbox19</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>5</ZIndex>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox20">
> <rd:DefaultName>textbox20</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>4</ZIndex>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox21">
> <rd:DefaultName>textbox21</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>3</ZIndex>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> <Height>0.25in</Height>
> </TableRow>
> </TableRows>
> </Footer>
> <Grouping Name="table1_Group2">
> <GroupExpressions>
> <GroupExpression>=Fields!CompanyName.Value</GroupExpression>
> </GroupExpressions> </Grouping>
> <Header>
> <TableRows>
> <TableRow>
> <Visibility>
> <Hidden>=iif(
> Parameters!SortOrder.Value="Company",True,
> Parameters!SuppressDrildown.Value )</Hidden>
> <ToggleItem>textbox6</ToggleItem> </Visibility>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox16">
> <rd:DefaultName>textbox16</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <VerticalAlign>Middle</VerticalAlign>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>14</ZIndex>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="CompanyName">
> <rd:DefaultName>CompanyName</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>13</ZIndex>
> <CanGrow>true</CanGrow>
> <Value>=Fields!CompanyName.Value</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox18">
> <rd:DefaultName>textbox18</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>12</ZIndex>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> <Height>0.25in</Height>
> </TableRow>
> </TableRows>
> </Header>
> </TableGroup>
> </TableGroups>
> <Width>5.95833in</Width>
> <Details>
> <TableRows>
> <TableRow>
> <Visibility>
> <Hidden>=Parameters!SuppressDrildown.Value</Hidden>
> <ToggleItem>textbox6</ToggleItem>
> </Visibility>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox4">
> <rd:DefaultName>textbox4</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>2</ZIndex>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox5">
> <rd:DefaultName>textbox5</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>1</ZIndex>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="Phone">
> <rd:DefaultName>Phone</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <CanGrow>true</CanGrow>
> <Value>=Fields!Phone.Value</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> <Height>0.25in</Height>
> </TableRow>
> </TableRows>
> </Details>
> <Style />
> <Header>
> <TableRows>
> <TableRow>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox1">
> <rd:DefaultName>textbox1</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>19</ZIndex>
> <CanGrow>true</CanGrow>
> <Value>Sort Order</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox2">
> <rd:DefaultName>textbox2</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>18</ZIndex>
> <CanGrow>true</CanGrow>
> <Value>Company Name</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox3">
> <rd:DefaultName>textbox3</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>17</ZIndex>
> <CanGrow>true</CanGrow>
> <Value>Phone</Value>
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> <Height>0.25in</Height>
> </TableRow>
> </TableRows>
> <RepeatOnNewPage>true</RepeatOnNewPage>
> </Header>
> <TableColumns>
> <TableColumn>
> <Width>1.625in</Width>
> </TableColumn>
> <TableColumn>
> <Width>2.16667in</Width>
> </TableColumn>
> <TableColumn>
> <Width>2.16667in</Width>
> </TableColumn>
> </TableColumns>
> <Footer>
> <TableRows>
> <TableRow>
> <TableCells>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox7">
> <rd:DefaultName>textbox7</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>11</ZIndex>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox8">
> <rd:DefaultName>textbox8</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>10</ZIndex>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> <TableCell>
> <ReportItems>
> <Textbox Name="textbox9">
> <rd:DefaultName>textbox9</rd:DefaultName>
> <Style>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <ZIndex>9</ZIndex>
> <CanGrow>true</CanGrow>
> <Value />
> </Textbox>
> </ReportItems>
> </TableCell>
> </TableCells>
> <Height>0.25in</Height>
> </TableRow>
> </TableRows>
> </Footer>
> </Table>
> </ReportItems>
> <Height>1.75in</Height>
> <Style />
> </Body>
> <rd:DrawGrid>true</rd:DrawGrid>
> <DataSets>
> <DataSet Name="DataSet1">
> <Fields>
> <Field Name="CustomerID">
> <DataField>CustomerID</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="CompanyName">
> <DataField>CompanyName</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="ContactName">
> <DataField>ContactName</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="ContactTitle">
> <DataField>ContactTitle</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Address">
> <DataField>Address</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="City">
> <DataField>City</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Region">
> <DataField>Region</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="PostalCode">
> <DataField>PostalCode</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Country">
> <DataField>Country</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Phone">
> <DataField>Phone</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> <Field Name="Fax">
> <DataField>Fax</DataField>
> <rd:TypeName>System.String</rd:TypeName>
> </Field>
> </Fields>
> <Query>
> <DataSourceName>Northwind</DataSourceName>
> <CommandText>SELECT * FROM Customers</CommandText>
> <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
> </Query>
> </DataSet>
> </DataSets>
> <Language>en-US</Language>
> <RightMargin>1in</RightMargin>
> <BottomMargin>1in</BottomMargin>
> <TopMargin>1in</TopMargin>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <Width>6.5in</Width>
> <LeftMargin>1in</LeftMargin>
> <ReportParameters>
> <ReportParameter Name="SortOrder">
> <DataType>String</DataType>
> <DefaultValue>
> <Values>
> <Value>CompanyName</Value>
> </Values>
> </DefaultValue>
> <AllowBlank>true</AllowBlank>
> <Prompt>Sort order</Prompt>
> <ValidValues>
> <ParameterValues>
> <ParameterValue>
> <Value>CompanyName</Value>
> <Label>Customers</Label>
> </ParameterValue>
> <ParameterValue>
> <Value>ContactName</Value>
> <Label>Contact</Label>
> </ParameterValue>
> <ParameterValue>
> <Value>ContactTitle</Value>
> <Label>Title</Label>
> </ParameterValue>
> </ParameterValues>
> </ValidValues>
> </ReportParameter>
> <ReportParameter Name="SuppressDrildown">
> <DataType>Boolean</DataType>
> <DefaultValue>
> <Values>
> <Value>True</Value>
> </Values>
> </DefaultValue>
> <AllowBlank>true</AllowBlank>
> <Prompt>Use drilldown</Prompt>
> </ReportParameter>
> </ReportParameters>
> </Report>
>
> RRRRRRRRRRRRRDDDDDDDDDDDDDDDLLLLLLLLLLLLLLLLLL
>
> "Chris McGuigan" wrote:
> > VNN,
> > This is possible, I do it all the time. RS does this function well,
> > it's just not that obvious. Just perservere, you'll get there in the
> > end.
> >
> > Be careful WHERE you are setting these properties. You can set them
> > at line level and/or cell level. The differences may seem subtle but
> > produce completely different results.
> >
> > Set it at line level by using the row selector, this generally works
> > better and also transfers to Excel well.
> >
> > You can set both the initial state of the +/- symbol
> > programatically as well as hiding/showing a row programatically,
> > but these two things are completely seperate as far as RS is
> > concerned.
> >
> > If in the visibility tab of the advanced properties of a cell you
> > set the toggle image to be expanded or collapsed or use an
> > expression, it has absolutely no affect on any rows toggled by that
> > cell. It just sets the view of the toggle to + or -.
> >
> > If your rows are not behaving correctly, then the expression on the
> > rows 'Hidden' property is wrong. It has to evaluate to True or
> > False, and don't forget to start the expression with => >
> > If you are setting the visibility at cell level, you will just get
> > empty cells not hidden rows.
> >
> > Hope that helps.
> >
> > Regards
> > Chris
> >
> >
> > VNN wrote:
> >
> > > I tried this before I posted initially but it didn't work. The
> > > toggle always switches the hidden state of items. So if an item
> > > has the hidden initial state set to false, toggle will set it
> > > back to true and it doesn't take the expression into account.
> > > What I'm looking for is a way to set the toggle item in a
> > > expression, not statically assigned..
> > >
> > > "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in
> > > message news:%23c3GSSqEFHA.2756@.TK2MSFTNGP15.phx.gbl...
> > > > Although I have never done exactly what you wish , I think it is
> > > > doable...
> > > >
> > > > Set C to initially Visible = false
> > > > Set A as the Visibility Toggle for B
> > > > Set B as the Visibility Toggle for C, AND use an expression for
> > > > the
> > > initial
> > > > appearance of the toggle item
> > > >
> > > > All of this is set in the Advanced Textbox properties.
> > > >
> > > > Good luck... This sounds nice!
> > > >
> > > > --
> > > > Wayne Snyder, MCDBA, SQL Server MVP
> > > > Mariner, Charlotte, NC
> > > > www.mariner-usa.com
> > > > (Please respond only to the newsgroups.)
> > > >
> > > > I support the Professional Association of SQL Server (PASS) and
> > > > it's community of SQL Server professionals.
> > > > www.sqlpass.org
> > > >
> > > > "John R" <JohnR@.hotmail.com> wrote in message
> > > > news:uyXGnAIEFHA.624@.TK2MSFTNGP15.phx.gbl...
> > > > > I have structure like this:
> > > > >
> > > > > A1
> > > > > B1
> > > > > C11
> > > > > C12
> > > > > C13
> > > > >
> > > > > B2
> > > > > C21
> > > > > C22
> > > > >
> > > > > A2
> > > > >
> > > > > Currently, I set up so at C level, it will appear only if its
> > > > > value > 0.
> > > I
> > > > > would like to have a drilldown structure so when I click on A
> > > > > level, B level will appear but not the Cx. B will have the +
> > > > > only if it has child items (if one of its child items has
> > > > > value > 0). If B has the + sign, it indicates it has child
> > > > > items and when I click on the + sign, the C level appear only
> > > > > if its value >0.
> > > > >
> > > > > Please advice if this is doable (please show how) or this is a
> > > > > no-no in RS. Thanks
> > > > >
> > > >
> > > >
> >
> >|||Thanks for responding Chris.
This is what I'm doing on the second group, but it appears that the
"ToggleItem" property takes precedence over "Hidden" and as far as I can tell
you can't add an expression to a ToggleItem. It's important that the second
group row be suppressed when "Customer" is selected and not merely blank.
"Chris McGuigan" wrote:
> I use another parameter, 'Expand All' True/False. Then use that
> parameter in the Initial Visibilty properties.
> You could use an exression something like this;
> =Not Parameter!Expand.Value Or Parameter!Sort.Value = "Customer"
> Chris
>
> John wrote:
> > I have a similar visibility issue. I have the following report
> > parameters
> >
> > (This is not my actual report but I recreated the problem using
> > Northwind to keep it simple)
> >
> > Sort Order = Customer, Contact, Contact Title
> > Use drilldown = True/False
> >
> > I have two groups
> > 1st: SortOrder
> > 2nd: Customer
> >
> > I want the second group row to stay hidden when the sort option
> > selected is â'Customerâ' otherwise it should print and toggle. I
> > want to be able to expand all toggled items optionally.
> >
> > Is this possible?
> >
> > If you choose Sort Order: â'Customerâ' the 2nd Condition is
> > displayed when it should be suppressed based on and expression for
> > the row IIF(SortOrder = â'Customerâ', True, Use drilldown)
> >
> > Hope this is clear
> >
> > Any thoughts?
> >
> > See attached rdl
> >
> > RRRRRRRRRRRRDDDDDDDDDDDDDLLLLLLLLLLLLLLLLLL
> > <?xml version="1.0" encoding="utf-8"?>
> > <Report
> > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/report
> > definition"
> > xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesig
> > ner"> <DataSources> <DataSource Name="Northwind">
> >
> > <rd:DataSourceID>350a5864-d0e6-4264-b05e-c0bd850548d8</rd:DataSourceID
> > > <DataSourceReference>Northwind</DataSourceReference>
> > </DataSource> </DataSources>
> > <rd:ReportID>cd305670-04e9-4365-90d1-cc642e18fe5b</rd:ReportID>
> > <Body>
> > <ReportItems>
> > <Table Name="table1">
> > <DataSetName>DataSet1</DataSetName>
> > <KeepTogether>true</KeepTogether>
> > <TableGroups>
> > <TableGroup>
> > <Footer>
> > <TableRows>
> > <TableRow>
> > <TableCells>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox13">
> > <rd:DefaultName>textbox13</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>8</ZIndex>
> > <CanGrow>true</CanGrow>
> > <Value />
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox14">
> > <rd:DefaultName>textbox14</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>7</ZIndex>
> > <CanGrow>true</CanGrow>
> > <Value />
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox15">
> > <rd:DefaultName>textbox15</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>6</ZIndex>
> > <CanGrow>true</CanGrow>
> > <Value />
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > </TableCells>
> > <Height>0.25in</Height>
> > </TableRow>
> > </TableRows>
> > </Footer>
> > <Grouping Name="table1_Group1">
> > <GroupExpressions>
> > <GroupExpression>=Fields(
> > Parameters!SortOrder.Value).Value</GroupExpression>
> > </GroupExpressions>
> > </Grouping>
> > <Header>
> > <TableRows>
> > <TableRow>
> > <TableCells>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox6">
> > <rd:DefaultName>textbox6</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <FontWeight>700</FontWeight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>16</ZIndex>
> > <CanGrow>true</CanGrow>
> >
> > <Value>=Fields(Parameters!SortOrder.Value).Value</Value>
> > </Textbox>
> > </ReportItems>
> > <ColSpan>2</ColSpan>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox12">
> > <rd:DefaultName>textbox12</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>15</ZIndex>
> > <CanGrow>true</CanGrow>
> > <Value />
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > </TableCells>
> > <Height>0.25in</Height>
> > </TableRow>
> > </TableRows>
> > </Header>
> > </TableGroup>
> > <TableGroup>
> > <Footer>
> > <TableRows>
> > <TableRow>
> > <TableCells>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox19">
> > <rd:DefaultName>textbox19</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>5</ZIndex>
> > <CanGrow>true</CanGrow>
> > <Value />
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox20">
> > <rd:DefaultName>textbox20</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>4</ZIndex>
> > <CanGrow>true</CanGrow>
> > <Value />
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox21">
> > <rd:DefaultName>textbox21</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>3</ZIndex>
> > <CanGrow>true</CanGrow>
> > <Value />
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > </TableCells>
> > <Height>0.25in</Height>
> > </TableRow>
> > </TableRows>
> > </Footer>
> > <Grouping Name="table1_Group2">
> > <GroupExpressions>
> >
> > <GroupExpression>=Fields!CompanyName.Value</GroupExpression>
> > </GroupExpressions> </Grouping>
> > <Header>
> > <TableRows>
> > <TableRow>
> > <Visibility>
> > <Hidden>=iif(
> > Parameters!SortOrder.Value="Company",True,
> > Parameters!SuppressDrildown.Value )</Hidden>
> > <ToggleItem>textbox6</ToggleItem> </Visibility>
> > <TableCells>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox16">
> > <rd:DefaultName>textbox16</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <VerticalAlign>Middle</VerticalAlign>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>14</ZIndex>
> > <CanGrow>true</CanGrow>
> > <Value />
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="CompanyName">
> > <rd:DefaultName>CompanyName</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>13</ZIndex>
> > <CanGrow>true</CanGrow>
> > <Value>=Fields!CompanyName.Value</Value>
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox18">
> > <rd:DefaultName>textbox18</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>12</ZIndex>
> > <CanGrow>true</CanGrow>
> > <Value />
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > </TableCells>
> > <Height>0.25in</Height>
> > </TableRow>
> > </TableRows>
> > </Header>
> > </TableGroup>
> > </TableGroups>
> > <Width>5.95833in</Width>
> > <Details>
> > <TableRows>
> > <TableRow>
> > <Visibility>
> > <Hidden>=Parameters!SuppressDrildown.Value</Hidden>
> > <ToggleItem>textbox6</ToggleItem>
> > </Visibility>
> > <TableCells>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox4">
> > <rd:DefaultName>textbox4</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>2</ZIndex>
> > <CanGrow>true</CanGrow>
> > <Value />
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox5">
> > <rd:DefaultName>textbox5</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>1</ZIndex>
> > <CanGrow>true</CanGrow>
> > <Value />
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="Phone">
> > <rd:DefaultName>Phone</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <CanGrow>true</CanGrow>
> > <Value>=Fields!Phone.Value</Value>
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > </TableCells>
> > <Height>0.25in</Height>
> > </TableRow>
> > </TableRows>
> > </Details>
> > <Style />
> > <Header>
> > <TableRows>
> > <TableRow>
> > <TableCells>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox1">
> > <rd:DefaultName>textbox1</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>19</ZIndex>
> > <CanGrow>true</CanGrow>
> > <Value>Sort Order</Value>
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox2">
> > <rd:DefaultName>textbox2</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>18</ZIndex>
> > <CanGrow>true</CanGrow>
> > <Value>Company Name</Value>
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox3">
> > <rd:DefaultName>textbox3</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>17</ZIndex>
> > <CanGrow>true</CanGrow>
> > <Value>Phone</Value>
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > </TableCells>
> > <Height>0.25in</Height>
> > </TableRow>
> > </TableRows>
> > <RepeatOnNewPage>true</RepeatOnNewPage>
> > </Header>
> > <TableColumns>
> > <TableColumn>
> > <Width>1.625in</Width>
> > </TableColumn>
> > <TableColumn>
> > <Width>2.16667in</Width>
> > </TableColumn>
> > <TableColumn>
> > <Width>2.16667in</Width>
> > </TableColumn>
> > </TableColumns>
> > <Footer>
> > <TableRows>
> > <TableRow>
> > <TableCells>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox7">
> > <rd:DefaultName>textbox7</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>11</ZIndex>
> > <CanGrow>true</CanGrow>
> > <Value />
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox8">
> > <rd:DefaultName>textbox8</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>10</ZIndex>
> > <CanGrow>true</CanGrow>
> > <Value />
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > <TableCell>
> > <ReportItems>
> > <Textbox Name="textbox9">
> > <rd:DefaultName>textbox9</rd:DefaultName>
> > <Style>
> > <PaddingBottom>2pt</PaddingBottom>
> > <PaddingLeft>2pt</PaddingLeft>
> > <PaddingRight>2pt</PaddingRight>
> > <PaddingTop>2pt</PaddingTop>
> > </Style>
> > <ZIndex>9</ZIndex>
> > <CanGrow>true</CanGrow>
> > <Value />
> > </Textbox>
> > </ReportItems>
> > </TableCell>
> > </TableCells>
> > <Height>0.25in</Height>
> > </TableRow>
> > </TableRows>
> > </Footer>
> > </Table>
> > </ReportItems>
> > <Height>1.75in</Height>
> > <Style />
> > </Body>
> > <rd:DrawGrid>true</rd:DrawGrid>
> > <DataSets>
> > <DataSet Name="DataSet1">
> > <Fields>
> > <Field Name="CustomerID">
> > <DataField>CustomerID</DataField>
> > <rd:TypeName>System.String</rd:TypeName>
> > </Field>
> > <Field Name="CompanyName">
> > <DataField>CompanyName</DataField>
> > <rd:TypeName>System.String</rd:TypeName>
> > </Field>
> > <Field Name="ContactName">
> > <DataField>ContactName</DataField>
> > <rd:TypeName>System.String</rd:TypeName>
> > </Field>
> > <Field Name="ContactTitle">
> > <DataField>ContactTitle</DataField>
> > <rd:TypeName>System.String</rd:TypeName>
> > </Field>
> > <Field Name="Address">
> > <DataField>Address</DataField>
> > <rd:TypeName>System.String</rd:TypeName>
> > </Field>
> > <Field Name="City">
> > <DataField>City</DataField>
> > <rd:TypeName>System.String</rd:TypeName>
> > </Field>
> > <Field Name="Region">
> > <DataField>Region</DataField>
> > <rd:TypeName>System.String</rd:TypeName>
> > </Field>
> > <Field Name="PostalCode">
> > <DataField>PostalCode</DataField>
> > <rd:TypeName>System.String</rd:TypeName>
> > </Field>
> > <Field Name="Country">
> > <DataField>Country</DataField>
> > <rd:TypeName>System.String</rd:TypeName>
> > </Field>
> > <Field Name="Phone">
> > <DataField>Phone</DataField>
> > <rd:TypeName>System.String</rd:TypeName>
> > </Field>
> > <Field Name="Fax">
> > <DataField>Fax</DataField>
> > <rd:TypeName>System.String</rd:TypeName>
> > </Field>
> > </Fields>
> > <Query>
> > <DataSourceName>Northwind</DataSourceName>
> > <CommandText>SELECT * FROM Customers</CommandText>
> > <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
> > </Query>
> > </DataSet>
> > </DataSets>
> > <Language>en-US</Language>
> > <RightMargin>1in</RightMargin>
> > <BottomMargin>1in</BottomMargin>
> > <TopMargin>1in</TopMargin>
> > <rd:SnapToGrid>true</rd:SnapToGrid>
> > <Width>6.5in</Width>
> > <LeftMargin>1in</LeftMargin>
> > <ReportParameters>
> > <ReportParameter Name="SortOrder">
> > <DataType>String</DataType>
> > <DefaultValue>
> > <Values>
> > <Value>CompanyName</Value>
> > </Values>
> > </DefaultValue>
> > <AllowBlank>true</AllowBlank>
> > <Prompt>Sort order</Prompt>
> > <ValidValues>
> > <ParameterValues>
> > <ParameterValue>
> > <Value>CompanyName</Value>
> > <Label>Customers</Label>
> > </ParameterValue>
> > <ParameterValue>
> > <Value>ContactName</Value>
> > <Label>Contact</Label>
> > </ParameterValue>
> > <ParameterValue>
> > <Value>ContactTitle</Value>
> > <Label>Title</Label>
> > </ParameterValue>
> > </ParameterValues>
> > </ValidValues>
> > </ReportParameter>
> > <ReportParameter Name="SuppressDrildown">
> > <DataType>Boolean</DataType>
> > <DefaultValue>
> > <Values>
> > <Value>True</Value>
> > </Values>
> > </DefaultValue>
> > <AllowBlank>true</AllowBlank>
> > <Prompt>Use drilldown</Prompt>
> > </ReportParameter>
> > </ReportParameters>
> > </Report>
> >
> >
> > RRRRRRRRRRRRRDDDDDDDDDDDDDDDLLLLLLLLLLLLLLLLLL
> >
> >
> > "Chris McGuigan" wrote:
> >
> > > VNN,
> > > This is possible, I do it all the time. RS does this function well,
> > > it's just not that obvious. Just perservere, you'll get there in the
> > > end.
> > >
> > > Be careful WHERE you are setting these properties. You can set them
> > > at line level and/or cell level. The differences may seem subtle but
> > > produce completely different results.
> > >
> > > Set it at line level by using the row selector, this generally works
> > > better and also transfers to Excel well.
> > >
> > > You can set both the initial state of the +/- symbol
> > > programatically as well as hiding/showing a row programatically,
> > > but these two things are completely seperate as far as RS is
> > > concerned.
> > >
> > > If in the visibility tab of the advanced properties of a cell you
> > > set the toggle image to be expanded or collapsed or use an
> > > expression, it has absolutely no affect on any rows toggled by that
> > > cell. It just sets the view of the toggle to + or -.
> > >
> > > If your rows are not behaving correctly, then the expression on the
> > > rows 'Hidden' property is wrong. It has to evaluate to True or
> > > False, and don't forget to start the expression with => > >
> > > If you are setting the visibility at cell level, you will just get
> > > empty cells not hidden rows.
> > >
> > > Hope that helps.
> > >
> > > Regards
> > > Chris
> > >
> > >
> > > VNN wrote:
> > >
> > > > I tried this before I posted initially but it didn't work. The
> > > > toggle always switches the hidden state of items. So if an item
> > > > has the hidden initial state set to false, toggle will set it
> > > > back to true and it doesn't take the expression into account.
> > > > What I'm looking for is a way to set the toggle item in a
> > > > expression, not statically assigned..
> > > >
> > > > "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in
> > > > message news:%23c3GSSqEFHA.2756@.TK2MSFTNGP15.phx.gbl...
> > > > > Although I have never done exactly what you wish , I think it is
> > > > > doable...
> > > > >
> > > > > Set C to initially Visible = false
> > > > > Set A as the Visibility Toggle for B
> > > > > Set B as the Visibility Toggle for C, AND use an expression for
> > > > > the
> > > > initial
> > > > > appearance of the toggle item
> > > > >
> > > > > All of this is set in the Advanced Textbox properties.
> > > > >
> > > > > Good luck... This sounds nice!
> > > > >
> > > > > --
> > > > > Wayne Snyder, MCDBA, SQL Server MVP
> > > > > Mariner, Charlotte, NC
> > > > > www.mariner-usa.com
> > > > > (Please respond only to the newsgroups.)
> > > > >
> > > > > I support the Professional Association of SQL Server (PASS) and
> > > > > it's community of SQL Server professionals.
> > > > > www.sqlpass.org
> > > > >
> > > > > "John R" <JohnR@.hotmail.com> wrote in message
> > > > > news:uyXGnAIEFHA.624@.TK2MSFTNGP15.phx.gbl...
> > > > > > I have structure like this:
> > > > > >
> > > > > > A1
> > > > > > B1
> > > > > > C11
> > > > > > C12
> > > > > > C13
> > > > > >
> > > > > > B2
> > > > > > C21
> > > > > > C22
> > > > > >
> > > > > > A2
> > > > > >
> > > > > > Currently, I set up so at C level, it will appear only if its
> > > > > > value > 0.
> > > > I
> > > > > > would like to have a drilldown structure so when I click on A
> > > > > > level, B level will appear but not the Cx. B will have the +
> > > > > > only if it has child items (if one of its child items has
> > > > > > value > 0). If B has the + sign, it indicates it has child
> > > > > > items and when I click on the + sign, the C level appear only
> > > > > > if its value >0.
> > > > > >
> > > > > > Please advice if this is doable (please show how) or this is a
> > > > > > no-no in RS. Thanks
> > > > > >
> > > > >
> > > > >
> > >
> > >
>|||FYI: ToggleItem can only be a cell name. You also cannot tell the state
of the toggleitem.
Are you saying that the user is still able to 'toggle' to group 2 even
if sort order = customer?
If you need to hide the toggle, create another column, make it about
0.5cm wide, make the appropriate cell in this column the toggle for
group 2. Then in that cells visibility/hidden property, set it to
=Parameter!SortOrder.Value = "Customer"
This will make the toggle disappear if sort order is customer.
Chris
John wrote:
> Thanks for responding Chris.
> This is what I'm doing on the second group, but it appears that the
> "ToggleItem" property takes precedence over "Hidden" and as far as I
> can tell you can't add an expression to a ToggleItem. It's important
> that the second group row be suppressed when "Customer" is selected
> and not merely blank.
> "Chris McGuigan" wrote:
> > I use another parameter, 'Expand All' True/False. Then use that
> > parameter in the Initial Visibilty properties.
> >
> > You could use an exression something like this;
> > =Not Parameter!Expand.Value Or Parameter!Sort.Value = "Customer"
> >
> > Chris
> >
> >
> >
> > John wrote:
> >
> > > I have a similar visibility issue. I have the following report
> > > parameters
> > >
> > > (This is not my actual report but I recreated the problem using
> > > Northwind to keep it simple)
> > >
> > > Sort Order = Customer, Contact, Contact Title
> > > Use drilldown = True/False
> > >
> > > I have two groups
> > > 1st: SortOrder
> > > 2nd: Customer
> > >
> > > I want the second group row to stay hidden when the sort option
> > > selected is â'Customerâ' otherwise it should print and toggle.
> > > I want to be able to expand all toggled items optionally.
> > >
> > > Is this possible?
> > >
> > > If you choose Sort Order: â'Customerâ' the 2nd Condition is
> > > displayed when it should be suppressed based on and expression for
> > > the row IIF(SortOrder = â'Customerâ', True, Use drilldown)
> > >
> > > Hope this is clear
> > >
> > > Any thoughts?
> > >
> > > See attached rdl
> > >
> > > RRRRRRRRRRRRDDDDDDDDDDDDDLLLLLLLLLLLLLLLLLL
> > > <?xml version="1.0" encoding="utf-8"?>
> > > <Report
> > > xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/re
> > > port definition"
> > > xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportd
> > > esig ner"> <DataSources> <DataSource Name="Northwind">
> > >
> > > <rd:DataSourceID>350a5864-d0e6-4264-b05e-c0bd850548d8</rd:DataSour
> > > ceID
> > > > <DataSourceReference>Northwind</DataSourceReference>
> > > </DataSource> </DataSources>
> > > <rd:ReportID>cd305670-04e9-4365-90d1-cc642e18fe5b</rd:ReportID>
> > > <Body>
> > > <ReportItems>
> > > <Table Name="table1">
> > > <DataSetName>DataSet1</DataSetName>
> > > <KeepTogether>true</KeepTogether>
> > > <TableGroups>
> > > <TableGroup>
> > > <Footer>
> > > <TableRows>
> > > <TableRow>
> > > <TableCells>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox13">
> > >
> > > <rd:DefaultName>textbox13</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop> </Style>
> > > <ZIndex>8</ZIndex>
> > > <CanGrow>true</CanGrow>
> > > <Value />
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox14">
> > >
> > > <rd:DefaultName>textbox14</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop> </Style>
> > > <ZIndex>7</ZIndex>
> > > <CanGrow>true</CanGrow>
> > > <Value />
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox15">
> > >
> > > <rd:DefaultName>textbox15</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop> </Style>
> > > <ZIndex>6</ZIndex>
> > > <CanGrow>true</CanGrow>
> > > <Value />
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > </TableCells>
> > > <Height>0.25in</Height>
> > > </TableRow>
> > > </TableRows>
> > > </Footer>
> > > <Grouping Name="table1_Group1">
> > > <GroupExpressions>
> > > <GroupExpression>=Fields(
> > > Parameters!SortOrder.Value).Value</GroupExpression>
> > > </GroupExpressions>
> > > </Grouping>
> > > <Header>
> > > <TableRows>
> > > <TableRow>
> > > <TableCells>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox6">
> > >
> > > <rd:DefaultName>textbox6</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <FontWeight>700</FontWeight>
> > > <PaddingTop>2pt</PaddingTop> </Style>
> > > <ZIndex>16</ZIndex>
> > > <CanGrow>true</CanGrow>
> > >
> > > <Value>=Fields(Parameters!SortOrder.Value).Value</Value>
> > > </Textbox>
> > > </ReportItems>
> > > <ColSpan>2</ColSpan>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox12">
> > >
> > > <rd:DefaultName>textbox12</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop> </Style>
> > > <ZIndex>15</ZIndex>
> > > <CanGrow>true</CanGrow>
> > > <Value />
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > </TableCells>
> > > <Height>0.25in</Height>
> > > </TableRow>
> > > </TableRows>
> > > </Header>
> > > </TableGroup>
> > > <TableGroup>
> > > <Footer>
> > > <TableRows>
> > > <TableRow>
> > > <TableCells>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox19">
> > >
> > > <rd:DefaultName>textbox19</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop> </Style>
> > > <ZIndex>5</ZIndex>
> > > <CanGrow>true</CanGrow>
> > > <Value />
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox20">
> > >
> > > <rd:DefaultName>textbox20</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop> </Style>
> > > <ZIndex>4</ZIndex>
> > > <CanGrow>true</CanGrow>
> > > <Value />
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox21">
> > >
> > > <rd:DefaultName>textbox21</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop> </Style>
> > > <ZIndex>3</ZIndex>
> > > <CanGrow>true</CanGrow>
> > > <Value />
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > </TableCells>
> > > <Height>0.25in</Height>
> > > </TableRow>
> > > </TableRows>
> > > </Footer>
> > > <Grouping Name="table1_Group2">
> > > <GroupExpressions>
> > >
> > > <GroupExpression>=Fields!CompanyName.Value</GroupExpression>
> > > </GroupExpressions> </Grouping>
> > > <Header>
> > > <TableRows>
> > > <TableRow>
> > > <Visibility>
> > > <Hidden>=iif(
> > > Parameters!SortOrder.Value="Company",True,
> > > Parameters!SuppressDrildown.Value )</Hidden>
> > > <ToggleItem>textbox6</ToggleItem> </Visibility>
> > > <TableCells>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox16">
> > >
> > > <rd:DefaultName>textbox16</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <VerticalAlign>Middle</VerticalAlign>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop> </Style>
> > > <ZIndex>14</ZIndex>
> > > <CanGrow>true</CanGrow>
> > > <Value />
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="CompanyName">
> > >
> > > <rd:DefaultName>CompanyName</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop> </Style>
> > > <ZIndex>13</ZIndex>
> > > <CanGrow>true</CanGrow>
> > > <Value>=Fields!CompanyName.Value</Value>
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox18">
> > >
> > > <rd:DefaultName>textbox18</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop> </Style>
> > > <ZIndex>12</ZIndex>
> > > <CanGrow>true</CanGrow>
> > > <Value />
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > </TableCells>
> > > <Height>0.25in</Height>
> > > </TableRow>
> > > </TableRows>
> > > </Header>
> > > </TableGroup>
> > > </TableGroups>
> > > <Width>5.95833in</Width>
> > > <Details>
> > > <TableRows>
> > > <TableRow>
> > > <Visibility>
> > >
> > > <Hidden>=Parameters!SuppressDrildown.Value</Hidden>
> > > <ToggleItem>textbox6</ToggleItem> </Visibility>
> > > <TableCells>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox4">
> > > <rd:DefaultName>textbox4</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop>
> > > </Style>
> > > <ZIndex>2</ZIndex>
> > > <CanGrow>true</CanGrow>
> > > <Value />
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox5">
> > > <rd:DefaultName>textbox5</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop>
> > > </Style>
> > > <ZIndex>1</ZIndex>
> > > <CanGrow>true</CanGrow>
> > > <Value />
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="Phone">
> > > <rd:DefaultName>Phone</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop>
> > > </Style>
> > > <CanGrow>true</CanGrow>
> > > <Value>=Fields!Phone.Value</Value>
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > </TableCells>
> > > <Height>0.25in</Height>
> > > </TableRow>
> > > </TableRows>
> > > </Details>
> > > <Style />
> > > <Header>
> > > <TableRows>
> > > <TableRow>
> > > <TableCells>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox1">
> > > <rd:DefaultName>textbox1</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop>
> > > </Style>
> > > <ZIndex>19</ZIndex>
> > > <CanGrow>true</CanGrow>
> > > <Value>Sort Order</Value>
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox2">
> > > <rd:DefaultName>textbox2</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop>
> > > </Style>
> > > <ZIndex>18</ZIndex>
> > > <CanGrow>true</CanGrow>
> > > <Value>Company Name</Value>
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox3">
> > > <rd:DefaultName>textbox3</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop>
> > > </Style>
> > > <ZIndex>17</ZIndex>
> > > <CanGrow>true</CanGrow>
> > > <Value>Phone</Value>
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > </TableCells>
> > > <Height>0.25in</Height>
> > > </TableRow>
> > > </TableRows>
> > > <RepeatOnNewPage>true</RepeatOnNewPage>
> > > </Header>
> > > <TableColumns>
> > > <TableColumn>
> > > <Width>1.625in</Width>
> > > </TableColumn>
> > > <TableColumn>
> > > <Width>2.16667in</Width>
> > > </TableColumn>
> > > <TableColumn>
> > > <Width>2.16667in</Width>
> > > </TableColumn>
> > > </TableColumns>
> > > <Footer>
> > > <TableRows>
> > > <TableRow>
> > > <TableCells>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox7">
> > > <rd:DefaultName>textbox7</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop>
> > > </Style>
> > > <ZIndex>11</ZIndex>
> > > <CanGrow>true</CanGrow>
> > > <Value />
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox8">
> > > <rd:DefaultName>textbox8</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop>
> > > </Style>
> > > <ZIndex>10</ZIndex>
> > > <CanGrow>true</CanGrow>
> > > <Value />
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > <TableCell>
> > > <ReportItems>
> > > <Textbox Name="textbox9">
> > > <rd:DefaultName>textbox9</rd:DefaultName>
> > > <Style>
> > > <PaddingBottom>2pt</PaddingBottom>
> > > <PaddingLeft>2pt</PaddingLeft>
> > > <PaddingRight>2pt</PaddingRight>
> > > <PaddingTop>2pt</PaddingTop>
> > > </Style>
> > > <ZIndex>9</ZIndex>
> > > <CanGrow>true</CanGrow>
> > > <Value />
> > > </Textbox>
> > > </ReportItems>
> > > </TableCell>
> > > </TableCells>
> > > <Height>0.25in</Height>
> > > </TableRow>
> > > </TableRows>
> > > </Footer>
> > > </Table>
> > > </ReportItems>
> > > <Height>1.75in</Height>
> > > <Style />
> > > </Body>
> > > <rd:DrawGrid>true</rd:DrawGrid>
> > > <DataSets>
> > > <DataSet Name="DataSet1">
> > > <Fields>
> > > <Field Name="CustomerID">
> > > <DataField>CustomerID</DataField>
> > > <rd:TypeName>System.String</rd:TypeName>
> > > </Field>
> > > <Field Name="CompanyName">
> > > <DataField>CompanyName</DataField>
> > > <rd:TypeName>System.String</rd:TypeName>
> > > </Field>
> > > <Field Name="ContactName">
> > > <DataField>ContactName</DataField>
> > > <rd:TypeName>System.String</rd:TypeName>
> > > </Field>
> > > <Field Name="ContactTitle">
> > > <DataField>ContactTitle</DataField>
> > > <rd:TypeName>System.String</rd:TypeName>
> > > </Field>
> > > <Field Name="Address">
> > > <DataField>Address</DataField>
> > > <rd:TypeName>System.String</rd:TypeName>
> > > </Field>
> > > <Field Name="City">
> > > <DataField>City</DataField>
> > > <rd:TypeName>System.String</rd:TypeName>
> > > </Field>
> > > <Field Name="Region">
> > > <DataField>Region</DataField>
> > > <rd:TypeName>System.String</rd:TypeName>
> > > </Field>
> > > <Field Name="PostalCode">
> > > <DataField>PostalCode</DataField>
> > > <rd:TypeName>System.String</rd:TypeName>
> > > </Field>
> > > <Field Name="Country">
> > > <DataField>Country</DataField>
> > > <rd:TypeName>System.String</rd:TypeName>
> > > </Field>
> > > <Field Name="Phone">
> > > <DataField>Phone</DataField>
> > > <rd:TypeName>System.String</rd:TypeName>
> > > </Field>
> > > <Field Name="Fax">
> > > <DataField>Fax</DataField>
> > > <rd:TypeName>System.String</rd:TypeName>
> > > </Field>
> > > </Fields>
> > > <Query>
> > > <DataSourceName>Northwind</DataSourceName>
> > > <CommandText>SELECT * FROM Customers</CommandText>
> > > <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
> > > </Query>
> > > </DataSet>
> > > </DataSets>
> > > <Language>en-US</Language>
> > > <RightMargin>1in</RightMargin>
> > > <BottomMargin>1in</BottomMargin>
> > > <TopMargin>1in</TopMargin>
> > > <rd:SnapToGrid>true</rd:SnapToGrid>
> > > <Width>6.5in</Width>
> > > <LeftMargin>1in</LeftMargin>
> > > <ReportParameters>
> > > <ReportParameter Name="SortOrder">
> > > <DataType>String</DataType>
> > > <DefaultValue>
> > > <Values>
> > > <Value>CompanyName</Value>
> > > </Values>
> > > </DefaultValue>
> > > <AllowBlank>true</AllowBlank>
> > > <Prompt>Sort order</Prompt>
> > > <ValidValues>
> > > <ParameterValues>
> > > <ParameterValue>
> > > <Value>CompanyName</Value>
> > > <Label>Customers</Label>
> > > </ParameterValue>
> > > <ParameterValue>
> > > <Value>ContactName</Value>
> > > <Label>Contact</Label>
> > > </ParameterValue>
> > > <ParameterValue>
> > > <Value>ContactTitle</Value>
> > > <Label>Title</Label>
> > > </ParameterValue>
> > > </ParameterValues>
> > > </ValidValues>
> > > </ReportParameter>
> > > <ReportParameter Name="SuppressDrildown">
> > > <DataType>Boolean</DataType>
> > > <DefaultValue>
> > > <Values>
> > > <Value>True</Value>
> > > </Values>
> > > </DefaultValue>
> > > <AllowBlank>true</AllowBlank>
> > > <Prompt>Use drilldown</Prompt>
> > > </ReportParameter>
> > > </ReportParameters>
> > > </Report>
> > >
> > >
> > > RRRRRRRRRRRRRDDDDDDDDDDDDDDDLLLLLLLLLLLLLLLLLL
> > >
> > >
> > > "Chris McGuigan" wrote:
> > >
> > > > VNN,
> > > > This is possible, I do it all the time. RS does this function
> > > > well, it's just not that obvious. Just perservere, you'll get
> > > > there in the end.
> > > >
> > > > Be careful WHERE you are setting these properties. You can set
> > > > them at line level and/or cell level. The differences may seem
> > > > subtle but produce completely different results.
> > > >
> > > > Set it at line level by using the row selector, this generally
> > > > works better and also transfers to Excel well.
> > > >
> > > > You can set both the initial state of the +/- symbol
> > > > programatically as well as hiding/showing a row programatically,
> > > > but these two things are completely seperate as far as RS is
> > > > concerned.
> > > >
> > > > If in the visibility tab of the advanced properties of a cell
> > > > you set the toggle image to be expanded or collapsed or use an
> > > > expression, it has absolutely no affect on any rows toggled by
> > > > that cell. It just sets the view of the toggle to + or -.
> > > >
> > > > If your rows are not behaving correctly, then the expression on
> > > > the rows 'Hidden' property is wrong. It has to evaluate to True
> > > > or False, and don't forget to start the expression with => > > >
> > > > If you are setting the visibility at cell level, you will just
> > > > get empty cells not hidden rows.
> > > >
> > > > Hope that helps.
> > > >
> > > > Regards
> > > > Chris
> > > >
> > > >
> > > > VNN wrote:
> > > >
> > > > > I tried this before I posted initially but it didn't work. The
> > > > > toggle always switches the hidden state of items. So if an
> > > > > item has the hidden initial state set to false, toggle will
> > > > > set it back to true and it doesn't take the expression into
> > > > > account. What I'm looking for is a way to set the toggle
> > > > > item in a expression, not statically assigned..
> > > > >
> > > > > "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in
> > > > > message news:%23c3GSSqEFHA.2756@.TK2MSFTNGP15.phx.gbl...
> > > > > > Although I have never done exactly what you wish , I think
> > > > > > it is doable...
> > > > > >
> > > > > > Set C to initially Visible = false
> > > > > > Set A as the Visibility Toggle for B
> > > > > > Set B as the Visibility Toggle for C, AND use an expression
> > > > > > for the
> > > > > initial
> > > > > > appearance of the toggle item
> > > > > >
> > > > > > All of this is set in the Advanced Textbox properties.
> > > > > >
> > > > > > Good luck... This sounds nice!
> > > > > >
> > > > > > --
> > > > > > Wayne Snyder, MCDBA, SQL Server MVP
> > > > > > Mariner, Charlotte, NC
> > > > > > www.mariner-usa.com
> > > > > > (Please respond only to the newsgroups.)
> > > > > >
> > > > > > I support the Professional Association of SQL Server (PASS)
> > > > > > and it's community of SQL Server professionals.
> > > > > > www.sqlpass.org
> > > > > >
> > > > > > "John R" <JohnR@.hotmail.com> wrote in message
> > > > > > news:uyXGnAIEFHA.624@.TK2MSFTNGP15.phx.gbl...
> > > > > > > I have structure like this:
> > > > > > >
> > > > > > > A1
> > > > > > > B1
> > > > > > > C11
> > > > > > > C12
> > > > > > > C13
> > > > > > >
> > > > > > > B2
> > > > > > > C21
> > > > > > > C22
> > > > > > >
> > > > > > > A2
> > > > > > >
> > > > > > > Currently, I set up so at C level, it will appear only if
> > > > > > > its value > 0.
> > > > > I
> > > > > > > would like to have a drilldown structure so when I click
> > > > > > > on A level, B level will appear but not the Cx. B will
> > > > > > > have the + only if it has child items (if one of its
> > > > > > > child items has value > 0). If B has the + sign, it
> > > > > > > indicates it has child items and when I click on the +
> > > > > > > sign, the C level appear only if its value >0.
> > > > > > >
> > > > > > > Please advice if this is doable (please show how) or this
> > > > > > > is a no-no in RS. Thanks
> > > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >