<div>
How is the query on the drilldown report?
</div>


How is the query on the drilldown report?

<div>
you can use convert in subreport in available values...
</div>


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

<div>
<div class="content wysiwyg-content">
I have a drilldown report that I am trying to pass a date.<br />
My date from sql is as follows ‘2012-03-19 08:38:46.717’<br />
My sql query returns &nbsp; &nbsp;CONVERT(VARCHAR, el.TimeStart, 105) AS Date<br />
‘19-03-2012’<br />
<br />
I am using a chart and my sort my dates as ‘=Format(Fields!Date.Value<wbr />, &quot;yyyy-MM-dd&quot;)’<br />
<br />
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’<br />
<br />
The problem with this is need to see all users for ‘19-03-2012’<br />
<br />
I’ve tried different thing but nothing appears to work.
</div>
</div>


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.

ssrs dates

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.