Bar Visibility

I am trying to toggle the visibility of a simple bar by the value of a
parameter named DETAIL.
This is the expression used =IIF(Parameters!DETAIL.Value=true,false,true)
When I view the report in .NET IDE it displays fine, when deployed to the
target server I recieve the following error
Reporting Services Error
----
--
a.. Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. (rrRenderingError) Get Online Help
a.. Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown.
a.. Object reference not set to an instance of an object.
----
--
Microsoft Reporting Services
Any help would be greatly appreciated.
-SteveNot sure, but probably this is happening because you are getting a type
mismatch. Try this:
=(Parameters!DETAIL.Value.ToString()="false")
Note that you don't really need to use the IIf statement here, because your
expression evaluates to a Boolean anyway...
"Steven Bennett" <Steven.Bennett@.newsgroup.nospam> wrote in message
news:eYwdp0R7EHA.1204@.TK2MSFTNGP10.phx.gbl...
>I am trying to toggle the visibility of a simple bar by the value of a
> parameter named DETAIL.
> This is the expression used =IIF(Parameters!DETAIL.Value=true,false,true)
> When I view the report in .NET IDE it displays fine, when deployed to the
> target server I recieve the following error
> Reporting Services Error
> ----
> --
> a.. Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown. (rrRenderingError) Get Online Help
> a.. Exception of type
> Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
> thrown.
> a.. Object reference not set to an instance of an object.
> ----
> --
> Microsoft Reporting Services
>
> Any help would be greatly appreciated.
> -Steve
>|||Hello Sophie,
The ability to toggle visibility works with the text box but not with a
line. Both preview correctly in Visual Studio and both deploy with no errors
and no warnings. When I access the report it throws a rendering error (see
original post).
Please try the following to re-create the error.
Create a blank report.
Add a line to the report.
Create a boolean parameter named DETAIL with a default value of False and a
prompt.
Add the statement "=(Parameters!DETAIL.Value=false)" to the Visibility
property of the line.
Preview the report in Visual Studio.
Toggle the DETAIL parameter to True and then click View Report.
Toggle the DETAIL parameter to False and then click View Report.
Deploy the report to the ReportServer
Access the ReportServer using IE
(http://ReportServerName/ReportServer?/ReportServerFolder/ReportName&rs:comm
and=render)
This is the point where I recieve the exception. Please let me know if you
were succesfull in recreating the error.
-Steve
"Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> wrote in message
news:C65hYCX7EHA.2600@.cpmsftngxa10.phx.gbl...
> Hello Steve,
> I recommend you perform the following steps to narrow down the issue:
> 1. Create a new sample report file which includes a text box.
> 2. Set the Visibility property of the text box to the following
expression:
> =IIF(Parameters!DETAIL.Value=true,false,true)
> Note: you need create a report parameter called DETAIL, please refer to
the
> attachment i upload to set the properties of DETAIL.
>
> 3. Try to preview the report.
> If it can be previewed successfully, deploy the new created report. If you
> can deploy the report successfully, it indicates that the problem is not
> related to the expression.
> If you are unable to deploy the new created report successfully, send me
> the Reporting Services Log Files for research. If Reporting Services is
> installed in the 'Program Files' folder, you can find the logfiles in the
> following folder:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
> Note: please compress the log files before you send it to me.
> If anything is unclear, get in touch. I look forward to hearing from you.
>
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
rights.|||Hello Steve,
Thanks for your reply.
I have reproduced this issue on my side and received the exact same error.
I believe you have found a new bug in Reporting Service.
I have forwarded this issue to the appropriate folks to catch their
immediate attention. They will investigate this issue and determine if it
is a bug at the urgent level.
Thank you for all your feedback on RS. I believe that all customers'
feedback will enhance our products.
Have a nice day!
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.