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

Set Date prompt to query data item

Started by axxo, 01 Apr 2009 06:24:00 PM

Previous topic - Next topic

axxo

I have a query that finds the maximum start for financial year. What I want to do is to take that result and make it the default selection in my date prompt in my prompt page.

Does anyone know how to achieve this??

prakashraju987

Explain Breifly and will find the solution

david.stachon

Using the out-of-the-box date prompt objects I think you may be out of luck as you cannot attach a query to them.

axxo


Thanks for replies. Someone in my team says they have seen soemone else do itand we are waiting to hear back about it. Of course will post the answer if there is a working solution.

david.stachon, where can I get an out of the box prompt :o Please tell :)

prakashraju987, I have data spanning, lets say, 20 years. There is going to be 20 dates with first of July in this data source. What I want to do is find the latest most recent "first of July" (and I've done that already in a query)

The Problem: I want to take that result from THAT query and use it as the default selection in my date prompt.

david.stachon

...you know what you could do, instead of using "date prompts",

have three normal drop down lists:

one for each day, month and year. Those are easy enough to set values on. (and, very common on web-sites so people know how to use them)

As for setting it up on date prompts....you're looking at probably SDK or j-script. Both of which, means coding and probable difficulties in upgrading.

good luck!