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?