i have an ssrs report where i pass two date variables 1) date_from 2)date_to
the parameters work fine on the dashboard home page, but when i access a sub report from a graph etc they return no data..
if i take one of the dates out it returns as expected..
eg a basic example of one of the subreport data is
select (case when owneraccount is null then updatedby else owneraccount end)as owneraccount ,cast(convert(char(11), addeddate, 111) as datetime)as addeddate,
where owneraccount = @owner
and addeddate >= @date_from
and addeddate <= @Date_To
i have linked both the date parameters to the same date field action part of the graph
and if i run the query simply from data section it also returns the correct information!
am i doing something silly? its been a long week!! :)