Drillthrough Functionality via Excel Add-in

Hi,

I'm using the Analysis Services Excel Add-In to query a Cube built with partitions.

When using the drilldown functionality for my current\default partition the function seems to work fine.

However, when I try to drilldown on data in the other partitions, the following error message appears:

"Unable to Drillthrough on this Cell"

Would someone please be able to shed some light on this?

Many Thanks

Jonathan Derbyshire

Jonathan_Derbyshire@.Hotmail.com

We have the same problem (also using OWC controls). do you have the solution?
if yes, please, let me know.
Thanks

Carlos
tfcarlos@.hotmail.com
|||No I'm still stuck.

If anyone can help I would be very grateful...

Thanks

Jon Derbyshire|||I think Excell can't drillthrough over partitiones.
I'm not sure but if you have more than 1 partition you can't drillthrough. Did you try to execute the drillthrough query against an ado connection?
It's a large cube?
Do you have to show many columns in drillthrough?
Because you can make some calculated measures to solve this (be carefull with the result).|||Why do you think that Excel cant drillthrough over partitions? Have you read this somewehere or are you just speculating?

I can drillthrough - but only on the current/default partition...

Its a Medium to large cube.

Drillthrough shows about 20 columns, but I've tried limiting it to 5 and still the same error.|||I'm speculating.
But I found the solution:
In addition to enabling drillthrough at the cube level, you can also modify the options on each individual partition in cubes that contain more than one partition. You can access a dialog box analogous to the one in Figure B through the Partition Wizard—to access the Partition Wizard, right-click the partition and select Edit from the context menu—by clicking the Advanced Settings button and Drillthrough Options. The resulting Partition Drillthrough Options dialog box lets you change the columns and filter to use when creating drillthrough data from that partition. The ability to set drillthrough options on individual partitions means that if you execute a drillthrough operation on a cell that aggregates data from more than one partition, each partition returns its own result set and the columns in those result sets can differ from one another. Application developers need to be aware of this behavior so that they can display the results accordingly. The administrator's next task, configuring drillthrough security, requires that you use the Cube Role Manager dialog box and click the Drillthrough setting for the role you want to grant access to. Each role has a security setting, called Allow Drillthrough, that you can select to let that role execute the queries that perform a drillthrough operation. After you enable drillthrough and configure security, you can implement drillthrough for applications.
Text From Implementing Drillthrough for Developers in http://www.windowsitpro.com/Articles/Print.cfm?ArticleID=41679|||Thanks - I've been through and it appears that drillthrough was already definitely enabled...

It still doesnt enable me to drillthrough as I wish. I've posted my question on the site you provided in an attempt for more help.|||I want to ask you.
Are you using sql 2000 or sql 2005?
If you are using sql 2005, are you connecting from excel in the server or in a remote computer?
If you are connecting from a remote computer, what have you installed in the computer to making it works?
I can't connect from a remote computer with excel to AS 2005.
Thanks in advance|||2000 version

drilldown values

When you use the action property of a text box for drill down, how do you
pass the selected value to the report? or is sql reporting smart enough to
know?
--
Thanks,
CGWNever mind... found the button for parameters.
"CGW" wrote:
> When you use the action property of a text box for drill down, how do you
> pass the selected value to the report? or is sql reporting smart enough to
> know?
> --
> Thanks,
> CGW

Drilldown reports

