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
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.