What are the log files saying? Generally these do give an indication to why they are failing, or at least give a little more information that'll help troubleshoot.

Are you actually saying that you have a multi value parameter, and you want to return results if the field you are querying is any of those the user has...

MY_USER1 also requires CONTROL on schema to be able to define a users permissions.

GRANT ALTER, CREATE SEQUENCE, DELETE, EXECUTE, INSERT, REFERENCES, SELECT, CONTROL, TAKE OWNERSHIP, UPDATE, VIEW CHANGE TRACKING,...

I'm not sure why you want to achieve this with a Cursor to be honest, you could do this simply in a dataset update.

With some made up data, would this...

Not something I've seen before, but found a topic via Google that had a couple of ideas:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2fc89959-9893-4107-9c0a-906e50b1236d/failure-sending-mail-exception-0xc0000005-was-generated-at-address-0x000007fee3d4122b-mail-will-not?forum=sqlreportingservices

One person suggests that it could be because you have have a...

So, correct me if I'm wrong, the email you want you would like to contain 7 charts in it only. Then the attachment (xlsx?) will contain the detail to go...

As I said in my previous comment, you can't send a different report in the email content to that of the attached file. A single report can only send one...

If you're sure the code is the same, have you tried running a trace to double check this? Sometimes you can be "sure" that the report parameters are set up...

If you're using derived parameters, most likely from a dataset being passed parameters, then yes SSRS will need to resolve these sequentially.

You determine the order this is done in...

You're correct that when you send a report out by subscription, you can't send an attached file that differs from the email content.

If you want to make it so that...

"Invalid URI: The Uri string is too long" means that your address is probably over 2,000 characters long!

This suggests to me that your parameter values are far too long...

You can also right click the report in the Solution Explorer and click copy. Then right click the project file in the Solution Explorer and click paste. Probably a little...

Are you trying to access it in an internet browser? If so, you don't need IIS to do this.

Is it a fresh install of SSRS you've just made, or is...

As John Rowan said, this is quite hard without knowing your table/data format.

If my understanding is correct, and you're looking to return a full list of questions, students, and their...

The only way you could do this would be to have the 4th parameter get its available values provided from a dataset, which has the 3rd parameter (and any others...