I want to show a list of accounts and when a user clicks on one show
account's details.
What is a best way of approaching that?
ThanksIf you generate a dataset with all the accounts' details you could then use a
table control with grouping by account. You would hide the detail line by
default but allow this to be toggled from a textbox on the group
header/footer.
HTH
--
Magendo_man
Freelance SQL Reporting Services developer
Stirling, Scotland
"Mark Goldin" wrote:
> I want to show a list of accounts and when a user clicks on one show
> account's details.
> What is a best way of approaching that?
> Thanks
>
>|||But since I have a detailed report already how can I create report with
links to the detailed report?
"magendo_man" <sql@.kappa.co.uk.(donotspam)> wrote in message
news:FEE2EC61-3596-4C90-92FE-C1A1EDF5DF6E@.microsoft.com...
> If you generate a dataset with all the accounts' details you could then
> use a
> table control with grouping by account. You would hide the detail line by
> default but allow this to be toggled from a textbox on the group
> header/footer.
> HTH
> --
> Magendo_man
> Freelance SQL Reporting Services developer
> Stirling, Scotland
>
> "Mark Goldin" wrote:
>> I want to show a list of accounts and when a user clicks on one show
>> account's details.
>> What is a best way of approaching that?
>> Thanks
>>|||Most of your detailed report is not visible because the detail line is
hidden. You will only see a list of account numbers. If you click the +
toggle, which you would probably have beside the account number, you would
then see all the detail for that account.
Your other option is a separate drilldown report. To do this you would need
to define an "action" linked to the account number textbox which opened
another report. One of the parameters you would pass to the drilldown report
is the account number.
--
Magendo_man
Freelance SQL Reporting Services developer
Stirling, Scotland
"Mark Goldin" wrote:
> But since I have a detailed report already how can I create report with
> links to the detailed report?
> "magendo_man" <sql@.kappa.co.uk.(donotspam)> wrote in message
> news:FEE2EC61-3596-4C90-92FE-C1A1EDF5DF6E@.microsoft.com...
> > If you generate a dataset with all the accounts' details you could then
> > use a
> > table control with grouping by account. You would hide the detail line by
> > default but allow this to be toggled from a textbox on the group
> > header/footer.
> >
> > HTH
> >
> > --
> > Magendo_man
> >
> > Freelance SQL Reporting Services developer
> > Stirling, Scotland
> >
> >
> > "Mark Goldin" wrote:
> >
> >> I want to show a list of accounts and when a user clicks on one show
> >> account's details.
> >> What is a best way of approaching that?
> >>
> >> Thanks
> >>
> >>
> >>
>
>

Drilldown question

Hi,

I've been playing around with SSRS 2005 to see if it might be the solution for some reporting requirements I have been given, but I still haven't found a way to do exactly what I need. Basically I've been asked to provide a report which allows drilling down multiple levels of a client hierarchy to show some sales figures, sounds pretty simple right? The report will look like this (not showing sales figues here just client hierarchy)...

+ Client A
- Client B
- Client C
- Client D
+ Client E
- Client F
- Client G
- Client H
- Client I
- Client J
+ Client K
+ Client L

As you can see they want to be able to expand & collapse rows to drill down through their client hierarchy. The hierarchy will be 3 or 4 levels deep.

I have seen that RS2005 supports a simple way to drill-down via grouping, but I don't want to do it this way because it means that I will have to have a query which retrieves all of the data right away which would take several minutes.

What I'd really like to do is to lazily load the hierarchy so that the data is loaded as the tree is expanded so that it won't take too long to render the report initially. I.e. when they click on "Client B" I'll hot the DB and get the sales figures for all children of Client B, in the case above thats Clients C & D.

Can this be achieved using sub reports or report linking? If anyone knows of some tutorials or examples that might be able to help me with this I would really appreciate it.

Thanks.

Lachlan

Hi

I am facing the same problem what you have stated. If you have got or found a solution please share it. It is quite urgent.

Thanking you in advance

regards

Sai

|||well, you could use several single reports i think
1. report all collapsed but root-rows and a link to another report (2. report) on each row
Query: WHERE hierachie level=1
2. report with the root rows and the rows below the row you clicked on 1.report
Query: WHERE hierachie level=1 or parent=<clicked row>
and so on ...

and all reports with the grouping you would usually have

but its very complex and wont be easy to implement i think

i also have to say that i've never tried it, its just an idea

greets
gerhard
|||

Hello Gerhard,

Can you please explain in detail. I have just started working on sql reporting services 2005 and I need a solution for a similar issue.

I need a drilldown report in the model given below.. Main values will be clientname, clientcode and total number of products purchased. When I expand details for each client I should see the SalesOrder #, Date, ProductPurchased , Qty and Price

I'm able to get this output:

ClientCode (MainGrouping)

SalesOrder# Date ProductPurchased Qty Price (DrilldownDetails )

But I'm not able to get this as output:

ClientCode ClientName Total# Purchased (MainGrouping)

SalesOrder# Date ProductPurchased Qty Price (DrilldownDetails )

I need it to really group by ClientCode. But the grouping line should display other fields related to that client..

