Crystal Reports E10 and Data warehouse

Hi, there,

Is there anybody here who is working with data warehouse with Crystal Reports as a tool? Would you please share some experience with me?

I used to work with Oracle reports. It seems to me that Crystal needs to bring all the table data back to client before I may link the tables to get query right.

Another question is how to implement the following requirements:
List all the detail account information for all the accounts under firm A.

Here Firm A might have over 100,000 accounts. The fact tables will holds all accounts for all firms data.

In Oracle reports, we can define 2 path query to get the account number for firm A first then get each account detail by using parent child query. How crystal achieve this kind of query ?

Thanks,Design the report using parent and child tables
Group by the report by key column