You would need to build the email message using HTML tags.

We use a few where the messages are built in an ActiveX script then sent.  We also have a table set up...

You would need to send it as an attachment.

The ReferencedDatabase is any other database to which the stored procedure used to view the report needs access. 

The access given to the global group(s) only them to access the...

This is the setup I've used

Create global group gg_SQL_xxxx in Active Directory Users and Groups

On the Reporting Services database

Create login gg_SQL_xxxx Default...

Yes, it does require a restart.

The fixed width for a TEXT field is 2GB.

A quick test with only 14 records and c. 20 characters in each TEXT field produces a download of 44Mb.  Not quite...

It's the Double-Hop problem.

If the Reports server and SQL server are on different machines then the authentication is not passed from the Report server to the SQL server.  If you check the...

It appears that your server has "lost" its server name.  Using sp_addlinkedserver or addserver is just going to replace it in the sysservers table

You could try sp_addlinkedserver to restore the entry but I've no idea how it came to be deleted in the first case. 

The one on the right.  Most definitely.  All I need to do now is find somewhere in the backyard to put it

TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and are not transferable.(BOL)

I'd have to say yes, as long as my "better" half could do the same.  Just being able to do and go where ever and when ever.... bliss. 

You would need to alter

SET @dataSource = 'SomeDB'

to

SET @datasource = (SELECT ColumnContainingDatabaseName

                            FROM TableContainingDatabaseName

                            WHERE CriteriaForDatabaseName

                            )

When you right click and Modify SQL does a sequence of sql commands upon saving the changes (table name and columns removed) :

/* To prevent any potential data loss issues, you...

Just run a quick test and the Conditional Split does not like AND but is ok with && (Logical AND)