How do I do this ?

Note : I have another question : I have tried the same with a Drill through report. The problem I'm facing here is, the drill thro detail report for each client opens in the same window, which I don't like. I want it to open in a new window. Is there a way to open a drill thro report in a new window ?

Thanks for your help in advance,

vidash

Drilldown question

Hi,

I've been playing around with SSRS 2005 to see if it might be the solution for some reporting requirements I have been given, but I still haven't found a way to do exactly what I need. Basically I've been asked to provide a report which allows drilling down multiple levels of a client hierarchy to show some sales figures, sounds pretty simple right? The report will look like this (not showing sales figues here just client hierarchy)...

+ Client A
- Client B
- Client C
- Client D
+ Client E
- Client F
- Client G
- Client H
- Client I
- Client J
+ Client K
+ Client L

As you can see they want to be able to expand & collapse rows to drill down through their client hierarchy. The hierarchy will be 3 or 4 levels deep.

I have seen that RS2005 supports a simple way to drill-down via grouping, but I don't want to do it this way because it means that I will have to have a query which retrieves all of the data right away which would take several minutes.

What I'd really like to do is to lazily load the hierarchy so that the data is loaded as the tree is expanded so that it won't take too long to render the report initially. I.e. when they click on "Client B" I'll hot the DB and get the sales figures for all children of Client B, in the case above thats Clients C & D.

Can this be achieved using sub reports or report linking? If anyone knows of some tutorials or examples that might be able to help me with this I would really appreciate it.

Thanks.

Lachlan

Hi

I am facing the same problem what you have stated. If you have got or found a solution please share it. It is quite urgent.

Thanking you in advance

regards

Sai

|||well, you could use several single reports i think
1. report all collapsed but root-rows and a link to another report (2. report) on each row
Query: WHERE hierachie level=1
2. report with the root rows and the rows below the row you clicked on 1.report
Query: WHERE hierachie level=1 or parent=<clicked row>
and so on ...

and all reports with the grouping you would usually have

but its very complex and wont be easy to implement i think

i also have to say that i've never tried it, its just an idea

greets
gerhard|||

Hello Gerhard,

Can you please explain in detail. I have just started working on sql reporting services 2005 and I need a solution for a similar issue.

I need a drilldown report in the model given below.. Main values will be clientname, clientcode and total number of products purchased. When I expand details for each client I should see the SalesOrder #, Date, ProductPurchased , Qty and Price

I'm able to get this output:

ClientCode (MainGrouping)

SalesOrder# Date ProductPurchased Qty Price (DrilldownDetails )

But I'm not able to get this as output:

ClientCode ClientName Total# Purchased (MainGrouping)

SalesOrder# Date ProductPurchased Qty Price (DrilldownDetails )

I need it to really group by ClientCode. But the grouping line should display other fields related to that client..

How do I do this ?

Note : I have another question : I have tried the same with a Drill through report. The problem I'm facing here is, the drill thro detail report for each client opens in the same window, which I don't like. I want it to open in a new window. Is there a way to open a drill thro report in a new window ?

Thanks for your help in advance,

vidash

Drilldown question

Hi,

I've been playing around with SSRS 2005 to see if it might be the solution for some reporting requirements I have been given, but I still haven't found a way to do exactly what I need. Basically I've been asked to provide a report which allows drilling down multiple levels of a client hierarchy to show some sales figures, sounds pretty simple right? The report will look like this (not showing sales figues here just client hierarchy)...

+ Client A
- Client B
- Client C
- Client D
+ Client E
- Client F
- Client G
- Client H
- Client I
- Client J
+ Client K
+ Client L

As you can see they want to be able to expand & collapse rows to drill down through their client hierarchy. The hierarchy will be 3 or 4 levels deep.

I have seen that RS2005 supports a simple way to drill-down via grouping, but I don't want to do it this way because it means that I will have to have a query which retrieves all of the data right away which would take several minutes.

What I'd really like to do is to lazily load the hierarchy so that the data is loaded as the tree is expanded so that it won't take too long to render the report initially. I.e. when they click on "Client B" I'll hot the DB and get the sales figures for all children of Client B, in the case above thats Clients C & D.

