It is an inline table funtion. In side the function there is an "union all" of two selects.

* No, i don´t pass a value from the function of the left side of the join to the function on the right side. Is the same table function executed...

Well, i 've been trying this

EXEC msdb.dbo.sp_send_dbmail

@profile_name = ,

@recipients = ,

@file_attachments = ,

with ...

I don´t konw how it really works, but i think that may be extending ¿the job? of the subscription of report server ?

Like if it is xp_sendmail then add a...

Have anybody tried out to modify the templates from the wizard?

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Wizards\Reports\Styles\en\StyleTemplates.xml

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject\Report.rdl

If found this here

http://beacspeak.spaces.live.com/blog/cns!69043F34B6D40843!125.entry

I've been trying to...