I am thinking of buying Crystal Reports. Before I do so, I need to know 3 things.

1) does CR support a multiple data hierarchy? If I have one table with foreign key relations with two or more other tables, can CR print the correct data? The piece of
shi-ite Microsoft Data Report won't support this, and I need it!!

2) how easy is it to add functions and mathematical calculations, e.g. calculating row totals or averages? In the Data Report, if I want to display the average or sum of 4 fields in one record, I have to add a fifth field to the database and then calculate it with code. This is very inefficient and a huge waste of space. Can this be done in CR?

3) in general, is the program worth the steep price? I mean, good grief, it costs more than Microsoft Office!
Is it worth what you have to pay for it?

Looking forward to input from the CR wizards.