TsRange and SQL based reporting with Crystal reports

SOLVED

Is there an alternate method to get the same functionality as TsRange when using Crystal reports against the SQL replicator? I was thinking I could use a from-to command but not exactly sure of the syntax.