March 27, 2012 at 3:19 am
hi all
i have an ssrs report, which is a dashboard type report with lots of sub reports off the charts etc.
all was working fine when i had only only date parameter - Date from, now when i add a 2nd date parameter - Date To, i am having lots of issues..
first example..
i have a bar chart that has an action assigned > jump to report '2' with 3 parameters
1) user 2) date to 3) date from -- date to and date from both are assigned against the same database field called 'addeddate'
report '2' also has these 3 parameters with a simple query
select (case when owneraccount is null then updatedby else owneraccount end)as owneraccount ,addeddate,
Departmentname ,servicereqno,SubCategory,state
from dbo.q_incidents
where owneraccount = @owner
and addeddate >= @date_from
and addeddate <= @Date_To
when i click on the chart, report '2' opens, but the 'date to' parameter is getting passed the 'date_from' value eg i am getting date between ranges of 01/03/12 and 01/03/12
i cant see why the date_to is getting the wrong date, is it getting mixed up due to being assigned the same database field?
any ideas?
cheers
mal
March 27, 2012 at 3:37 am
think i got a way around it
when assigning the date_to in the action of the chart i assign it as =last(Fields!addeddate.Value) which gives me the last date entry for the selection
if anyone has any other ideas, id still be interested if the above should work, and if not why not
cheers
mal
April 19, 2012 at 12:45 am
I think u should use the parameter value instead of de field value (sometihng like Parameter!Date_To.Value) in the action to pass to the second report.
July 5, 2012 at 8:07 am
Not sure about your requirement in real time .
You can input the date from calendar , instaed of static value ,let it be dynamic !!!
July 5, 2012 at 8:48 am
in the subreport properties are you passing in the parameters from the parent report or some other values?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply