Powerpromts using recordset

[vinay17in]

Hi,

We are creating a multiselect prompt for which data being populated using Recordset (Not creating any dynamo).

Our table from which data is being selecetd in recordset has 400 records but the prompt shows only 100 records.

We have found that even recordset is having 100 records in it by running a for loop like
for(i=0;!rs.EOF;i++)
{
rs.MoveNext();
}
and then printing 'i' gives us the number of records in recordset as 100.

Can you suggest us why this is happening.

Regards,

 

[griffindm]

Impromptu has a default picklist limit of 100 rows, set in the impromptu.ini. Perhaps another default behaving similarly is affecting PowerPrompts.

Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"

http://www.decisionsupportgroup.com

 

[vinay17in]

Thanks dave, I was knowing about that.But there is nothing I could find for powerrpomts, I have opened a case with cognos also.

Anyways thanks for your suggestion.

Regards