Well, funny you should ask...

My intent is to have a parameterized SSRS report automatically run when certain data is entered (or scheduled), it's results "Saved As..." a .mhtml (web archive)...

What if you wanted to insert the contents of an .html file into the BODY of that email? Still searching posts before creating a new topic, and this one...

Same issue. Did you get it sorted?

this thread just saved me at least an hour of work. thanks SSC

How could they drop such a great utility?

Thanks for the direction Matt!

That's what I needed Kees. Did the trick. THANKS!

I should be more clear...

When I preview the report in the Report Designer, AND via the web, the 6 tables split into 2 pages. If I export the web...

thanks Nick. recreated is as tabular and got exactly what I wanted. solved another issue too.

I'm not seeing the merge option Nick. When I right click on the 4 cells, I see:

Select 'matrix4'

Select 'Body'

Cut

Copy

Paste

Delete

Expression

Properties

<where indented options are disabled>

???

I'm using Microsoft SQL Server...

... and I might be misunderstanding you as well, but yes Nick, that sounds about right.

thanks for the input gang. I ended up going with flat file source connections all with their own 'auto' schema into a UNION ALL object. Each source still...

Thanks gang. We'll have something implemented soon, I'll provide performance metrics on what I find.

Jack, none of the tables in the JOIN clauses are local. This would support your approach, no?

Thanks for the suggestions all!

1 approach would be to have a many:many facilitator table with 2 columns:

student | subject

Ned | Maths

Ned | Science

Ned | History

Paul ...