Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameter field prompt order

Status
Not open for further replies.

MSBrady

Technical User
Mar 1, 2005
147
US
CR 10
Access

Oy!

Is there a way to control the order that parameters prompt at run time? I have 8 parameters {?Client}, {?SortField1} - {?SortField6}, and {?ReportType} and I want {?Client} 1st {?ReportType} 2nd and the remaining {?SortField} parameter in order from 3rd to 8th.

thanks,
.batman
 
Nevermind....brain fart. Alt+Up or Alt+Down
 
Yeah weird that those aren't being displayed.
 
Sorry, I was thinking of Right clicking and selecting Move Up/Down (shows the hot keys as well).

-k
 
An extension of MSBrady's question:

What has been discussed here works for me when using the GUI to link tables, but if I use ADD COMMAND and have created parameters there (in CR9), it seems that the parameters automatically get ordered alphabetically. You can change them by the method above, but when you save and reopen the report, they've changed back to alphabetical. As well, if you have other parameters that are created in the report outside of the ADD COMMAND, they appear first and in whatever order you specify and then the ones from the command appear alphabetically after that.

Is this normal, or have a got something wrong?

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top