can do it one of two ways

format the report so that its no wider than 1 page wide so when exported to excel it is one page wide already

or

when printing...

declare @string varchar(max)

set @string = 'SOME STRING'

sp_executesql (@string)

or

EXEC (@string)

it does look like conditional logic errors with all the AND's.

if not and the logic is how the OP requires it then we need DDL, data, expected outputs and paramter...

direct responces to this link http://www.sqlservercentral.com/Forums/Topic1216888-146-1.aspx

please post your full ddl scripts including sample data for all tables (inc indexes) and insert statements for the data so that we can assist you better

if you lookup sp_send_dbmail in SQL BOL or google it will provide the information you are looking for.

you first need to ensure that you have configured DB mail and that...

if your using SQL Mail already then you need to find where you use SQL Mail and apply the same syntax to the new procs.

SQL Mail is a depreciated feature...

I'm sure I will get a moment to sit down and learn this stuff instead of just copy and pasting a tablix every time I need different row groups. ...

will need to use database mail

msdb.dbo.sp_send_dbmail

will need to be configured with a mail profile if not already done so and then where xp_sendmail is in the scripts replaced with the...

you will want to look into row groups, these baffle me a lot of the time.

i still cant get them to work by doing it manually, so i just copy...

happening for me too

think this just maybe one of them things with RC0

do you want to run the full string including the CREATE PROC, or just the contents of the proc

EG EXEC ProcName or CREATE PROC ProcName.....

Also you have only provided one...

I'll agree with all of the above, you cannot do this via the SSMS GUI, the options you have are to create the procedures from the scripts, put them in...

please provide your DDL scripts so that we can assit you better.

how do you mean you want to do this through SSMS?

the scripts Gianluca provided can be compiled and run through SSMS or set in a job to run on a...