Prompt issue using SQL server database

building reports webintelligence
1

Hi

I am parsing the below definition in the BOXIR2 universe.

Databasename.dbo.Tablename.column IN @prompt(‘Select Result Date’,‘D’,mono,free). The column is datatime datatype and it has the values like 04:51:01:053.

when I parse this definiation at the universe level, I am getting the below error:

Parse failed: Exception:DBD, [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ‘01/01/0096 00:0:0’. State:42000

Please help me to resolve this error.

Thanks

stalint (BOB member since 2004-12-14)

2

If u use IN operator then you must use multi. use mono when using = operator.

Your code should be

Databasename.dbo.Tablename.column IN @prompt('Select Result Date','D',,multi,free)

Prashu :india: (BOB member since 2005-08-17)

3

Thanks, I got it

stalint (BOB member since 2004-12-14)