reporting services - SSRS sort by last date available -

reporting services - SSRS sort by last date available -

i have columns name, description , message. in order see these columns in ssrs date filter applied. when date short error. error: execution terminated provider because resource limit reached. question is: possible cut down info filter lastly date exist in database. in way info filter applied lastly existing date in database, , error eliminated.

thanks in advance.

edit1:

time stamp | name | description | message |

11/12/2011 10:50:51 | ebkbh 2349| pump |functional|

01/08/2012 10:50:51 | zdfwh 2989| sensor | closed |

and lets 1/08/12 lastly date in database, in filter select date between 01/01/13 - 02/02/13 app runs long , gives me error mentioned earlier

i not getting why doing openquery when can select multiple datasources in ssrs.

i simpler that.

set datasource table date, , 1 if actual info elsewhere.

set dataset, phone call 'maxdate', lastly date like:

select max(date) maxdate (tablename)

this gives max date whole table sounds want.

set parameter gets dataset in 2. selecting parameter utilize 'get values query'. select utilize maxdate id , label.

now set dataset main query , predicate like:

where dt between @start , @maxdate

you can set @start parameter whatever want date values @maxdate bound max date specified.

** optional: set date field @end , default value of @maxdate if want flexibility not have utilize @maxdate. create 3rd variable, @end, , in 'default values' pane take 'specify values'. nail 'fx' (expression) button, , take parameters!maxdate.value , default max date. take prior date well.

i set of reports defaults dates shared dataset maintain them running on set date ranges.

ssrs-2008 reporting-services