cascade parameter with date restriction

GuB

Hi

I try to make a report using cascade parameters and wand to add a date specific parameter.
My only problem is, that if I add a date parameter and then use my cascade parameter group
(customer, product, ...) the date parameter value gets evaluated at the report start
, but if I want to change the date restriction in a second run, it stays the same, although I changed the date value.

Therefore I tried to add the date restriction to the cascade parameter group, but there I can only apply parameters which belong to a datasource!
Is there a way to assign a single parameter of type Date without assigning a datasource?

Rgds

Guenter

PS: I am using the beforeOpen methode in the datasets of my cascade parameters and added there the date restriction like the following:

this.queryText =
"select s.customer,
from dwh.scrap s
where s.error in ('"+ params["errors"].toString().replace(/,/g,"','") +"') and
s.startDay_scrap Between STR_TO_DATE(concat((DATE_FORMAT('"+ params["start"].value +"', '%Y/%m/%d')) ,' 06:00:00' ), '%Y/%m/%d %H:%i:%s') and STR_TO_DATE(concat((DATE_FORMAT('"+ params["end"].value +"', '%Y/%m/%d')) ,' 06:00:00' ), '%Y/%m/%d %H:%i:%s');";

averma

Hi Guenter,
You should be able to rerun the same report with new parameter values. I am attaching a sample report that uses a couple of cascading parameters along with a date parameter that is not tied to any data source. Parameter values are used to filter the data set. Let me know if I have a correct understanding of your issue.

Ashwini