I'm hoping that someone can help me with a sql 6.5 issue.
I have a couple of tables which would appear to be corrupt. dbcc checkdb
throws up the following:
attempt to fetch logical page 1012488 in database 'xxxxx' belongs to object
'0', not to object 'tableyyyyy'.
and a checkalloc gives the following error:
Table Corrupt: object id does not match between extent in allocation page
and Sysindexes; check the following extent: alloc pg#=1012480 extent#=1012488
object id on extent=0 (object name = 0) object id in Sysindexes=291232538
(object name = tableyyyy)
i have managed to bcp all the data into a new table so i thought that all
was looking good. now when i try to delete the original table through
enterprise manager it disapperas, but after a refresh its there again!
i thought the problem with the table not dropping might have been due to a
foreign key so i ran a truncate table command, and this produced an even more
bizarre result!:
Could not truncate table 'tableyyyy' because there is not enough room in the
log to record the deallocation of all of the index and data pages.
can anyone suggest how i can drop these problem tables?
Been a while since I last used 6.5, but if you are trying to get rid of the
table, could run DROP TABLE command and see what you get?
Eg:
DROP TABLE TableNameHere
GO
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"rarara" <rarara@.discussions.microsoft.com> wrote in message
news:FB74A6B2-D5D4-47D2-BCE1-C408F8FBC203@.microsoft.com...
I'm hoping that someone can help me with a sql 6.5 issue.
I have a couple of tables which would appear to be corrupt. dbcc checkdb
throws up the following:
attempt to fetch logical page 1012488 in database 'xxxxx' belongs to object
'0', not to object 'tableyyyyy'.
and a checkalloc gives the following error:
Table Corrupt: object id does not match between extent in allocation page
and Sysindexes; check the following extent: alloc pg#=1012480
extent#=1012488
object id on extent=0 (object name = 0) object id in Sysindexes=291232538
(object name = tableyyyy)
i have managed to bcp all the data into a new table so i thought that all
was looking good. now when i try to delete the original table through
enterprise manager it disapperas, but after a refresh its there again!
i thought the problem with the table not dropping might have been due to a
foreign key so i ran a truncate table command, and this produced an even
more
bizarre result!:
Could not truncate table 'tableyyyy' because there is not enough room in the
log to record the deallocation of all of the index and data pages.
can anyone suggest how i can drop these problem tables?
|||Hi,
Before dropping try doing:-
1. Create a new database
2. Create the table and try to BCP IN the data which you BCP OUT
Once you find you can load the data then you could drop the table from ISQLW
using
Drop table <TABLE_NAME>
After that create the table with dependancies and BCP IN the data.
Thanks
Hari
SQL Server MVP
"rarara" <rarara@.discussions.microsoft.com> wrote in message
news:FB74A6B2-D5D4-47D2-BCE1-C408F8FBC203@.microsoft.com...
> I'm hoping that someone can help me with a sql 6.5 issue.
> I have a couple of tables which would appear to be corrupt. dbcc checkdb
> throws up the following:
> attempt to fetch logical page 1012488 in database 'xxxxx' belongs to
> object
> '0', not to object 'tableyyyyy'.
> and a checkalloc gives the following error:
> Table Corrupt: object id does not match between extent in allocation page
> and Sysindexes; check the following extent: alloc pg#=1012480
> extent#=1012488
> object id on extent=0 (object name = 0) object id in Sysindexes=291232538
> (object name = tableyyyy)
> i have managed to bcp all the data into a new table so i thought that all
> was looking good. now when i try to delete the original table through
> enterprise manager it disapperas, but after a refresh its there again!
> i thought the problem with the table not dropping might have been due to a
> foreign key so i ran a truncate table command, and this produced an even
> more
> bizarre result!:
> Could not truncate table 'tableyyyy' because there is not enough room in
> the
> log to record the deallocation of all of the index and data pages.
> can anyone suggest how i can drop these problem tables?
Showing posts with label appear. Show all posts
Showing posts with label appear. Show all posts
Tuesday, March 27, 2012
dropping corrupt tables?
I'm hoping that someone can help me with a sql 6.5 issue.
I have a couple of tables which would appear to be corrupt. dbcc checkdb
throws up the following:
attempt to fetch logical page 1012488 in database 'xxxxx' belongs to object
'0', not to object 'tableyyyyy'.
and a checkalloc gives the following error:
Table Corrupt: object id does not match between extent in allocation page
and Sysindexes; check the following extent: alloc pg#=1012480 extent#=101248
8
object id on extent=0 (object name = 0) object id in Sysindexes=291232538
(object name = tableyyyy)
i have managed to bcp all the data into a new table so i thought that all
was looking good. now when i try to delete the original table through
enterprise manager it disapperas, but after a refresh its there again!
i thought the problem with the table not dropping might have been due to a
foreign key so i ran a truncate table command, and this produced an even mor
e
bizarre result!:
Could not truncate table 'tableyyyy' because there is not enough room in the
log to record the deallocation of all of the index and data pages.
can anyone suggest how i can drop these problem tables?Been a while since I last used 6.5, but if you are trying to get rid of the
table, could run DROP TABLE command and see what you get?
Eg:
DROP TABLE TableNameHere
GO
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"rarara" <rarara@.discussions.microsoft.com> wrote in message
news:FB74A6B2-D5D4-47D2-BCE1-C408F8FBC203@.microsoft.com...
I'm hoping that someone can help me with a sql 6.5 issue.
I have a couple of tables which would appear to be corrupt. dbcc checkdb
throws up the following:
attempt to fetch logical page 1012488 in database 'xxxxx' belongs to object
'0', not to object 'tableyyyyy'.
and a checkalloc gives the following error:
Table Corrupt: object id does not match between extent in allocation page
and Sysindexes; check the following extent: alloc pg#=1012480
extent#=1012488
object id on extent=0 (object name = 0) object id in Sysindexes=291232538
(object name = tableyyyy)
i have managed to bcp all the data into a new table so i thought that all
was looking good. now when i try to delete the original table through
enterprise manager it disapperas, but after a refresh its there again!
i thought the problem with the table not dropping might have been due to a
foreign key so i ran a truncate table command, and this produced an even
more
bizarre result!:
Could not truncate table 'tableyyyy' because there is not enough room in the
log to record the deallocation of all of the index and data pages.
can anyone suggest how i can drop these problem tables?|||Hi,
Before dropping try doing:-
1. Create a new database
2. Create the table and try to BCP IN the data which you BCP OUT
Once you find you can load the data then you could drop the table from ISQLW
using
Drop table <TABLE_NAME>
After that create the table with dependancies and BCP IN the data.
Thanks
Hari
SQL Server MVP
"rarara" <rarara@.discussions.microsoft.com> wrote in message
news:FB74A6B2-D5D4-47D2-BCE1-C408F8FBC203@.microsoft.com...
> I'm hoping that someone can help me with a sql 6.5 issue.
> I have a couple of tables which would appear to be corrupt. dbcc checkdb
> throws up the following:
> attempt to fetch logical page 1012488 in database 'xxxxx' belongs to
> object
> '0', not to object 'tableyyyyy'.
> and a checkalloc gives the following error:
> Table Corrupt: object id does not match between extent in allocation page
> and Sysindexes; check the following extent: alloc pg#=1012480
> extent#=1012488
> object id on extent=0 (object name = 0) object id in Sysindexes=291232538
> (object name = tableyyyy)
> i have managed to bcp all the data into a new table so i thought that all
> was looking good. now when i try to delete the original table through
> enterprise manager it disapperas, but after a refresh its there again!
> i thought the problem with the table not dropping might have been due to a
> foreign key so i ran a truncate table command, and this produced an even
> more
> bizarre result!:
> Could not truncate table 'tableyyyy' because there is not enough room in
> the
> log to record the deallocation of all of the index and data pages.
> can anyone suggest how i can drop these problem tables?sql
I have a couple of tables which would appear to be corrupt. dbcc checkdb
throws up the following:
attempt to fetch logical page 1012488 in database 'xxxxx' belongs to object
'0', not to object 'tableyyyyy'.
and a checkalloc gives the following error:
Table Corrupt: object id does not match between extent in allocation page
and Sysindexes; check the following extent: alloc pg#=1012480 extent#=101248
8
object id on extent=0 (object name = 0) object id in Sysindexes=291232538
(object name = tableyyyy)
i have managed to bcp all the data into a new table so i thought that all
was looking good. now when i try to delete the original table through
enterprise manager it disapperas, but after a refresh its there again!
i thought the problem with the table not dropping might have been due to a
foreign key so i ran a truncate table command, and this produced an even mor
e
bizarre result!:
Could not truncate table 'tableyyyy' because there is not enough room in the
log to record the deallocation of all of the index and data pages.
can anyone suggest how i can drop these problem tables?Been a while since I last used 6.5, but if you are trying to get rid of the
table, could run DROP TABLE command and see what you get?
Eg:
DROP TABLE TableNameHere
GO
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"rarara" <rarara@.discussions.microsoft.com> wrote in message
news:FB74A6B2-D5D4-47D2-BCE1-C408F8FBC203@.microsoft.com...
I'm hoping that someone can help me with a sql 6.5 issue.
I have a couple of tables which would appear to be corrupt. dbcc checkdb
throws up the following:
attempt to fetch logical page 1012488 in database 'xxxxx' belongs to object
'0', not to object 'tableyyyyy'.
and a checkalloc gives the following error:
Table Corrupt: object id does not match between extent in allocation page
and Sysindexes; check the following extent: alloc pg#=1012480
extent#=1012488
object id on extent=0 (object name = 0) object id in Sysindexes=291232538
(object name = tableyyyy)
i have managed to bcp all the data into a new table so i thought that all
was looking good. now when i try to delete the original table through
enterprise manager it disapperas, but after a refresh its there again!
i thought the problem with the table not dropping might have been due to a
foreign key so i ran a truncate table command, and this produced an even
more
bizarre result!:
Could not truncate table 'tableyyyy' because there is not enough room in the
log to record the deallocation of all of the index and data pages.
can anyone suggest how i can drop these problem tables?|||Hi,
Before dropping try doing:-
1. Create a new database
2. Create the table and try to BCP IN the data which you BCP OUT
Once you find you can load the data then you could drop the table from ISQLW
using
Drop table <TABLE_NAME>
After that create the table with dependancies and BCP IN the data.
Thanks
Hari
SQL Server MVP
"rarara" <rarara@.discussions.microsoft.com> wrote in message
news:FB74A6B2-D5D4-47D2-BCE1-C408F8FBC203@.microsoft.com...
> I'm hoping that someone can help me with a sql 6.5 issue.
> I have a couple of tables which would appear to be corrupt. dbcc checkdb
> throws up the following:
> attempt to fetch logical page 1012488 in database 'xxxxx' belongs to
> object
> '0', not to object 'tableyyyyy'.
> and a checkalloc gives the following error:
> Table Corrupt: object id does not match between extent in allocation page
> and Sysindexes; check the following extent: alloc pg#=1012480
> extent#=1012488
> object id on extent=0 (object name = 0) object id in Sysindexes=291232538
> (object name = tableyyyy)
> i have managed to bcp all the data into a new table so i thought that all
> was looking good. now when i try to delete the original table through
> enterprise manager it disapperas, but after a refresh its there again!
> i thought the problem with the table not dropping might have been due to a
> foreign key so i ran a truncate table command, and this produced an even
> more
> bizarre result!:
> Could not truncate table 'tableyyyy' because there is not enough room in
> the
> log to record the deallocation of all of the index and data pages.
> can anyone suggest how i can drop these problem tables?sql
dropping corrupt tables?
I'm hoping that someone can help me with a sql 6.5 issue.
I have a couple of tables which would appear to be corrupt. dbcc checkdb
throws up the following:
attempt to fetch logical page 1012488 in database 'xxxxx' belongs to object
'0', not to object 'tableyyyyy'.
and a checkalloc gives the following error:
Table Corrupt: object id does not match between extent in allocation page
and Sysindexes; check the following extent: alloc pg#=1012480 extent#=1012488
object id on extent=0 (object name = 0) object id in Sysindexes=291232538
(object name = tableyyyy)
i have managed to bcp all the data into a new table so i thought that all
was looking good. now when i try to delete the original table through
enterprise manager it disapperas, but after a refresh its there again!
i thought the problem with the table not dropping might have been due to a
foreign key so i ran a truncate table command, and this produced an even more
bizarre result!:
Could not truncate table 'tableyyyy' because there is not enough room in the
log to record the deallocation of all of the index and data pages.
can anyone suggest how i can drop these problem tables?Been a while since I last used 6.5, but if you are trying to get rid of the
table, could run DROP TABLE command and see what you get?
Eg:
DROP TABLE TableNameHere
GO
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"rarara" <rarara@.discussions.microsoft.com> wrote in message
news:FB74A6B2-D5D4-47D2-BCE1-C408F8FBC203@.microsoft.com...
I'm hoping that someone can help me with a sql 6.5 issue.
I have a couple of tables which would appear to be corrupt. dbcc checkdb
throws up the following:
attempt to fetch logical page 1012488 in database 'xxxxx' belongs to object
'0', not to object 'tableyyyyy'.
and a checkalloc gives the following error:
Table Corrupt: object id does not match between extent in allocation page
and Sysindexes; check the following extent: alloc pg#=1012480
extent#=1012488
object id on extent=0 (object name = 0) object id in Sysindexes=291232538
(object name = tableyyyy)
i have managed to bcp all the data into a new table so i thought that all
was looking good. now when i try to delete the original table through
enterprise manager it disapperas, but after a refresh its there again!
i thought the problem with the table not dropping might have been due to a
foreign key so i ran a truncate table command, and this produced an even
more
bizarre result!:
Could not truncate table 'tableyyyy' because there is not enough room in the
log to record the deallocation of all of the index and data pages.
can anyone suggest how i can drop these problem tables?|||Hi,
Before dropping try doing:-
1. Create a new database
2. Create the table and try to BCP IN the data which you BCP OUT
Once you find you can load the data then you could drop the table from ISQLW
using
Drop table <TABLE_NAME>
After that create the table with dependancies and BCP IN the data.
Thanks
Hari
SQL Server MVP
"rarara" <rarara@.discussions.microsoft.com> wrote in message
news:FB74A6B2-D5D4-47D2-BCE1-C408F8FBC203@.microsoft.com...
> I'm hoping that someone can help me with a sql 6.5 issue.
> I have a couple of tables which would appear to be corrupt. dbcc checkdb
> throws up the following:
> attempt to fetch logical page 1012488 in database 'xxxxx' belongs to
> object
> '0', not to object 'tableyyyyy'.
> and a checkalloc gives the following error:
> Table Corrupt: object id does not match between extent in allocation page
> and Sysindexes; check the following extent: alloc pg#=1012480
> extent#=1012488
> object id on extent=0 (object name = 0) object id in Sysindexes=291232538
> (object name = tableyyyy)
> i have managed to bcp all the data into a new table so i thought that all
> was looking good. now when i try to delete the original table through
> enterprise manager it disapperas, but after a refresh its there again!
> i thought the problem with the table not dropping might have been due to a
> foreign key so i ran a truncate table command, and this produced an even
> more
> bizarre result!:
> Could not truncate table 'tableyyyy' because there is not enough room in
> the
> log to record the deallocation of all of the index and data pages.
> can anyone suggest how i can drop these problem tables?
I have a couple of tables which would appear to be corrupt. dbcc checkdb
throws up the following:
attempt to fetch logical page 1012488 in database 'xxxxx' belongs to object
'0', not to object 'tableyyyyy'.
and a checkalloc gives the following error:
Table Corrupt: object id does not match between extent in allocation page
and Sysindexes; check the following extent: alloc pg#=1012480 extent#=1012488
object id on extent=0 (object name = 0) object id in Sysindexes=291232538
(object name = tableyyyy)
i have managed to bcp all the data into a new table so i thought that all
was looking good. now when i try to delete the original table through
enterprise manager it disapperas, but after a refresh its there again!
i thought the problem with the table not dropping might have been due to a
foreign key so i ran a truncate table command, and this produced an even more
bizarre result!:
Could not truncate table 'tableyyyy' because there is not enough room in the
log to record the deallocation of all of the index and data pages.
can anyone suggest how i can drop these problem tables?Been a while since I last used 6.5, but if you are trying to get rid of the
table, could run DROP TABLE command and see what you get?
Eg:
DROP TABLE TableNameHere
GO
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"rarara" <rarara@.discussions.microsoft.com> wrote in message
news:FB74A6B2-D5D4-47D2-BCE1-C408F8FBC203@.microsoft.com...
I'm hoping that someone can help me with a sql 6.5 issue.
I have a couple of tables which would appear to be corrupt. dbcc checkdb
throws up the following:
attempt to fetch logical page 1012488 in database 'xxxxx' belongs to object
'0', not to object 'tableyyyyy'.
and a checkalloc gives the following error:
Table Corrupt: object id does not match between extent in allocation page
and Sysindexes; check the following extent: alloc pg#=1012480
extent#=1012488
object id on extent=0 (object name = 0) object id in Sysindexes=291232538
(object name = tableyyyy)
i have managed to bcp all the data into a new table so i thought that all
was looking good. now when i try to delete the original table through
enterprise manager it disapperas, but after a refresh its there again!
i thought the problem with the table not dropping might have been due to a
foreign key so i ran a truncate table command, and this produced an even
more
bizarre result!:
Could not truncate table 'tableyyyy' because there is not enough room in the
log to record the deallocation of all of the index and data pages.
can anyone suggest how i can drop these problem tables?|||Hi,
Before dropping try doing:-
1. Create a new database
2. Create the table and try to BCP IN the data which you BCP OUT
Once you find you can load the data then you could drop the table from ISQLW
using
Drop table <TABLE_NAME>
After that create the table with dependancies and BCP IN the data.
Thanks
Hari
SQL Server MVP
"rarara" <rarara@.discussions.microsoft.com> wrote in message
news:FB74A6B2-D5D4-47D2-BCE1-C408F8FBC203@.microsoft.com...
> I'm hoping that someone can help me with a sql 6.5 issue.
> I have a couple of tables which would appear to be corrupt. dbcc checkdb
> throws up the following:
> attempt to fetch logical page 1012488 in database 'xxxxx' belongs to
> object
> '0', not to object 'tableyyyyy'.
> and a checkalloc gives the following error:
> Table Corrupt: object id does not match between extent in allocation page
> and Sysindexes; check the following extent: alloc pg#=1012480
> extent#=1012488
> object id on extent=0 (object name = 0) object id in Sysindexes=291232538
> (object name = tableyyyy)
> i have managed to bcp all the data into a new table so i thought that all
> was looking good. now when i try to delete the original table through
> enterprise manager it disapperas, but after a refresh its there again!
> i thought the problem with the table not dropping might have been due to a
> foreign key so i ran a truncate table command, and this produced an even
> more
> bizarre result!:
> Could not truncate table 'tableyyyy' because there is not enough room in
> the
> log to record the deallocation of all of the index and data pages.
> can anyone suggest how i can drop these problem tables?
Sunday, March 25, 2012
Dropdownlist with multiple fields
How can I get two fields to appear side by side in the DropDownList? Ex. FName and LName
Thanks
Here'sone example.Sunday, February 19, 2012
Drillthrough Report with Parameters - Jump to URL not working
Hello,
I'm hoping to have a drillthrough report appear in a separate window but am
struggling to get it to work. I'm attempting to use the textbox navigation
property "Jump to URL", placing Javascript in the property field that should
render the child report in a separate window.
I can get this to work if the child report does not have parameters. But
when the child report does have parameters the child report is displayed in
the report manager UI, but all it shows is the parameter textboxes and I
need to enter the parameter data again and click "View Report" to get the
report to render. I would like the report to render in the new window
automatically.
I've seen many variations on how to get the "Jump to URL" to work and have
tried them with no luck, at least when the child report requires parameters.
Thanks in advance for any help that can be provided.
JackDo you have these parameters hidden in your "jump to" report?
"Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
> Hello,
> I'm hoping to have a drillthrough report appear in a separate window but
> am struggling to get it to work. I'm attempting to use the textbox
> navigation property "Jump to URL", placing Javascript in the property
> field that should render the child report in a separate window.
> I can get this to work if the child report does not have parameters. But
> when the child report does have parameters the child report is displayed
> in the report manager UI, but all it shows is the parameter textboxes and
> I need to enter the parameter data again and click "View Report" to get
> the report to render. I would like the report to render in the new
> window automatically.
> I've seen many variations on how to get the "Jump to URL" to work and have
> tried them with no luck, at least when the child report requires
> parameters.
> Thanks in advance for any help that can be provided.
> Jack
>|||Thanks Mark. I did not have the hidden property set. Setting the hidden
property on now causes an error to be displayed in the child window
indicating the parameter value wasn't provided. "The 'Param1' parameter
is missing a value"
Here's the java I'm trying to use, which works fine w/o the parameter(Parent
and Child report reside in the same folder).
="javascript:void(window.open('Report.aspx?ItemPath=%2fReportFolder%2fDrillThroughSubReport&Param1="
& Fields!MyParamField.Value & "'))"
Thanks again,
Jack
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:u3wGOL9nIHA.1240@.TK2MSFTNGP02.phx.gbl...
> Do you have these parameters hidden in your "jump to" report?
> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
> news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
>> Hello,
>> I'm hoping to have a drillthrough report appear in a separate window but
>> am struggling to get it to work. I'm attempting to use the textbox
>> navigation property "Jump to URL", placing Javascript in the property
>> field that should render the child report in a separate window.
>> I can get this to work if the child report does not have parameters. But
>> when the child report does have parameters the child report is displayed
>> in the report manager UI, but all it shows is the parameter textboxes and
>> I need to enter the parameter data again and click "View Report" to get
>> the report to render. I would like the report to render in the new
>> window automatically.
>> I've seen many variations on how to get the "Jump to URL" to work and
>> have tried them with no luck, at least when the child report requires
>> parameters.
>> Thanks in advance for any help that can be provided.
>> Jack
>|||This is my JS code to run some code on the back-end.
See if helps you to find right syntax:
=("javascript:void(window.open('http://localhost/some.htm?parm1=" &
Fields!gaylordid.Value & "','price',
'status=0,toolbar=0,width=630,height=700,center=yes'))")
"Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
news:e4n7qy9nIHA.4904@.TK2MSFTNGP03.phx.gbl...
> Thanks Mark. I did not have the hidden property set. Setting the
> hidden property on now causes an error to be displayed in the child window
> indicating the parameter value wasn't provided. "The 'Param1' parameter
> is missing a value"
> Here's the java I'm trying to use, which works fine w/o the
> parameter(Parent and Child report reside in the same folder).
> ="javascript:void(window.open('Report.aspx?ItemPath=%2fReportFolder%2fDrillThroughSubReport&Param1="
> & Fields!MyParamField.Value & "'))"
> Thanks again,
> Jack
>
> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
> news:u3wGOL9nIHA.1240@.TK2MSFTNGP02.phx.gbl...
>> Do you have these parameters hidden in your "jump to" report?
>> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
>> news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
>> Hello,
>> I'm hoping to have a drillthrough report appear in a separate window but
>> am struggling to get it to work. I'm attempting to use the textbox
>> navigation property "Jump to URL", placing Javascript in the property
>> field that should render the child report in a separate window.
>> I can get this to work if the child report does not have parameters.
>> But when the child report does have parameters the child report is
>> displayed in the report manager UI, but all it shows is the parameter
>> textboxes and I need to enter the parameter data again and click "View
>> Report" to get the report to render. I would like the report to render
>> in the new window automatically.
>> I've seen many variations on how to get the "Jump to URL" to work and
>> have tried them with no luck, at least when the child report requires
>> parameters.
>> Thanks in advance for any help that can be provided.
>> Jack
>>
>|||Thanks Mark. I've tried a number of different approaches with the JS
syntax and have gotten them all to work w/o parameters so I think my syntax
up to the point of calling the page/report is OK, even though our two
versions are quite different.(but JS is new to me) Also, it appears our
code to include the parameters is set up the same for the most part so I'm
thinking that may be OK too.
I've tried so many different versions of JS syntax with the same results I'm
wondering if something else isn't in play here. I'm trying to publish and
run these reports on an RS "Report Manager" website, where it appears you
may be referencing an HTML web page. Did you ever go the Report Manager
route with success so I could be certain what I'm trying to do(and what
you've done) is "doable" in that environment?(RS is new to me too)
Thanks again for your time, it's appreciated.
Jack
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:%23W3nFG%23nIHA.420@.TK2MSFTNGP02.phx.gbl...
> This is my JS code to run some code on the back-end.
> See if helps you to find right syntax:
> =("javascript:void(window.open('http://localhost/some.htm?parm1=" &
> Fields!gaylordid.Value & "','price',
> 'status=0,toolbar=0,width=630,height=700,center=yes'))")
> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
> news:e4n7qy9nIHA.4904@.TK2MSFTNGP03.phx.gbl...
>> Thanks Mark. I did not have the hidden property set. Setting the
>> hidden property on now causes an error to be displayed in the child
>> window indicating the parameter value wasn't provided. "The 'Param1'
>> parameter is missing a value"
>> Here's the java I'm trying to use, which works fine w/o the
>> parameter(Parent and Child report reside in the same folder).
>> ="javascript:void(window.open('Report.aspx?ItemPath=%2fReportFolder%2fDrillThroughSubReport&Param1="
>> & Fields!MyParamField.Value & "'))"
>> Thanks again,
>> Jack
>>
>> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
>> news:u3wGOL9nIHA.1240@.TK2MSFTNGP02.phx.gbl...
>> Do you have these parameters hidden in your "jump to" report?
>> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
>> news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
>> Hello,
>> I'm hoping to have a drillthrough report appear in a separate window
>> but am struggling to get it to work. I'm attempting to use the
>> textbox navigation property "Jump to URL", placing Javascript in the
>> property field that should render the child report in a separate
>> window.
>> I can get this to work if the child report does not have parameters.
>> But when the child report does have parameters the child report is
>> displayed in the report manager UI, but all it shows is the parameter
>> textboxes and I need to enter the parameter data again and click "View
>> Report" to get the report to render. I would like the report to
>> render in the new window automatically.
>> I've seen many variations on how to get the "Jump to URL" to work and
>> have tried them with no luck, at least when the child report requires
>> parameters.
>> Thanks in advance for any help that can be provided.
>> Jack
>>
>>
>|||I was able to get my problem resolved - thanks Mark for taking some time to
help.
The change that appears to resolve my problem was adding the "reportserver"
literal to the URL. I could reference the child report page in a variety of
different methods of JS syntax but the parameter processing wouldn't work
until I included the reportserver folder in the URL string I placed in the
Jump to URL property. Getting to my child report page by any other method
appeared to cause the parameter passing to fail.
Working JS string:
=("javascript:void(window.open('http://servername/Reportserver/Pages/Report.aspx?%2fMyReports%2fMyDrillThroughReport&Parm1="
& Fields!MyParm.Value
&"','Detail','resizeable=1,toolbar=0,status=0,menu=0,top=20,left=20,width=740,height=930'))"
)
Thanks again,
Jack
"Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
news:uVcqiQ$nIHA.3376@.TK2MSFTNGP05.phx.gbl...
> Thanks Mark. I've tried a number of different approaches with the JS
> syntax and have gotten them all to work w/o parameters so I think my
> syntax up to the point of calling the page/report is OK, even though our
> two versions are quite different.(but JS is new to me) Also, it appears
> our code to include the parameters is set up the same for the most part so
> I'm thinking that may be OK too.
>
> I've tried so many different versions of JS syntax with the same results
> I'm wondering if something else isn't in play here. I'm trying to
> publish and run these reports on an RS "Report Manager" website, where it
> appears you may be referencing an HTML web page. Did you ever go the
> Report Manager route with success so I could be certain what I'm trying to
> do(and what you've done) is "doable" in that environment?(RS is new to me
> too)
>
> Thanks again for your time, it's appreciated.
>
> Jack
>
> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
> news:%23W3nFG%23nIHA.420@.TK2MSFTNGP02.phx.gbl...
>> This is my JS code to run some code on the back-end.
>> See if helps you to find right syntax:
>> =("javascript:void(window.open('http://localhost/some.htm?parm1=" &
>> Fields!gaylordid.Value & "','price',
>> 'status=0,toolbar=0,width=630,height=700,center=yes'))")
>> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
>> news:e4n7qy9nIHA.4904@.TK2MSFTNGP03.phx.gbl...
>> Thanks Mark. I did not have the hidden property set. Setting the
>> hidden property on now causes an error to be displayed in the child
>> window indicating the parameter value wasn't provided. "The 'Param1'
>> parameter is missing a value"
>> Here's the java I'm trying to use, which works fine w/o the
>> parameter(Parent and Child report reside in the same folder).
>> ="javascript:void(window.open('Report.aspx?ItemPath=%2fReportFolder%2fDrillThroughSubReport&Param1="
>> & Fields!MyParamField.Value & "'))"
>> Thanks again,
>> Jack
>>
>> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
>> news:u3wGOL9nIHA.1240@.TK2MSFTNGP02.phx.gbl...
>> Do you have these parameters hidden in your "jump to" report?
>> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
>> news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
>> Hello,
>> I'm hoping to have a drillthrough report appear in a separate window
>> but am struggling to get it to work. I'm attempting to use the
>> textbox navigation property "Jump to URL", placing Javascript in the
>> property field that should render the child report in a separate
>> window.
>> I can get this to work if the child report does not have parameters.
>> But when the child report does have parameters the child report is
>> displayed in the report manager UI, but all it shows is the parameter
>> textboxes and I need to enter the parameter data again and click "View
>> Report" to get the report to render. I would like the report to
>> render in the new window automatically.
>> I've seen many variations on how to get the "Jump to URL" to work and
>> have tried them with no luck, at least when the child report requires
>> parameters.
>> Thanks in advance for any help that can be provided.
>> Jack
>>
>>
>>
>
I'm hoping to have a drillthrough report appear in a separate window but am
struggling to get it to work. I'm attempting to use the textbox navigation
property "Jump to URL", placing Javascript in the property field that should
render the child report in a separate window.
I can get this to work if the child report does not have parameters. But
when the child report does have parameters the child report is displayed in
the report manager UI, but all it shows is the parameter textboxes and I
need to enter the parameter data again and click "View Report" to get the
report to render. I would like the report to render in the new window
automatically.
I've seen many variations on how to get the "Jump to URL" to work and have
tried them with no luck, at least when the child report requires parameters.
Thanks in advance for any help that can be provided.
JackDo you have these parameters hidden in your "jump to" report?
"Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
> Hello,
> I'm hoping to have a drillthrough report appear in a separate window but
> am struggling to get it to work. I'm attempting to use the textbox
> navigation property "Jump to URL", placing Javascript in the property
> field that should render the child report in a separate window.
> I can get this to work if the child report does not have parameters. But
> when the child report does have parameters the child report is displayed
> in the report manager UI, but all it shows is the parameter textboxes and
> I need to enter the parameter data again and click "View Report" to get
> the report to render. I would like the report to render in the new
> window automatically.
> I've seen many variations on how to get the "Jump to URL" to work and have
> tried them with no luck, at least when the child report requires
> parameters.
> Thanks in advance for any help that can be provided.
> Jack
>|||Thanks Mark. I did not have the hidden property set. Setting the hidden
property on now causes an error to be displayed in the child window
indicating the parameter value wasn't provided. "The 'Param1' parameter
is missing a value"
Here's the java I'm trying to use, which works fine w/o the parameter(Parent
and Child report reside in the same folder).
="javascript:void(window.open('Report.aspx?ItemPath=%2fReportFolder%2fDrillThroughSubReport&Param1="
& Fields!MyParamField.Value & "'))"
Thanks again,
Jack
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:u3wGOL9nIHA.1240@.TK2MSFTNGP02.phx.gbl...
> Do you have these parameters hidden in your "jump to" report?
> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
> news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
>> Hello,
>> I'm hoping to have a drillthrough report appear in a separate window but
>> am struggling to get it to work. I'm attempting to use the textbox
>> navigation property "Jump to URL", placing Javascript in the property
>> field that should render the child report in a separate window.
>> I can get this to work if the child report does not have parameters. But
>> when the child report does have parameters the child report is displayed
>> in the report manager UI, but all it shows is the parameter textboxes and
>> I need to enter the parameter data again and click "View Report" to get
>> the report to render. I would like the report to render in the new
>> window automatically.
>> I've seen many variations on how to get the "Jump to URL" to work and
>> have tried them with no luck, at least when the child report requires
>> parameters.
>> Thanks in advance for any help that can be provided.
>> Jack
>|||This is my JS code to run some code on the back-end.
See if helps you to find right syntax:
=("javascript:void(window.open('http://localhost/some.htm?parm1=" &
Fields!gaylordid.Value & "','price',
'status=0,toolbar=0,width=630,height=700,center=yes'))")
"Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
news:e4n7qy9nIHA.4904@.TK2MSFTNGP03.phx.gbl...
> Thanks Mark. I did not have the hidden property set. Setting the
> hidden property on now causes an error to be displayed in the child window
> indicating the parameter value wasn't provided. "The 'Param1' parameter
> is missing a value"
> Here's the java I'm trying to use, which works fine w/o the
> parameter(Parent and Child report reside in the same folder).
> ="javascript:void(window.open('Report.aspx?ItemPath=%2fReportFolder%2fDrillThroughSubReport&Param1="
> & Fields!MyParamField.Value & "'))"
> Thanks again,
> Jack
>
> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
> news:u3wGOL9nIHA.1240@.TK2MSFTNGP02.phx.gbl...
>> Do you have these parameters hidden in your "jump to" report?
>> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
>> news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
>> Hello,
>> I'm hoping to have a drillthrough report appear in a separate window but
>> am struggling to get it to work. I'm attempting to use the textbox
>> navigation property "Jump to URL", placing Javascript in the property
>> field that should render the child report in a separate window.
>> I can get this to work if the child report does not have parameters.
>> But when the child report does have parameters the child report is
>> displayed in the report manager UI, but all it shows is the parameter
>> textboxes and I need to enter the parameter data again and click "View
>> Report" to get the report to render. I would like the report to render
>> in the new window automatically.
>> I've seen many variations on how to get the "Jump to URL" to work and
>> have tried them with no luck, at least when the child report requires
>> parameters.
>> Thanks in advance for any help that can be provided.
>> Jack
>>
>|||Thanks Mark. I've tried a number of different approaches with the JS
syntax and have gotten them all to work w/o parameters so I think my syntax
up to the point of calling the page/report is OK, even though our two
versions are quite different.(but JS is new to me) Also, it appears our
code to include the parameters is set up the same for the most part so I'm
thinking that may be OK too.
I've tried so many different versions of JS syntax with the same results I'm
wondering if something else isn't in play here. I'm trying to publish and
run these reports on an RS "Report Manager" website, where it appears you
may be referencing an HTML web page. Did you ever go the Report Manager
route with success so I could be certain what I'm trying to do(and what
you've done) is "doable" in that environment?(RS is new to me too)
Thanks again for your time, it's appreciated.
Jack
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:%23W3nFG%23nIHA.420@.TK2MSFTNGP02.phx.gbl...
> This is my JS code to run some code on the back-end.
> See if helps you to find right syntax:
> =("javascript:void(window.open('http://localhost/some.htm?parm1=" &
> Fields!gaylordid.Value & "','price',
> 'status=0,toolbar=0,width=630,height=700,center=yes'))")
> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
> news:e4n7qy9nIHA.4904@.TK2MSFTNGP03.phx.gbl...
>> Thanks Mark. I did not have the hidden property set. Setting the
>> hidden property on now causes an error to be displayed in the child
>> window indicating the parameter value wasn't provided. "The 'Param1'
>> parameter is missing a value"
>> Here's the java I'm trying to use, which works fine w/o the
>> parameter(Parent and Child report reside in the same folder).
>> ="javascript:void(window.open('Report.aspx?ItemPath=%2fReportFolder%2fDrillThroughSubReport&Param1="
>> & Fields!MyParamField.Value & "'))"
>> Thanks again,
>> Jack
>>
>> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
>> news:u3wGOL9nIHA.1240@.TK2MSFTNGP02.phx.gbl...
>> Do you have these parameters hidden in your "jump to" report?
>> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
>> news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
>> Hello,
>> I'm hoping to have a drillthrough report appear in a separate window
>> but am struggling to get it to work. I'm attempting to use the
>> textbox navigation property "Jump to URL", placing Javascript in the
>> property field that should render the child report in a separate
>> window.
>> I can get this to work if the child report does not have parameters.
>> But when the child report does have parameters the child report is
>> displayed in the report manager UI, but all it shows is the parameter
>> textboxes and I need to enter the parameter data again and click "View
>> Report" to get the report to render. I would like the report to
>> render in the new window automatically.
>> I've seen many variations on how to get the "Jump to URL" to work and
>> have tried them with no luck, at least when the child report requires
>> parameters.
>> Thanks in advance for any help that can be provided.
>> Jack
>>
>>
>|||I was able to get my problem resolved - thanks Mark for taking some time to
help.
The change that appears to resolve my problem was adding the "reportserver"
literal to the URL. I could reference the child report page in a variety of
different methods of JS syntax but the parameter processing wouldn't work
until I included the reportserver folder in the URL string I placed in the
Jump to URL property. Getting to my child report page by any other method
appeared to cause the parameter passing to fail.
Working JS string:
=("javascript:void(window.open('http://servername/Reportserver/Pages/Report.aspx?%2fMyReports%2fMyDrillThroughReport&Parm1="
& Fields!MyParm.Value
&"','Detail','resizeable=1,toolbar=0,status=0,menu=0,top=20,left=20,width=740,height=930'))"
)
Thanks again,
Jack
"Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
news:uVcqiQ$nIHA.3376@.TK2MSFTNGP05.phx.gbl...
> Thanks Mark. I've tried a number of different approaches with the JS
> syntax and have gotten them all to work w/o parameters so I think my
> syntax up to the point of calling the page/report is OK, even though our
> two versions are quite different.(but JS is new to me) Also, it appears
> our code to include the parameters is set up the same for the most part so
> I'm thinking that may be OK too.
>
> I've tried so many different versions of JS syntax with the same results
> I'm wondering if something else isn't in play here. I'm trying to
> publish and run these reports on an RS "Report Manager" website, where it
> appears you may be referencing an HTML web page. Did you ever go the
> Report Manager route with success so I could be certain what I'm trying to
> do(and what you've done) is "doable" in that environment?(RS is new to me
> too)
>
> Thanks again for your time, it's appreciated.
>
> Jack
>
> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
> news:%23W3nFG%23nIHA.420@.TK2MSFTNGP02.phx.gbl...
>> This is my JS code to run some code on the back-end.
>> See if helps you to find right syntax:
>> =("javascript:void(window.open('http://localhost/some.htm?parm1=" &
>> Fields!gaylordid.Value & "','price',
>> 'status=0,toolbar=0,width=630,height=700,center=yes'))")
>> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
>> news:e4n7qy9nIHA.4904@.TK2MSFTNGP03.phx.gbl...
>> Thanks Mark. I did not have the hidden property set. Setting the
>> hidden property on now causes an error to be displayed in the child
>> window indicating the parameter value wasn't provided. "The 'Param1'
>> parameter is missing a value"
>> Here's the java I'm trying to use, which works fine w/o the
>> parameter(Parent and Child report reside in the same folder).
>> ="javascript:void(window.open('Report.aspx?ItemPath=%2fReportFolder%2fDrillThroughSubReport&Param1="
>> & Fields!MyParamField.Value & "'))"
>> Thanks again,
>> Jack
>>
>> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
>> news:u3wGOL9nIHA.1240@.TK2MSFTNGP02.phx.gbl...
>> Do you have these parameters hidden in your "jump to" report?
>> "Jack Lenning" <jack.lenning@.courts.state.mn.us> wrote in message
>> news:eJemu58nIHA.548@.TK2MSFTNGP06.phx.gbl...
>> Hello,
>> I'm hoping to have a drillthrough report appear in a separate window
>> but am struggling to get it to work. I'm attempting to use the
>> textbox navigation property "Jump to URL", placing Javascript in the
>> property field that should render the child report in a separate
>> window.
>> I can get this to work if the child report does not have parameters.
>> But when the child report does have parameters the child report is
>> displayed in the report manager UI, but all it shows is the parameter
>> textboxes and I need to enter the parameter data again and click "View
>> Report" to get the report to render. I would like the report to
>> render in the new window automatically.
>> I've seen many variations on how to get the "Jump to URL" to work and
>> have tried them with no luck, at least when the child report requires
>> parameters.
>> Thanks in advance for any help that can be provided.
>> Jack
>>
>>
>>
>
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
> > > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >
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
> > > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >
Subscribe to:
Posts (Atom)