Passing dynamic prompts to different sections in a report

[chaitanya]

Hi All

We have a requirement like
creating a single report with different sections and there is a need of passing different parameters to each section to get the results.
Ex:

country,region and zone are 3 sections in a report
underwhich 2006,sales and rank are 3 fields.

Country Region Zone
------- ------ -----
2006 sales Rank 2006 |sales |Rank 2006 |sales |Rank
---- ------ ----- ----------------- --------- --------

655 123 2 650 123 2 650 123 2
30 324 1 30 324 1 30 324 1

dynamic prompts
---------------
country name,manager id etc for country section
and different parameters for region and zone...

Version-- Crystal reports XIR2
Database- Oracle 9i

is it possible to create this kind of report with different sections and passing different dynamic prompts to each section.
Please suggest me.

Thanks in advance

 

[Kempes]

You need to create a parameter field for each,
then select the fields in your selection criteria and point it to the parameter field.
This will diplay prompts for the user running the report based on the values held within the database.

 

[winseelan]

Ohh...by accidently i added the message in this thread...sorry.