Hi Alex, I'm not aware of a way you can set up Data Sources with specified Windows Credentials, however, you can run BIDS using "runas /netonly" to impersonate a...

Hi Ralf,

I think there is a misunderstanding here over how multivalue parameters work.

When your multivalue parameter is defined it does not allocate 13 elements where it stores whether...

My preference would be for the first one since it is much clearer and it's easy to determine what it is doing. My only comment is that you should...

You can assign the Publisher role to users or the group for the folders you wish to allow them to save to.

Alternatively you can enable to "My Reports"...

This is where Adjacent Groups come in handy.

Just create an adjacent group for the same dimension, i.e. Years and then use the Sales measure under the first and the Numbers...

Set the "ConsumeContainerWhitespace" report property to True.

Hi,

What you can do is nest the aggregates and specify the scope of the inner aggregate. It would look something like this:

=Sum(Avg(Fields!GroupUnits.Value,"Service Date"))

Hope that helps!

I'd probably just do something like the following:

=Iif(Parameters!Systemname.Value = "ALL", Fields!Systemname.Value, Cstr(Val(Fields!Systemname.Value)))

Neat way to do it is use the Val() function.

This will return all the numbers on the left of a string until it hits a non-digit value.

e.g. Val("12345-Parkway") returns 12345.

Only...

You can change the value for ExecutionLogDaysKept in the ConfigurationInfo table of the ReportServer DB.

Edit: Should probably add, you can get to this by connecting to Reporting Services through...

You can just click to select the fields (press and hold Crtl to select multiple fields) and then change these properties in the properties sidebar (press F4 to make this...

Hi,

Are you using an actual Image control? If so try using a Rectangle instead and then set the Rectangle's background property to the image. The rendering engine will...

Hi,

The setting you require is on the horizontal axis properties.

If you select the horizontal axis and press F4 then set Scale -> Margin = False. Alternatively you can right...

Yes. You can define a data source and select from the drop-down providers, including ODBC, and connect directly.

If you are using linked servers just create a datasource to your...

Datediff always returns an integer, in T-SQL and in the SSRS function so I'm not sure how you are getting what you describe.

For the SSRS expression use Today() rather then...