Hello. I am facing a gruesome time in configuring crystal report parameters. Basically, I have dynamic prompts setup as follows:

[1] The Centre (main controller of distributors)
[2] Distributors
[3] Mobile Numbers for customers (my sql table is: Table_MobileNumbers)
[4] Start Date
[5] End Date

When the Centre is selected, it populates a list of distributors, then if distributors are selected, it populates their customers mobile numbers between the Start and End Date.

These parameters work perfectly in ODBC connection. I am able to selected mobile numbers between the search dates. But after I setup JDBC connection the mobile numbers dynamic prompt fails to populate. I have tried to create the report from scratch, but the problem still remains. Can anyone please tell me why this is happening. I am in need of assistance.