ssrs dates

aneilg
aneilg used Ask the Experts™
on
I have a drilldown report that I am trying to pass a date.
My date from sql is as follows ‘2012-03-19 08:38:46.717’
My sql query returns    CONVERT(VARCHAR, el.TimeStart, 105) AS Date
‘19-03-2012’

I am using a chart and my sort my dates as ‘=Format(Fields!Date.Value, "yyyy-MM-dd")’

But the problem is when I pass in the date to the sub report. I don’t get any results for ‘19-03-2012’ only ‘2012-03-19 08:38:46.717’

The problem with this is need to see all users for ‘19-03-2012’

I’ve tried different thing but nothing appears to work.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2011

Commented:
How is the query on the drilldown report?
Technical MAnager
Commented:
instead of Convert use CAST function like

cast(el.TimeStart as date) as date1
nishant joshiTechnology Development Consultant

Commented:
you can use convert in subreport in available values...

Author

Commented:
thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial