Filtering
Hi All,
I am trying to filter on one of the dataset, but i have to do "today's date"...
Fields!cur_prm_shp_dt.value >= "todays date"
or
Fields!cur_prm_shp_dt.value >= "systems' date"
the problem with that one is that the system date view is in another dataset and does not join to the table that i get cur_prm_shp_dt from.
Any suggestions?
Thanx ahead of time, Kerrie
[400 byte] By [
KerrieS.] at [2007-12-16]
What do you need is a parametrized report?
Why do you have different datasources and whant to join that?
Can't you make all the query in the same datasource?
Ok, I understand.
And I told you that you can set a parameter which takes the date from a datetime picker.
In each data set you should define a parametrized query which takes this parameter.
WHERE ts.startdate >= @dateParameter
Then you can move through differents days and not only the current date.
I hope it helps you
