Just added a quick int filter to a report. Are you using quotes in your Parameter, available values settings? Mine worked first time?

Forgetting about whether you can publish the report, are you able to login to the http://yourreportserver/reports site?

My apologies - I misunderstood - I thought you meant when executing a report. When deploying that would be credentials of a user that is allowed to publish on the...

My preferred method to block user's from seeing other peoples data - especially sales and financial data, is using AD logins on the report server. The AD policy forces password...

Hi

That looks to me like the credentials of the datasource you published. You can (1) edit the datasource and lock down some credentials on the Report Server or (2) prompt...

I used a similar approach to restrict the data that sales reps could see, and limit them to their accounts only.

Hi

Are you using the scope of the SUM(NumOfAssets.value, "City" ) or just the plain old SUM(NumOfAssets.value)?

If the value of the field is already calculated (for instance a sum on the...

Hi

Wouldn't it be easier just to use a trigger/scheduled job to send an email to the client directly from the server?

Here's a great article describing how to send mails:

Hi

I'll attempt to answer each separately.

I need to create "Add", "Remove" , "Move up" and "Move Down" buttons in SSRS. The logic goes like this. The parameter is...

Thanks Erik

Client is thankfully only going to want data from their instance, and so we don't need to link. Are there not issues with Sub-reports not rendering to exported formats?

You can specify a datasource that uses the value of a parameter. In the parameter pass the connection string,

for example:

"Data Source=[SSInstance];Initial Catalog=[database];User Id=;Password=;Trusted_Connection=False;" (this one passes a username/pass = unsafe)...

You can enable the Page Break Before or After in the Customer Group's properties. That should fix that, or am I misunderstanding your query?

Me too, I'm looking for intermediate to advanced.

Or do the grouping in T-SQL and display the results in a straight table/tablix without grouping. Then each row is actually total and you don't need grouping in SSRS.

HI

You can hide the detail grouping (Group Properties | Visibility | Hide). See if that helps?