I'm new to Crystal Reports and have dug through some examples and seen some designed reports.

However I want to answer a relatively basic question:

Is it possible in Crystal Reports to design a report which dynamically selects the tables based on parameter selection lists which are presented to the user.

I'll use a more simple example than the actual solution required.

Imagine I'm populating a parameter dialog which presents a list of Customers, MyBank & BigBank

If the user selects MyBank then the query for the report should drive off MYBANK_STATISTICS.

I'm using a simplified example here. In reality there are 100's of tables so we're looking for a "Counter Browser" type functionality.

Is this possible or are Crystal Reports always bound to a defined set of tables at design time?

thanks in advance

Thanks very much for responding and for the information.

Is it even possible in Crystal Analysis Professional? Someone has mentioned this as a possible solution.