Can this be achieved using sub reports or report linking? If anyone knows of some tutorials or examples that might be able to help me with this I would really appreciate it.

Thanks.

Lachlan

Hi

I am facing the same problem what you have stated. If you have got or found a solution please share it. It is quite urgent.

Thanking you in advance

regards

Sai

|||well, you could use several single reports i think
1. report all collapsed but root-rows and a link to another report (2. report) on each row
Query: WHERE hierachie level=1
2. report with the root rows and the rows below the row you clicked on 1.report
Query: WHERE hierachie level=1 or parent=<clicked row>
and so on ...

and all reports with the grouping you would usually have

but its very complex and wont be easy to implement i think

i also have to say that i've never tried it, its just an idea

greets
gerhard|||

Hello Gerhard,

Can you please explain in detail. I have just started working on sql reporting services 2005 and I need a solution for a similar issue.

I need a drilldown report in the model given below.. Main values will be clientname, clientcode and total number of products purchased. When I expand details for each client I should see the SalesOrder #, Date, ProductPurchased , Qty and Price

I'm able to get this output:

ClientCode (MainGrouping)

SalesOrder# Date ProductPurchased Qty Price (DrilldownDetails )

But I'm not able to get this as output:

ClientCode ClientName Total# Purchased (MainGrouping)

SalesOrder# Date ProductPurchased Qty Price (DrilldownDetails )

I need it to really group by ClientCode. But the grouping line should display other fields related to that client..

How do I do this ?

Note : I have another question : I have tried the same with a Drill through report. The problem I'm facing here is, the drill thro detail report for each client opens in the same window, which I don't like. I want it to open in a new window. Is there a way to open a drill thro report in a new window ?

Thanks for your help in advance,

vidash

Drilldown Problem Using Parent Hierarchy

Does anyone know how to create a parent-child hierarchy that can be expanded (ie drilldown capabilities) in reporting services as well as analysis services?

Currently, I have a dimension with three attributes: parent, child, and key. Everything works fine in Analysis Services. When I click browse for the cube and I add the parent-child hierarchy, Analysis Services autogenerates a drilldown from the top level to the bottom level. However, reporting services doesn't seem to recognize the parent hierarchy as being a true hierarchy. After I add the parent-child hierarchy to a table or matrix, it will only add the very first level. There doesn't seem to be any way for reporting services to autogenerate the drilldown like in Analysis Services.

I really need this to work on a report. Any ideas would be much appreciated? Thank you.

You need to set the parent property on the grouping, check out this page on Recursive Hierarchies for details http://msdn2.microsoft.com/en-us/library/ms155903.aspx|||That link applies to Report Designer but what about Report Builder? When I generate a SMDL from an Analysis Services cube, the model contains all my dimensions but if I drag them over to the report, it returns all the available members.

Drilldown Problem Using Parent Hierarchy

Does anyone know how to create a parent-child hierarchy that can be expanded (ie drilldown capabilities) in reporting services as well as analysis services?

Currently, I have a dimension with three attributes: parent, child, and key. Everything works fine in Analysis Services. When I click browse for the cube and I add the parent-child hierarchy, Analysis Services autogenerates a drilldown from the top level to the bottom level. However, reporting services doesn't seem to recognize the parent hierarchy as being a true hierarchy. After I add the parent-child hierarchy to a table or matrix, it will only add the very first level. There doesn't seem to be any way for reporting services to autogenerate the drilldown like in Analysis Services.

I really need this to work on a report. Any ideas would be much appreciated? Thank you.

You need to set the parent property on the grouping, check out this page on Recursive Hierarchies for details http://msdn2.microsoft.com/en-us/library/ms155903.aspx|||That link applies to Report Designer but what about Report Builder? When I generate a SMDL from an Analysis Services cube, the model contains all my dimensions but if I drag them over to the report, it returns all the available members.

Drilldown on Related measures: Calculations in DSV

Hi,

I have a strange requirement, although there is a workaround that I have thought about , it quite does not satisfy what I need. Here is the scenario:

I have about 200 calculations (basic arthimetic with maximum of 10 members). I have created them in the DSV as named calculations. The calculations involve other members of the DSV. We tried using calculated members but the performance became slow, because the user always has to see only the calculated values first.

