Blank or empty choice in List Box Parameter

Why is there a blank or empty choice in my list box parameters, and how do I get rid of them? My dataset does not include a blank option.

Please do not refer me to Anthony Ku Ong's dev share blog.

I'm using BIRT 2.6

Regards,
Bruce

Find more posts tagged with

Comments

mwilliams

Hi Bruce,

You're using a dynamic list box parameter, I take it? Do you have a default value? Is the parameter required?

scowsailor

Hi Michael,

sorry to take so long to reply. To answer your question, yes dynamic listbox. The parameter is NOT required although selecting the blank choice in the list produces a popup error informing the parameter cannot be blank. I'd like to set the default to something like 'ALL', but I can't because the actual dataset data type is integer.

This must be a common request. I've tried to search the topic in the forum, but I haven't found any solutions or suggestions yet.

Regards,
Bruce

mwilliams

Hi Bruce,

One simple workaround could be to make the parameter of type string, convert the integers to strings for the parameter, add the default as "all", then when the selection is made, if it's type all, do one thing, if it's not all, change it back to an integer and pass it to your query.

scowsailor

Thanks again Michael! Great suggestion. I was going to get there eventually. : )

Regards,
Bruce

mwilliams

Bruce,

Not a problem. Always glad to help! Let us know whenever you have questions!