Cognos displays Text prompt instead of value prompt -


i have list report built using simple sql , not using package, displays 10 records , columns , 'username' 1 of columns (query item). added filter in detailed query expression window [username] = ?user_name?.

when report run, should display value prompt (a drop down select value) but, interestingly, cognos shows text prompt. why behavior? please advise how make drop down.

what happened here did not explicitly create prompt element filter criterion on prompt page. before cognos executes report checks whether parameters (e.g. ?filtername?) declared in filters have matching prompt on prompt page. parameters without prompt elements create default 1 (on fly) , apparently chooses easiest possible variant text attribute text box prompt.

if want have drop down box have create prompt element dragging value prompt prompt page , follow wizard pop up. make sure choose parameter name have used in filter.


Comments

Popular posts from this blog

c++ - QTextObjectInterface with Qml TextEdit (QQuickTextEdit) -

javascript - angular ng-required radio button not toggling required off in firefox 33, OK in chrome -

xcode - Swift Playground - Files are not readable -