The requirement is that, the users first see the calculated values, over different dimensions and dates. When the user wants to verify as to how a paticular calculated value was arrived, then he should be able to sort of drill down into the members that made up that calculated member. The users want to see this inline, like clicking on '+' expands the lower levels.

example: if a named calculation 'c' has a formula a+b then when user clicks on the 'c' cell or right clicks (whatever) it should show that c is made up of a+b and also the values of a and b for the corresponding dimensions being viewed.

my approach: I used drillthrough actions to achieve this, but the problem with drillthorugh actions is that it displays all actions for all cells, The user has to select the specific action for that cell. and in Proclarity (standard) the actions are displayed in the left navigation tab. not in the grid. (actually i have a problem with proclarity web standard and drillthrough actions, its in a other post)

1. I have read that we can have a general drillthrough action which targets similar common query subspace, but will we get the specific rows that make up the final value for all drillthorugh's. please do explain how to accomplish this. and how to identify a common query subspace.

2. Is there any other way to relate measures. can we create a dummy dimension that realtes the measures, so that they can be browsed using drill-down and drill-up kind of feature.

3. I have a drillthrough created which works with a set of dimension attributes, if I browse this drillthrough action with a new attribute added to the set, the drillthrough action does not return any rows. why is this?. Since I am only adding a attribute of the same dimension whose attributes are already there in the drillthrough return, should it not return the same rows as before? should I add this attribute in the return statement? but what if I dont want to see it in the return? but it is there while browsing?

Regards and thanks

What about creating a separate dimension to represent the hierarchy of named calculations - custom member formulii can be added, to override default aggregation behavior as necessary?

http://msdn2.microsoft.com/en-us/library/ms174474.aspx

>>

SQL Server 2005 Books Online

Working with Custom Member Formulas

You can define a Multidimensional Expressions (MDX) expression, called a custom member formula, to supply the values for the members of a specified attribute. A column in a table from a data source view provides, for each member in an attribute, the expression used to supply the value for that member.

Custom member formulas determine the cell values that are associated with members and override the aggregate functions of measures. Custom member formulas are written in MDX. Each custom member formula applies to a single member. Custom member formulas are stored in the dimension table or in another table that has a foreign key relationship with the dimension table.

...

>>

|||

Hi,

I have not tried this nor hear about it before.

Is it calculated measures?

where in BI studio can I create this.

I have to try this.

Thanks and Regards

|||

Hi,

I gave a bried reading about custom member formulas.

This is for attributes of a dimension, where you can create a custom attribute with an mdx expression pointing to a dsv table, right?

but I need this for fact members, I mean for measures.

my fact will be look like this:

fact:

measure 1

measure 2

calcMeasure3 = measure1 + measure 2

calcMeasure4 = measure2 / 5.0

when users browse, they have to see only calcMeasure3 and calcMeasure4. if they want to see more details, they would want to click/right click on calcMeasure3 to see measure1 and measure2 (because calcMeasure3 is measure1 + measure2).

How can I use custom memer formulas for this scenario? can you please explain for the above example?

I am kind of confused now.

thanks and regards

|||

My idea is to add a parent-child dimension like DimCustomMeasures. The dim table would have fields: MeasureID, ParentID, MDXFormula. For the example above, the rows could be like (without using named calculations in fact table):

"All Measures", (Null), "[Measures].CurrentMember"

"calcMeasure3", "All Measures", "[Measures].[measure1] + [Measures].[measure2]"

"calcMeasure4", "All Measures", "[Measures].[measure2] / 5.0"

"calcMeasure3.measure1", "calcMeasure3", "[Measures].[measure1]"

"calcMeasure3.measure2", "calcMeasure3", "[Measures].[measure2]"

calcMeasure4.measure2", "calcMeasure4", "[Measures].[measure2]"

|||

Hi,

Thanks,

I will try this out.

just trying to understand a little more........

will this ( "calcMeasure3", "All Measures", "[Measures].[measure1] + [Measures].[measure2]") show both the resultant measures?

I mean it should show values for both measure1 and measure 2. (not the added value for them, since this is already avaliable in the calcMeasure3)

Its like the user wants to know what values made up to the calcMeasure3.

So if the user browses this on a higher level of granularity, then the resultant should be many rows of measure1 , measure2 values.

