Apply the "Select Expert" in database server not in the report after pulling all the records

[Former Member]

Hi,

I use CR 2008, I need to have optional parameters, so I used the select expert parameters instead of using parameters in the command.

I face slowness in the reports specially for large number of records, after searching the internet, I found some posts saying that in case of using "Select Expert" ALL the data is transferred first to the report, then the Select Expert filter is applied, is this correct?

If it is correct, how to apply it in the database and keep the parameters optional?

Thank you

[abhilash_kumar · Accepted solution]

Hi Khalid,

You're correct - you should not use the select expert to filter records when the datasource is a command object.

Optional prompts, however, cannot be created inside the Command Object. What you can do, though, is setup a 'default' value for the prompt and modify the SQL's where clause to handle this default value. Like so:

WHERE (table.field = {?Prompt} OR 'All' IN {?Prompt})

To add the Default value 'All', expand Field Explorer > Right-click the prompt > Edit > Scroll down and look for 'Default value'; Add the text in here.

-Abhilash

[Former Member · Accepted solution]

Thank you Abhilash

[DellSC]

And here's more info about how to work with Commands in Crystal: https://blogs.sap.com/2015/04/01/best-practices-when-using-commands-with-crystal-reports/

-Dell