Hi,

As far as I am aware there is no way to do this within a report. The ReportItems collection does not expose the Hidden property.

Possible to work around. ...

Hi Dave,

All of this is possible.

As long as the users aren't granted any of the System roles (System Admin, System User) in report manager they will not see the site...

It feels a bit hacky but you could...

Add an empty row to the table in your subreport, outside of the Detail group and use an expression for the row Visible...

Mike,

Before we start I do not advocate deleting directly from the ReportServer and your posts scared me a little.

Can I ask why you are not using the report manager for...

Hi Shindle,

Users can just be assigned the item level security, e.g. Browser role. Obviously they need to be able to navigate to the item so need Browser on the...

Hi George,

I've come across this problem before. What I did was to add an extra dataset to the subreport that always returns a value i.e.

SELECT 1

You don't have to...

Yes your assumption is correct.

For readability this could be better done as a switch statement:

=Switch(

Fields!Gr.Value = "01", "01 Total Score",

Fields!Gr.Value = "02", "02 Total Score",

...

Yes. This is a Scale Out Deployment.

http://technet.microsoft.com/en-us/library/ms159114.aspx

Try setting the ConsumeContainerWhitespace property to true in the Report properties.

You can use Iif in font colours.

Are you formatting the text based on it's value (that is not on the value in a different textbox)? If so try using...

Hi Krypto,

You can indeed. You need to create a linked server to your Analysis Services instance.

e.g.

EXEC sp_addlinkedserver

@server = 'AW'

, @srvproduct = ''

, @provider = 'MSOLAP'

, @datasrc = 'localhost'

,@catalog...

Site settings are to grant users access to configuration and monitoring of the Report Manager instance.

Folder settings are to grant role access to users to view, schedule or edit the...

What you can do is to create your own report template.

Create a blank new report and set up all your defaults, language etc then save a copy in (if your...

If I understand what you are trying to do correctly the "in" filter requires an array, you cant pass it multiple values separately. You can create an array by...

Hi Happyslug,

What you need to do is set the visible property to false on the rendering extensions.

Find your extensions in the RSReportServer.Config file e.g.

<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">

and add Visible="false" like so:

<Extension...