parameter help!!!!

[lyu]

I have a stored procedure which takes a parameter studentID(number). However, my users have a hard time memorizing all studnetIDs, instead, they'd like to input studentName as parameters. Assume the studnetID and studentName relationship is stored in a table studentInfo, is it possible that a user inputs studentName, and crystal report looks up the corresponding studnetID from the table and then feeds studentID to my stored procedure? Or are there any other ways which can achieve the same thing?

I don't want to change my stored procedure to accept a studnetName parameter since this stored procedure is used in many other places, and I don't want to disrupt all others...

Thanks a lot!!!

 

[synapsevampire]

You can prepopulate the values with a static list in CR 10 and below, CR XI allows for dynamic parameters, so please remember to at least post your software version.

One method you might like is to select the default values button on the create parameter and then you can either read in a text file of the IDs and names, or read directly from a table and then select that the Description (names) be displayed, but the ID is the parameter.

Names can be problematic of course because of duplication.

-k

 

[lyu]

Sorry, I am using CR 10.

Can you explain more of the default value method? I can load all StundetIDs from the studentInfo table and add them as the default values of parameter StudentID, but how can I load the descriptions? All my description for these defualt values are empty, and of course I cannot set them one by one.

Thanks again.

 

[lbass]

You can create a separate report of IDs and names with no column labels, export it to a text file, use find/replace to remove the "", and then in the set default section of the parameter expert, import the text file.

-LB

 

[synapsevampire]

You can do so by using a text file, as in:

http://support.businessobjects.com/library/kbase/articles/c2006499.asp

Should step you through it, I know, it's ugly, but that's life in CR 10 and below...

-k

 

[lyu]

Thanks, that helps a lot!