If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Best Way to Refresh a report

Started by Peewee71, 07 Jul 2011 11:31:16 AM

Previous topic - Next topic

Peewee71

Hi,
I have a one page report which contains various prompts and a list. Example prompts are from_date and to_date. When the list report displays for the first time it displays all items in the list. If there are lots of rows in the list the user wants to enter a from_date and to_date which will refresh the list and filter down the rows to a manageable number. The prompts and the list are on the same page. Whats the best way to achieve this?

I think what i'm after is to get an onchange event on a prompt which will refresh the list. Is it possible? If so how?

alok

Put filters on list as per date selection and give "Auto submit " to 'Yes'.It will work:)


bdbits

What alok said. And you may also want to use a render variable to suppress the report retrieval until they select their date range. This will save a database query. For example:
* Create a render variable, call it PromptsAreNotNull.
* Create an expression like: ParamValue('pFromDate') is not null and ParamValue('pToDate') is not null
* Select your data container (crosstab, list, etc) and click the ... on Render Variable.
* Select the vPromptsAreNotNull variable, and check "Yes" in "Render for" and click OK.
* You might also want to set "No Data Contents" to "Yes" and provide some text on the data container explaining that prompts need to be selected.