subdataset parameter

[megotronx]

hey all

i want to pass the parameters to the subdataset queryy to work in crosstabing, but i can`t deal this.

 

then i write this it doesn`t work.i have the blank crosstab with no data

 

test.testdat=to_date($P{Datefrom},'yyyy-mm-dd')

 

but than i write it without parameter

test.testdat=to_date('2007-07-10') it works fine

 

I SOLVED THIS

needed to add the expression $P{Datefrom} into default expression.....

Post edited by: megotronx, at: 2007/07/10 14:34