I hope I am able to put out the requirement correctly?

Regards

DrillDown on Recursive Data

How can I do drilldown on recursive data?
I have a table with products that have parent products
Eg:
ProductID ParentProductID
1
2 1
3 1
4 2
I want to drill down on all the levels.
Thanks
--
Matias from Argentina!Look here:
http://groups-beta.google.com/groups?q=sql+server+recursive+select
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"matiasls" <matiasls@.hotmail.com> wrote in message
news:2BF2A852-9F50-47A6-9369-AE00F89C50FF@.microsoft.com...
> How can I do drilldown on recursive data?
> I have a table with products that have parent products
> Eg:
> ProductID ParentProductID
> 1
> 2 1
> 3 1
> 4 2
>
> I want to drill down on all the levels.
> Thanks
> --
> Matias from Argentina!

drilldown newbie

Please excuse me if this double posts. Thought I posted earlier but do not
see it.)
When I use the action property of a text box to bring up a chart, how do i
tell it to chart only that row's values. For example, I want to chart manager
sales over months. I list the managers and their sales as rows and have set
the manager's name text box to jump to my chart. What displays are the sums
for all managers. (all data rows). What do I need to do?
--
Thanks,
CGWNever mind... found the button for parameters.
"CGW" wrote:
> Please excuse me if this double posts. Thought I posted earlier but do not
> see it.)
> When I use the action property of a text box to bring up a chart, how do i
> tell it to chart only that row's values. For example, I want to chart manager
> sales over months. I list the managers and their sales as rows and have set
> the manager's name text box to jump to my chart. What displays are the sums
> for all managers. (all data rows). What do I need to do?
> --
> Thanks,
> CGW

Drill-down is not working on browser : Please help

Hi,
Please help.. this is an annoying problem ......
I am running sample reports in the browser and found that none of the
reports drilldown
when I click on teh + sign.
In VS.NET environment the reports drilldown fine.
Is there a particular setting in the Internet Explorer options I have to set
?
I am using Evaluation edition with SP1.
Cheers
PawanDo you have an underscore in the server machine name?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pawan" <pawan_kr_sharma@.hotmail.com> wrote in message
news:%23jkX%23ssZEHA.1448@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Please help.. this is an annoying problem ......
> I am running sample reports in the browser and found that none of the
> reports drilldown
> when I click on teh + sign.
> In VS.NET environment the reports drilldown fine.
> Is there a particular setting in the Internet Explorer options I have to
> set
> ?
> I am using Evaluation edition with SP1.
> Cheers
> Pawan
>|||Yes !
Pawan
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
news:eGmWsbtZEHA.1164@.TK2MSFTNGP12.phx.gbl...
> Do you have an underscore in the server machine name?
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Pawan" <pawan_kr_sharma@.hotmail.com> wrote in message
> news:%23jkX%23ssZEHA.1448@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > Please help.. this is an annoying problem ......
> >
> > I am running sample reports in the browser and found that none of the
> > reports drilldown
> > when I click on teh + sign.
> > In VS.NET environment the reports drilldown fine.
> >
> > Is there a particular setting in the Internet Explorer options I have to
> > set
> > ?
> >
> > I am using Evaluation edition with SP1.
> >
> > Cheers
> > Pawan
> >
> >
>|||http://groups.google.com/groups?selm=%23HoAMdjBEHA.3284%40TK2MSFTNGP09.phx.gbl
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pawan" <pawan_kr_sharma@.hotmail.com> wrote in message
news:uj5JMTyZEHA.1764@.TK2MSFTNGP10.phx.gbl...
> Yes !
> Pawan
>
> "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> news:eGmWsbtZEHA.1164@.TK2MSFTNGP12.phx.gbl...
>> Do you have an underscore in the server machine name?
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Pawan" <pawan_kr_sharma@.hotmail.com> wrote in message
>> news:%23jkX%23ssZEHA.1448@.TK2MSFTNGP12.phx.gbl...
>> > Hi,
>> >
>> > Please help.. this is an annoying problem ......
>> >
>> > I am running sample reports in the browser and found that none of the
>> > reports drilldown
>> > when I click on teh + sign.
>> > In VS.NET environment the reports drilldown fine.
>> >
>> > Is there a particular setting in the Internet Explorer options I have
>> > to
>> > set
>> > ?
>> >
>> > I am using Evaluation edition with SP1.
>> >
>> > Cheers
>> > Pawan
>> >
>> >
>>
>|||Hi Lev,
I changed my computer name to remove the underscore from name.
After that I used rsconfig.exe utility to change the connection settings of
report server.
Now, my reports show the images and drill down in the browser.
Many thanks for your help.
Pawan
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
news:eJbVDc8ZEHA.3512@.TK2MSFTNGP12.phx.gbl...
>
http://groups.google.com/groups?selm=%23HoAMdjBEHA.3284%40TK2MSFTNGP09.phx.gbl
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Pawan" <pawan_kr_sharma@.hotmail.com> wrote in message
> news:uj5JMTyZEHA.1764@.TK2MSFTNGP10.phx.gbl...
> > Yes !
> >
> > Pawan
> >
> >
> > "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> > news:eGmWsbtZEHA.1164@.TK2MSFTNGP12.phx.gbl...
> >> Do you have an underscore in the server machine name?
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >>
> >> "Pawan" <pawan_kr_sharma@.hotmail.com> wrote in message
> >> news:%23jkX%23ssZEHA.1448@.TK2MSFTNGP12.phx.gbl...
> >> > Hi,
> >> >
> >> > Please help.. this is an annoying problem ......
> >> >
> >> > I am running sample reports in the browser and found that none of the
> >> > reports drilldown
> >> > when I click on teh + sign.
> >> > In VS.NET environment the reports drilldown fine.
> >> >
> >> > Is there a particular setting in the Internet Explorer options I have
> >> > to
> >> > set
> >> > ?
> >> >
> >> > I am using Evaluation edition with SP1.
> >> >
> >> > Cheers
> >> > Pawan
> >> >
> >> >
> >>
> >>
> >
> >
>

