Get Toggle state at report runtime

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FidelR - 28 Sep 2006 13:16 GMT

Hi,

I would like to find the toggle state of a textbox in the report to set an
expression according to that state. I need to navigate to a second report
with different parameters according to the toggle state of a particular row
in my report. How do I write the expression (something like iif(toggle state
= 'Collapsed', Parameter A, Parameter B))?

Thanks,
Ronen Fidel

Reply to this Message

Wei Lu [MSFT] - 29 Sep 2006 04:14 GMT

Hello Ronen,

Unfortunatly, you could not refer the visability state of an report item in
the expression.

I would like to know your business more detailed that I may provide a
solution instead of refer the visability.

Here is an example which have a conditional background color by the toggle
state.

Maybe this will be some help for you.

http://www.msbicentral.com/Downloads/tabid/96/Default.aspx

DrillDownSample.RDL

Sincerely,

Wei Lu

Microsoft Online Community Support

==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Reply to this Message

FidelR - 29 Sep 2006 05:33 GMT

Wei,

I'll add more details:
I created a matrix report. I created a group by on the row cell and added
navigation expression on the data cell. When the row cell is expanded the
drill through works fine since I send the row cell id as parameter to the
next report. When the row cell in collapsed, the data cell shows the sun of
all data correctly but the drill through is not working as it should since
the parameter value that it pass to the second report is the first value of
the grouped by data. I wanted to get the toggled state and then if it is
collapsed then send 'ALL' in the parameter and when it is expanded send the
row id.

Thanks,
Ronen Fidel
Unisfair

> Hello Ronen,
>
[quoted text clipped - 40 lines]
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)

Reply to this Message

Wei Lu [MSFT] - 29 Sep 2006 10:00 GMT

Hello Ronen,

To understand your issue better and try to reproduce this issue, I would
like to get some sample report from you.

You could send the report file to me. To get my email address, please
remove the ONLINE in my email.

Sincerely,

Wei Lu

Microsoft Online Community Support

==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Reply to this Message

FidelR - 29 Sep 2006 12:18 GMT

Wei,

I sent you the reprt via email.

Thanks,
Ronen Fidel
Unisfair

> Hello Ronen,
>
[quoted text clipped - 31 lines]
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)

Reply to this Message