For Complete data of the Database on server1 to Server2:

U should take the backup & Retore

For Some tables only:

Right click on the Server2 database & Select import data. Go...

Search for Installation Guide lines for SQL Server 2005. U may get the links & PDFs or Word Docs from which you can get how to install step by step...

For Cross tab reports you should go for Matrix Reports.

Ex: Ths student attendance report

take the date attribute as cross tab and Student name as Row wise.

...