Drilldown in SQl Reporting Service

Hi,

I'm new to SQL Reporting Service. Now only I've started studying that. My question is,

I wanna list out my product sales for each month for each keywords. For example, I have 4 products, some 15 keywords (its an ecommerce site. Visitor coming from a particluar keyword and buying some products. Wanna list out sales for each keywords and product for Every month. To know the quarter sales wanna see the sales and product name for particular keyword). I'm having reports for each month sales. like,

Keywords

Product A

Product B

Product C

Product D

Keyword 1

125

24

275

12

Keyword 2

456

245

67

1223

For quarter sales, I want to see the sales and keywords list for each month and for each products in the same report. I don't want to create one another report for each and every product and month. If I want to see the sales and keywords for a particular product I want a report like,

For Product 1

Keywords

Month1

Month2

Month3

Month4

Keyword 1

125

24

275

12

Keyword 2

456

245

67

1223

and

For Month 1

Keywords

Product A

Product B

Product C

Product D

Keyword 1

125

24

275

12

Keyword 2

456

245

67

1223

Just by using drilldown I want this report. If any other method is possible, please tell me. It's very urgent. Please Help me. I'm very new to SQL Reporting Service. Started studying before 2 days. Thanks.............

This is possible,

What U have to do, just right click on perticular textbox from which U want drill down, and go to properties.

There u find Navigatioin Tab, In this tab there is one option Jump to report, select it and give name of detail report u want in drilldown.

If drilldown wants parameters from parent report, give parameters by click on Button Parameters besides.

Try this it works fine, i have design many report like this and Be Cool.

|||

Hi,

Can you please explain me fully? I want same report wiht drilldown. I want to see quarter sales for particular product and a month sales for all products for the same set of keywords. Can you please tell me how to give input and all? Thanks...

|||

Hi!

I'm experiencing whit a strange behaviour in reporting services and drill down: I’ve a report with a graphic and nothing else. If I publish the report through a windows server 2003 R2 I can click on a element in the graph and a new report is shown. But if I publish the report by a windows XP Pro I see the report correctly but if I click on a element in the graph nothing happens.

Does it depend on the SSRS configuration or is the behaviour OS related?

Thanks in advance.

Alx

Drilldown in SQl Reporting Service

Hi,

I'm new to SQL Reporting Service. Now only I've started studying that. My question is,

