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

Cascading Date Prompts

Started by pw, 20 Sep 2006 04:57:42 PM

Previous topic - Next topic

pw

Hello Folks,

i have a table with 2 columns (name, timestamp)  name is varchar, timestamp is TIMESTAMP (Oracle 9.2i Enterprise)

I want to create a prompt page with 3 dropdowns:

1. all distinct names (works fine, set to autosubmit)   parameter: ?name?
2. all timestamps for the name selected at 1. dropdown (works fine)  parameter: ?t1?
3. all timestamps that are older than the timestamp selected in 2.    parameter ?t2?

when i get to select the first timestamp (2. dropdown), the third dropdown always stays empty (data is ok, and should be displayed)


the 3. dropdown uses the parameter of the first. there are two filters in this query, one for the name-parameter  , something like [name]=?name? and a second one  [timestamp] < ?t1?

i think reportnet messes around with the timestamp column in the way, data is compared.
if i check the generated sql it says something like


select distinct "C__en__T_TEST"."UNC_PATH" AS "UNC_PATH", "C__en__T_TEST"."T_STAMP" AS "T_STAMP", "C__en__T_TEST"."T_STAMP" AS "T_STAMP1"
from "gosldw"."dbo"."T_TEST" "C__en__T_TEST"
where "C__en__T_TEST"."UNC_PATH" = 'testValue' and {ts '2000-01-01 00:00:00.000'} > "C__en__T_TEST"."T_STAMP"

this is a MSSQL 2000 Server Test-System. Normally, when the t1 value is filled in, it should work.

can anyone help?

thanks a lot,
cheers
-pw