SQL Command Parameters

[SarahS81]

I am using an SQL command to retrieve data for a report in CR 9. It has two parameters, Start Date and End Date. My report continually prompts for End Date first and start date second, even if I right click on start date parameter and select to move it up in the report. This order is not saved in the report, it seems to revert to the alphabetical order of parameters in the sql command. Logically this is annoying and is not preferred as far as ease of use for clients - any thoughts on how to force the order of this without having to rename my parameters so alphbetically start date appears and is prompted for first?

 

[bdreed35]

As a real simple solution, rename the "Start Date" parameter to "Begin Date". If it is truly alphabetical, this should solve your dilemma.

~Brian

 

[Turkbear]

Hi,
I think that CR prompts for parameters in the order the parameter was created, not how it is used or named.
Delete both parameters and recreate them in the order you want to be prompted.

 

[kenhamady]

I replicated your problem in v9, and then opened the same report in v10 and the parameters showed up in the correct order. Probably a bug in v9.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[tektipdjango]

When you're in desgne view click on the parameter icon on the left list and select the param.
In the small window click on default values
In this second window on the bottom right there are the sort options for the default parameters either alpha or no sort. Click on no sort and save after having check the order on the default param list.
You can also put a description and choose to show only desc or values or both

--------------------------------------------------
[highlight]Django[/highlight]
bug exterminator
tips'n tricks addict​

 

[kenhamady]

I don't think he wants to set the order of default values. You wouldn't have default values for Start and End Date. He wants to set the order that the 2 parameters appear in the initial parameter window.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[SarahS81]

That is true - just the order the parameters are prompted for. Looks like it defaults back to alphabetical even if you adjust the order in the report and save it. No choice here but to rename my parameters.

Thanks for the tips