What causes [TDS Driver]Unknown escape sequence to be displayed in my custom report?

0 Likes

Problem:

What causes [TDS Driver]Unknown escape sequence to be displayed in my custom report?

Resolution:

ANSWER
----------------------------------
This issue can be caused by the invalid use of place holders in custom reports. For example it is not possible to use ${$DATE} as this is not the correct syntax.

Additional information on the correct syntax is available in the following section of the Issue Manager User Guide:

Help | Documentation | Issue Manager User Guide | Generating Reports & Queries | Creating New Reports | Advanced query writing section

Using the example above this shows that DATE has 2 functions:

$DATE(column) - Returns the date (does not include the time)

or

$DATE("string") - Converts the given string to a database date

So to look for information between two times you could use the following syntax:

(D.DateCreated >= "${startdate|2006-04-01} 00:00" AND D.DateCreated 


This will supply 2 parameters in the Parameters tab which will allow a start and end date to be entered.

Issue has been fixed in Issue Manager 2006 R2.

Old KB# 23677
Comment List
Anonymous
Related Discussions
Recommended