Put a page break after the first tablix?

Without sample data, it's a lot harder to answer your question.  Since you're new, please read Jeff's article on how to post a question - he outlines how to ask...

Yuck. Sounds like a terrible idea.
What does your indexing on the table in question look like?

Brian Larson walks through a scenario like this in his SSRS 2012 book.
After some Googling...
http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/mssqlserver/creating-mailing-labels-in-sql/

To the OP - posting your data as attached spreadsheets is a less than ideal way of posting your problem. Please read Jeff's article on how to post...

Without sample data (CREATE TABLE and INSERT scripts), there's no way for us to test your query for you. So all we can give you is reasonably educated guesses. If...

Your parentheses look wrong.

SELECT x.*
FROM 
(     SELECT a
       FROM table1
       WHERE...
  UNION ALL
       SELECT b
 ...

Hard to argue with Jeff's advice.  Maybe spend a week on just text functions and do a whole lot of them. Start easy and then make them more complex as...

Use REPLACE()

Post the Oracle query then. Then modify if that doesn't work. There is a fair amount of overlap between Oracle and SQL Server dialects of SQL.  Try it and if...

This is homework. Give it a try and then tell us what you're having trouble with.

What happens if you use the 64-bit version? The problem with a 32-bit application is that it can only address about 3.5 GB or memory.

For someone who's been around as long as you have, you should know that's not a table.  If people can't recreate your scenario, you're not likely to get an answer. ...