Skip to Content
0
Former Member
Apr 18, 2014 at 06:34 AM

Cascading parameters as dropdown list

154 Views

Hi,

I am creating a crystal report in which I have to create four cascading dropdown lists as parameters. The issue that I am facing is, the database table from where I have to fetch the data for these dropdowns is not normalised. Hence all the data, that is required to show in these four cascading drop down lists are coming from one single table.

Which is a better way to create these cascading parameters?

1. Creating four different queries in add command for each dropdown list?

2. Creating a single query with self join four times?

Here, just to select the parameters by user, the cascading dropdown lists is taking to long to open each time (around 5 mins). How this Add command-Sql query works internally in crystal reports? How to increase the performance?