AnsweredAssumed Answered

PIOLEDB and time parameters

Question asked by HenlodeWaal Champion on Apr 30, 2014
Latest reply on May 5, 2014 by HenlodeWaal

I trying to use PIOLEDB combined with SSRS parameters to view 50+ "assets"

 

The expression I'm trying to use is TimeEQ('TAG1',ST,ET,"Running")/86400 similar to PI Time Filtered in datalink

 

in SSRS query designer I have the following query followed by the error

 

2014-04-30 13_44_00-Query Designer.jpg

 

Do I have the right syntax or am I missing something here, the two parameters are dates 1-Apr-2014 and 30-apr-2014. The idea is to use the same expression 50+ times using the same timestamp which will be an input based on the users selection.

Outcomes