Hi Damian,

You will need to configure an Unattended Execution Account for the report server. It will be under that account that SSRS will be accessing the image rather than...

When I say textbox, I'm referring to a cell in the tablix. A tablix is a collection of textboxes and other objects, text box is the default.

If...

OK, and assuming it's at detail level, it should just work. Really all you are doing is double clicking in the textbox until you get the cursor, right click...

Is your textbox within a tablix or a list?

The easiest way would be to create two placeholders in the textbox. One for the last name, and perhaps the comma, and one for forename. These can then...

What is the length of the URL these picks are producing? You might be hitting the maximum length after concatenating those picklists. IE still has a limit of...

You are right, the performance gain is related to the drop-downs in the parameters not being populated. This can often be slow, especially if they are query driven.

Editing the...

I feel like there is probably a more elegant way of doing it, but this was what I came up with. Just joining the summarised dataset to the original...

Your approach isn't going to work here, SSRS wont apply an IIF for each row in the range.

=iif((Fields!TIER_NAME.Value = "Tier 1") ,sum(Fields!Applcations_Made.Value),0) will not work.

What you need...

You can do it in SQL using a subquery, turn it into a distinct list there and then summarise.

WITH CTE AS (

SELECT 'Jimmy' AS Person,'12345' As weaponId,1 AS isFinished

UNION ALL...

Are you passing that parameter to a SQL query in the dataset or to a stored procedure?

If you are passing it into a query in the dataset you should not...

It should handle 13 reports easily. Where are you putting the WAITFOR, in the report dataset?

Have you checked the log files? Issues with sending the mails can usually...

Given your description can you not just filter the dataset based on the Show Team Managers parameter? Their values would not be included in the totals and it sounds...

Press F4 and click on the Drop Down in the properties window and select "Report".

Change the ConsumeContainerWhitespace property to True. This is pretty well known issue, you should be...

You can use a Lookup in the sort expression of a Tablix.