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

Displaying data in report before selecting values in prompts

Started by Sarayucog, 18 Nov 2010 05:29:35 AM

Previous topic - Next topic

Sarayucog

Hi gurus,

I have 3 prompts and 3 charts and 1 list report in a single report layout.

My problem is When I am running the report before selecting the prompt values the report is showing the values.

For Example: I have 3 prompts right wich are cascading. First I should select all the values in the prompts and after clicking on the FINISH button only it should display the data in the report, but my report is displaying the data before selecting the values in the prompts.

How to restrict the prompts to display the data after selecting the values in the prompts.

Your help will be appriciated more...

Thanks in advance

MFGF

So your prompts are embedded on the main report page?  I'd guess you must have set their underlying filters to be Optional too?

There are two approaches I can suggest:

1. Move the prompts to a dedicated prompt page, or
2. Add Default Values to each prompt which result in no rows being retrieved

Regards,

MF.
Meep!

Sarayucog

Thankyou for ur quick reply.

Yes I have prompts are embedded in main report page itself. You got it exactly.

Thanks for suggetions also but I can not move prompts from report page to prompt page. That is my req.

I have 3 prompts 1st one is Value prompt, 2nd one is Select and Search prompt and lastly Date prompt.

For value prompt we have default selections and I have applied default selections as empty. Value prompt is working fine, but for Select and Search prompt we don't have the Default selections right. For this how can I restrict.

First when I run the report its not displaying any data, but when I select a value in the value prompt and click on the reprompt button its displaying the data, but here I am not selected any value in the select and search prompt.

How to restrict the select and search prompt. pls tell me this..........


CognosPaul

Another suggestion:

Create a Boolean variable called renderReport. The variable expression should be similar to:
(paramValue('Whatever') is not null and paramValue('Whatever2') is not null) or (paramValue('Whatever 3) is not null

With that example the user must select Param 1 and 2 or select param 3.

Create a conditional block in the page. Set the block variable to the renderReport. Cut the list from the page and paste it into the Yes block of the block.


Sarayucog

Thankyou Paul its working fine.

But my req is when I run the report it should show prompts and empty List and Chart objects. After selecting the values in all the prompts only it should show the data in the List and Chart objects.

Asper your logic first when I run the report it will show the prompts only. After selecting the values in the prompts then it will display the List and Chart objects. This is not my req.

There is concept of hiding and displaying the objects in the report.

Pls try to tell me this...


CognosPaul

Your conditional block has two blocks. Put an empty list and graph in the other one. Nobody said you can't cheat. Add text items to make them look like the other ones.

MFGF

Quote from: PaulM on 19 Nov 2010 12:23:37 AM
Your conditional block has two blocks. Put an empty list and graph in the other one. Nobody said you can't cheat. Add text items to make them look like the other ones.

This gets HUGE admiration from me!
Meep!