Displaying Multiple Categories (from seperate tables) to be viewed on one page

Hello.

I just created separate tables for each of my categories and wanted to know how to return them all to be viewed on one page using the SQL Datasource (or whatever) This is for user accounts. I just need to know that part.

Sincerely,

Computergirl

use UNION ALL

select * from table1

union all

select * from table2

Display groups in seperate pages

Hi all
I am working on Crystal reports 8.5
I have 4 groups,need to display every group in seperate pages
Could any one pls help meright click on the report and select the "section expert" option. In this, you select your group header and on the right side tick the "new page after" option. Click on the corresponding button for the option and enter "Not OnFirstRecord".|||Thank you
it works fine