Showing posts with label structure. Show all posts
Showing posts with label structure. Show all posts

Tuesday, March 27, 2012

Dropping all Data but keeping constraints and Structure Intact!

Hi All -
I have a SQL 2000 database of 60 some tables, with constraints, indexes, PK-
FK, and other relationships on them. I would like to drop all data in all
tables, knowing that a lot of the tables have full PK-FK-PK-FK ...
relationships cascading, and indexes and such. I want to keep intact all
that is not data. So basically truncate or delete all data and leave all
table structures with all their constraints etc ..
I wonder if such a script exists? that would be a great help.
Thank You In Advance.
Wise -
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200704/1On Apr 11, 7:20 pm, "wiseteufel via SQLMonster.com" <u4067@.uwe> wrote:
> Hi All -
> I have a SQL 2000 database of 60 some tables, with constraints, indexes, PK-
> FK, and other relationships on them. I would like to drop all data in all
> tables, knowing that a lot of the tables have full PK-FK-PK-FK ...
> relationships cascading, and indexes and such. I want to keep intact all
> that is not data. So basically truncate or delete all data and leave all
> table structures with all their constraints etc ..
> I wonder if such a script exists? that would be a great help.
> Thank You In Advance.
> Wise -
> --
> Message posted via SQLMonster.comhttp://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200704/1
You can script out the entire database ( with PK,FK, INDEX ,
Constraint options) and create a new database from the script .
Posted by syn at 9:17 PM 0 comments
Labels: , , , , , , , , , , , , , , ,

Dropping all Data but keeping constraints and Structure Intact!

Hi All -
I have a SQL 2000 database of 60 some tables, with constraints, indexes, PK-
FK, and other relationships on them. I would like to drop all data in all
tables, knowing that a lot of the tables have full PK-FK-PK-FK ...
relationships cascading, and indexes and such. I want to keep intact all
that is not data. So basically truncate or delete all data and leave all
table structures with all their constraints etc ..
I wonder if such a script exists? that would be a great help.
Thank You In Advance.
Wise -
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200704/1On Apr 11, 7:20 pm, "wiseteufel via droptable.com" <u4067@.uwe> wrote:
> Hi All -
> I have a SQL 2000 database of 60 some tables, with constraints, indexes, P
K-
> FK, and other relationships on them. I would like to drop all data in all
> tables, knowing that a lot of the tables have full PK-FK-PK-FK ...
> relationships cascading, and indexes and such. I want to keep intact all
> that is not data. So basically truncate or delete all data and leave all
> table structures with all their constraints etc ..
> I wonder if such a script exists? that would be a great help.
> Thank You In Advance.
> Wise -
> --
> Message posted via droptable.comhttp://www.droptable.com/Uwe/Forums.aspx/sql-ser
ver/200704/1
You can script out the entire database ( with PK,FK, INDEX ,
Constraint options) and create a new database from the script .
Posted by syn at 9:17 PM 0 comments
Labels: , , , , , , , , , , , , , , ,

Dropping all Data but keeping constraints and Structure Intact!

Hi All -
I have a SQL 2000 database of 60 some tables, with constraints, indexes, PK-
FK, and other relationships on them. I would like to drop all data in all
tables, knowing that a lot of the tables have full PK-FK-PK-FK ...
relationships cascading, and indexes and such. I want to keep intact all
that is not data. So basically truncate or delete all data and leave all
table structures with all their constraints etc ..
I wonder if such a script exists? that would be a great help.
Thank You In Advance.
Wise -
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums.aspx/sql-server/200704/1
On Apr 11, 7:20 pm, "wiseteufel via droptable.com" <u4067@.uwe> wrote:
> Hi All -
> I have a SQL 2000 database of 60 some tables, with constraints, indexes, PK-
> FK, and other relationships on them. I would like to drop all data in all
> tables, knowing that a lot of the tables have full PK-FK-PK-FK ...
> relationships cascading, and indexes and such. I want to keep intact all
> that is not data. So basically truncate or delete all data and leave all
> table structures with all their constraints etc ..
> I wonder if such a script exists? that would be a great help.
> Thank You In Advance.
> Wise -
> --
> Message posted via droptable.comhttp://www.droptable.com/Uwe/Forums.aspx/sql-server/200704/1
You can script out the entire database ( with PK,FK, INDEX ,
Constraint options) and create a new database from the script .
Posted by syn at 9:16 PM 0 comments
Labels: , , , , , , , , , , , , , , ,

