You're not putting it in mark up. See my signature, or highlight your code and press the SQL Code button.

I',m afraid I'm not happy to downlaod...

Would you mind editing your code to at least be in code markup? That's really hard to read.

Thanks.

I can't see anything wrong with the query, however, there isn't a SELECT statement that returns data, so SSRS can't use that query on it's own. SSRS needs a statement...

What you're asking here is a little vague, but this might help you anyway.

Can you use a Temporary Table in SSRS? Yes, you can. SSRS simply executes the...

There a lot going on in that query, and don't forget, we can't run it (we don't have access to your server). I can see loads of sub queries, as...

If I understand correctly, this'll get you what you're after:

USE Sandbox;
GO
--Create sample table and data
CREATE TABLE SampleTable (ID int IDENTITY(1,1),
         XAN1 char(4),

That won't stop them using EXEC though:

USE master;
GO

CREATE LOGIN TestLogin WITH PASSWORD = '123', CHECK_POLICY = OFF;
GO
CREATE USER TestLogin FOR LOGIN...

Just want to double check, but I assume you're saying that the fields can't refresh because the query is dynamic and, as the parameters don't have a value, SSRS can't...

What was wrong with the answers you received on Stack Overflow?