limits on number of records in Prompts?

[venkiatmaruthi]

Hi,

Is there any limit on number of records that prompt can show like Value prompt, Tree Prompt?

[CognosPaul]

Tree prompts have a set maximum that you can alter in the package settings. Click on the "More..." next to the package, and then on "Modify the package configuration". There you'll be able to set the default and maximum number of members returned in a tree prompt. It will return the default number of members each time you click on the "more" button.

Value prompts (and Select&Search prompts) have a default maximum of 5000 rows. You can change that by changing the rows per page setting. IBM warns that putting a greater value may cause unexpected results though.

[venkiatmaruthi]

Hi PaulM,

Thanks a lot for your help.

I am unable to find the option of More and Modity Package configuration options...

I have a problem with Tree prompt in my report. It's showing only 60 items for level. even though I have 76 items.

can you please elaborate on this? where can I found the above options... in Framework Manager or Report Studio?

[bdbits]

The "More.." is in Cognos Connection. It is in the Actions column for the package. When you click that you get a number of options, pick "Modify the package configuration..." and you will see the items PaulM mentioned.

The prompt rows are a property on the control in Report Studio.

[venkiatmaruthi]

Really Thankfull to you all.... It worked well.

Thanks you very much.