Monday, March 19, 2012

Drop publication to change table structure?

The title pretty much sums up the question: when I try to edit the table
structure, i.e., add a field or change type from int to uniqueidentifier,
the change is rejected with "cannot drop table" error.
Earl,
are you using SQL 2005 Beta 2? If so you get this message if you do the
change in the GUI but not by code. If this is SQL 2000, then you'll need to
use sp_repladdcolumn and sp_repldropcolun to make schema changes. Alering a
column is not supported directly.
rgds,
Paul Ibison, SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks for the advice Paul. It is SQL2k.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23zKN5BDyEHA.2804@.TK2MSFTNGP15.phx.gbl...
> Earl,
> are you using SQL 2005 Beta 2? If so you get this message if you do the
> change in the GUI but not by code. If this is SQL 2000, then you'll need
> to
> use sp_repladdcolumn and sp_repldropcolun to make schema changes. Alering
> a
> column is not supported directly.
> rgds,
> Paul Ibison, SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
Posted by syn at 8:50 AM 0 comments
Labels: , , , , , , , , , , , , , , , ,

Sunday, February 19, 2012

DrillThrough Report Error: rsInvalidItemPath

RS 2005 rsInvalidItemPath Error.
I am calling a drillthrough report from the ReportViewer control in a
VS 2005 web application. My report structure is as follows:
ParentReport (drillthrough)
ChildReport1(drillthrough)
ChildReport2
I can drill from Parent Report to Child1, but when I drill from Child1
to Child2, I get the following error:
The path of the item "(null)" is not valid. The path must be less than
260 characters long and must start with slash. Other restrictions
apply
Stack-Trace:
Microsoft.Reporting.WebForms.ReportServerException: The path of the
item "(null)" is not valid. The path must be less than 260 characters
long and must start with slash. Other restrictions apply.
(rsInvalidItemPath) at
Microsoft.Reporting.WebForms.ServerReport.PerformDrillthrough(String
drillthroughId, String& reportPath) at
Microsoft.Reporting.WebForms.ReportActionHandler.HandleDrillthrough(String
drillthroughID) at
Microsoft.Reporting.WebForms.ReportActionHandler.HandleAction(String
actionType, String actionParam, Int32& currentPage, Boolean&
pageSetByEvent, String& navigationID, String& searchText, Int32&
searchStartPage, String& alertMessage, Report& targetReport) at
Microsoft.Reporting.WebForms.ReportViewer.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
eventArgument)
Report Path: /screensave/screensave
Report URL: http://myserver/reportserver
IsDrillThrough: True
I am passing two parameters.
Any recommendations would be much appreciated.
Thanks.On Mar 20, 2:25 pm, "Rob" <rtemp...@.gmail.com> wrote:
> RS 2005 rsInvalidItemPath Error.
> I am calling a drillthrough report from the ReportViewer control in a
> VS 2005 web application. My report structure is as follows:
> ParentReport (drillthrough)
> ChildReport1(drillthrough)
> ChildReport2
> I can drill from Parent Report to Child1, but when I drill from Child1
> to Child2, I get the following error:
> The path of the item "(null)" is not valid. The path must be less than
> 260 characters long and must start with slash. Other restrictions
> apply
> Stack-Trace:
> Microsoft.Reporting.WebForms.ReportServerException: The path of the
> item "(null)" is not valid. The path must be less than 260 characters
> long and must start with slash. Other restrictions apply.
> (rsInvalidItemPath) at
> Microsoft.Reporting.WebForms.ServerReport.PerformDrillthrough(String
> drillthroughId, String& reportPath) at
> Microsoft.Reporting.WebForms.ReportActionHandler.HandleDrillthrough(String
> drillthroughID) at
> Microsoft.Reporting.WebForms.ReportActionHandler.HandleAction(String
> actionType, String actionParam, Int32& currentPage, Boolean&
> pageSetByEvent, String& navigationID, String& searchText, Int32&
> searchStartPage, String& alertMessage, Report& targetReport) at
> Microsoft.Reporting.WebForms.ReportViewer.System.Web.UI.IPostBackEventHan=dl=ADer.RaisePostBackEvent(String
> eventArgument)
> Report Path: /screensave/screensave
> Report URL:http://myserver/reportserver
> IsDrillThrough: True
> I am passing two parameters.
> Any recommendations would be much appreciated.
> Thanks.
Just to add one more thing, when I run this from Report Manager which
is located on the same machine as the Report Server, I do not get this
error. It must be in the exchange between the reportviewer control on
the web app and the web service on the reportserver. Does anyone know
how this connection takes place in a drill down scenario? I assume
that when the web application (with reportviewer control) makes a call
to the web service, it opens the authenticated connection. Then at
each drill down event, does it make a round trip back to the web app?
It is on the third round trip that I see the error.
Thanks again..|||Hi Rob,
I am getting a similar problem as well. What happens in my case is,
I have a parent report and from it I open the drill down. This works fine as
you pointed out.
I have kept an textbox in the drilled down report which has a hyperlink to
take it back to the parent report. This works fine on the Report server, but
fails on the Web server inside the Report viewer control.
My assumption is that as the viewer opens the page, on subsequent drill
downs, the path keeps on increasing in length and eventually goes above limit.
I will let you know if I find any solution for this. Please keep me posted
as well if you get any solutions yourself.
Harsh
"Rob" wrote:
> On Mar 20, 2:25 pm, "Rob" <rtemp...@.gmail.com> wrote:
> > RS 2005 rsInvalidItemPath Error.
> >
> > I am calling a drillthrough report from the ReportViewer control in a
> > VS 2005 web application. My report structure is as follows:
> >
> > ParentReport (drillthrough)
> > ChildReport1(drillthrough)
> > ChildReport2
> >
> > I can drill from Parent Report to Child1, but when I drill from Child1
> > to Child2, I get the following error:
> >
> > The path of the item "(null)" is not valid. The path must be less than
> > 260 characters long and must start with slash. Other restrictions
> > apply
> >
> > Stack-Trace:
> > Microsoft.Reporting.WebForms.ReportServerException: The path of the
> > item "(null)" is not valid. The path must be less than 260 characters
> > long and must start with slash. Other restrictions apply.
> > (rsInvalidItemPath) at
> > Microsoft.Reporting.WebForms.ServerReport.PerformDrillthrough(String
> > drillthroughId, String& reportPath) at
> > Microsoft.Reporting.WebForms.ReportActionHandler.HandleDrillthrough(String
> > drillthroughID) at
> > Microsoft.Reporting.WebForms.ReportActionHandler.HandleAction(String
> > actionType, String actionParam, Int32& currentPage, Boolean&
> > pageSetByEvent, String& navigationID, String& searchText, Int32&
> > searchStartPage, String& alertMessage, Report& targetReport) at
> > Microsoft.Reporting.WebForms.ReportViewer.System.Web.UI.IPostBackEventHandl­er.RaisePostBackEvent(String
> > eventArgument)
> >
> > Report Path: /screensave/screensave
> > Report URL:http://myserver/reportserver
> > IsDrillThrough: True
> >
> > I am passing two parameters.
> >
> > Any recommendations would be much appreciated.
> >
> > Thanks.
> Just to add one more thing, when I run this from Report Manager which
> is located on the same machine as the Report Server, I do not get this
> error. It must be in the exchange between the reportviewer control on
> the web app and the web service on the reportserver. Does anyone know
> how this connection takes place in a drill down scenario? I assume
> that when the web application (with reportviewer control) makes a call
> to the web service, it opens the authenticated connection. Then at
> each drill down event, does it make a round trip back to the web app?
> It is on the third round trip that I see the error.
> Thanks again..
>
Posted by syn at 3:34 AM 0 comments
Labels: , , , , , , , , , , , , , , ,

Friday, February 17, 2012

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
> > > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >
Posted by syn at 2:38 AM 0 comments
Labels: , , , , , , , , , , , , , , ,
Subscribe to: Posts (Atom)