COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: srinu1253 on 12 Aug 2015 11:32:10 AM

Title: Does Data drop down list can dynamically selects first value?
Post by: srinu1253 on 12 Aug 2015 11:32:10 AM
Hi,

Is it possible to dynamically selects the first value in the data drop down list in Active Reports?
Can you let me know on this?

Thanks
Title: Re: Does Data drop down list can dynamically selects first value?
Post by: MFGF on 13 Aug 2015 03:04:57 AM
Quote from: srinu1253 on 12 Aug 2015 11:32:10 AM
Hi,

Is it possible to dynamically selects the first value in the data drop down list in Active Reports?
Can you let me know on this?

Thanks

Hi,

Not quite sure what you are asking here. If you mean is it possible to filter the contents of a data dropdown list, then yes - you can do this by setting an Active Report variable which filters your control.

Cheers!

MF.
Title: Re: Does Data drop down list can dynamically selects first value?
Post by: srinu1253 on 13 Aug 2015 11:12:57 AM
Hi,

Our reports are single sign on Reports & data would change based on Rep's login:

Actually we have a report which is taking longer time to render. We found that if we set a default value for the Data Drop down list (Prompt) the report is taking less time to render. But the default value is different for each individual Rep.

So Can we have a Data drop down list (Prompt) that can dynamically selects first value so that the report renders in less time.

Thanks
Title: Re: Does Data drop down list can dynamically selects first value?
Post by: MFGF on 14 Aug 2015 03:29:50 AM
Quote from: srinu1253 on 13 Aug 2015 11:12:57 AM
Hi,

Our reports are single sign on Reports & data would change based on Rep's login:

Actually we have a report which is taking longer time to render. We found that if we set a default value for the Data Drop down list (Prompt) the report is taking less time to render. But the default value is different for each individual Rep.

So Can we have a Data drop down list (Prompt) that can dynamically selects first value so that the report renders in less time.

Thanks

So it's not a data drop down list in your active report? It's a prompt?

Sounds to me like you need to change the report to a bursted report without a prompt and create separate MHTs for each rep?

MF.