Help with parameter 1

[geestrong]

Hello

CRXI with Oracle 9

I am trying to give the user to ability to pick from a drop down parameter list. The issue is that they only want projects that startwith "MP:".

In the Select Expert, it is only selecting projects that start with "MP:". In the Parameter creator, I choose Action and pick Append database values, but the list stops at "G"s and does not go any futher.

Also, I have used the import text file feature, but the issue is the users are always creating project names. I would need to refresh that text file every time they add another project that startwith "MP:".

I need a parameter drop down list to only displays project names starting with "MP:" without using an external text file.

Thanks,
Greg

 

[lbass]

I think you can change a registry key to allow more options in the dropdown box, but another method would be to use a command to create the parameter options. Go to database->database expert->add command and enter something like:

Select
table.`project`
from
`table` table
where left(table.`project`,3) = 'MP:'

Link the command to your main table by linking project to project and then in the parameter creation screen, you can check "dynamic", "new", then use the dropdown to select {command.project} for the value. Then click on the rightmost field (parameter) to create the parameter. Check true for multiple values down below. This should cause only the MP: projects to populate the parameter option list when you run the report.

-LB

 

[geestrong]

lbass

Thanks again. That worked! That is an nice feature.

Greg