I wanna list out my product sales for each month for each keywords. For example, I have 4 products, some 15 keywords (its an ecommerce site. Visitor coming from a particluar keyword and buying some products. Wanna list out sales for each keywords and product for Every month. To know the quarter sales wanna see the sales and product name for particular keyword). I'm having reports for each month sales. like,

KeywordsProduct AProduct BProduct CProduct DKeyword 11252427512Keyword 2456245671223

For quarter sales, I want to see the sales and keywords list for each month and for each products in the same report. I don't want to create one another report for each and every product and month. If I want to see the sales and keywords for a particular product I want a report like,

For Product 1

KeywordsMonth1Month2Month3Month4Keyword 11252427512Keyword 2456245671223

and

For Month 1

KeywordsProduct AProduct BProduct CProduct DKeyword 11252427512Keyword 2456245671223

Just by using drilldown I want this report. If any other method is possible, please tell me. It's very urgent. Please Help me. I'm very new to SQL Reporting Service. Started studying before 2 days. Thanks.............

This is possible,

What U have to do, just right click on perticular textbox from which U want drill down, and go to properties.

There u find Navigatioin Tab, In this tab there is one option Jump to report, select it and give name of detail report u want in drilldown.

If drilldown wants parameters from parent report, give parameters by click on Button Parameters besides.

Try this it works fine, i have design many report like this and Be Cool.

|||

Hi,

Can you please explain me fully? I want same report wiht drilldown. I want to see quarter sales for particular product and a month sales for all products for the same set of keywords. Can you please tell me how to give input and all? Thanks...

|||

Hi!

I'm experiencing whit a strange behaviour in reporting services and drill down: I’ve a report with a graphic and nothing else. If I publish the report through a windows server 2003 R2 I can click on a element in the graph and a new report is shown. But if I publish the report by a windows XP Pro I see the report correctly but if I click on a element in the graph nothing happens.

Does it depend on the SSRS configuration or is the behaviour OS related?

Thanks in advance.

Alx

Drilldown in SQl Reporting Service

Hi,

I'm new to SQL Reporting Service. Now only I've started studying that. My question is,

I wanna list out my product sales for each month for each keywords. For example, I have 4 products, some 15 keywords (its an ecommerce site. Visitor coming from a particluar keyword and buying some products. Wanna list out sales for each keywords and product for Every month. To know the quarter sales wanna see the sales and product name for particular keyword). I'm having reports for each month sales. like,

Keywords

Product A

Product B

Product C

Product D

Keyword 1

125

24

275

12

Keyword 2

456

245

67

1223

For quarter sales, I want to see the sales and keywords list for each month and for each products in the same report. I don't want to create one another report for each and every product and month. If I want to see the sales and keywords for a particular product I want a report like,

For Product 1

Keywords

Month1

Month2

Month3

Month4

Keyword 1

125

24

275

12

Keyword 2

456

245

67

1223

and

For Month 1

Keywords

Product A

Product B

Product C

Product D

Keyword 1

125

24

275

12

Keyword 2

456

245

67

1223

Just by using drilldown I want this report. If any other method is possible, please tell me. It's very urgent. Please Help me. I'm very new to SQL Reporting Service. Started studying before 2 days. Thanks.............

This is possible,

What U have to do, just right click on perticular textbox from which U want drill down, and go to properties.

There u find Navigatioin Tab, In this tab there is one option Jump to report, select it and give name of detail report u want in drilldown.

If drilldown wants parameters from parent report, give parameters by click on Button Parameters besides.

Try this it works fine, i have design many report like this and Be Cool.

|||

Hi,

Can you please explain me fully? I want same report wiht drilldown. I want to see quarter sales for particular product and a month sales for all products for the same set of keywords. Can you please tell me how to give input and all? Thanks...

|||

Hi!

I'm experiencing whit a strange behaviour in reporting services and drill down: I’ve a report with a graphic and nothing else. If I publish the report through a windows server 2003 R2 I can click on a element in the graph and a new report is shown. But if I publish the report by a windows XP Pro I see the report correctly but if I click on a element in the graph nothing happens.

Does it depend on the SSRS configuration or is the behaviour OS related?

Thanks in advance.

Alx

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
> > > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >