Geek Answers Handbook

How do I enable SSRS Dataset options using the Timestamp escape clause?

I have the following WHERE CLAUSE SQL Query string in an SSRS dataset:

WHERE "Input_date" >={ts '2009-01-01'}
AND   "Input_date" < {ts '2009-12-31'}

And now, I would like to use the report parameter to wrap the dates in an SQL statement, i.e. @ indate1 and @ indate2.

I tried this, but an error occurs:

WHERE "Input_date" >={ts @indate1}
AND   "Input_date" < {ts @indate2}

Please consult. Thank.

+5
source share
1 answer

What did you do to add these options? I assume that you modified the dataset query with the changes that you posted in your question. To complete this work, you must complete two more steps:

  • . " ". , , . .
  • , . . @indate1 @indate2 , 1.
  • SQL, . , SQL (, Input_date - ):

WHERE Input_date >= @indate1 AND Input_date < @indate2

Visual Studio BIDS 2008. - , , .

+6

More articles:


All Articles