Extensive Report

I am putting together a program using a database with several tables. In the end I need to generate a documnet/report for one member of the Database which will include data from two existing tables, and then I will need to print two entire tables that will be generated/calculated at runtime. I will also need to break the pages into columns, and print quite a lot of text, that will change according to selections made during runtime. I know this is possible, because I have been looking at a program that does this. I cannot duplicate it however. The Data Report and the included Crystal Reports seem inadequate for what I need to do. What program add-in am I going to need to do this. Will Crystal Reports 8 do this? Any ideas? I am not looking for a quick fix, but what I need to learn to do the best job.

Thanks

Well, I am Using Cristal Report for my projects. And I found it best for ralational data base. You should use visual linking for this kind of reports. Visual linking helps a lot for making a good report. You not need to make temporary tables or any thing else. Just create a report and send parameters or sqlquery or selection formula for a condational report.